0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for information security professionals

SELECT DISTINCT 
    u.Id AS [User Link],
    u.DisplayName,
    'https://stackoverflow.com/users/' + CAST(u.Id AS nvarchar) AS [Profile URL]
FROM 
    Users u
JOIN 
    Posts a ON u.Id = a.OwnerUserId
JOIN 
    Posts q ON a.ParentId = q.Id
JOIN 
    PostTags pt ON q.Id = pt.PostId
JOIN 
    Tags t ON pt.TagId = t.Id
WHERE 
    u.Location LIKE N'Ukraine'
    AND (t.TagName = N'wpf' OR t.TagName = N'c#')
    AND a.PostTypeId = 2
ORDER BY 
    u.Id

fork query

created mar 31 Denis.Dinkevich