0

Please login or register to vote for this query.

(click on this box to dismiss)

Top 100 by votes users in tag c#

Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática

SELECT TOP 1000
    Users.Id,Users.DisplayName,Users.Reputation From Users where exists 
(
SELECT u.id
FROM Tags t with (nolock)
    INNER JOIN PostTags pt with (nolock)ON pt.TagId = t.id
    INNER JOIN Posts p with (nolock) ON p.ParentId = pt.PostId
    inner join Users u with (nolock) on u.Id = p.OwnerUserId
WHERE 
    p.CommunityOwnedDate IS NULL
    and t.Id in (select Id from Tags where TagName in ('java', 'c++', 'c', 'c#'))
)

fork query

edited apr 25 12 anonymous

created aug 6 11 abatishchev