Top 100 Users In A Given Tag

3

Please login or register to vote for this query.

(click on this box to dismiss)

What better way to learn interesting things about tags you are interested in than to check out the top 100 users in that tag? Inspired by this query: http://data.stackexchange.com/stackoverflow/s/1688/c-top100-users

Stack Overflow

Q&A for programmers

-- Top 100 Users In A Given Tag
-- 
-- What better way to learn interesting things about tags you are interested in than to check out the top 100 users in that tag?
--
-- Inspired by this query:
-- 
-- http://data.stackexchange.com/stackoverflow/s/1688/c-top100-users

DECLARE @TagName nvarchar(25) = ##Tag:string##

SELECT TOP 100
    u.Id as [User Link],
    COUNT(*) AS UpVotes 
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 Votes v with (nolock) ON v.PostId = p.Id and v.VoteTypeId = 2
    inner join Users u with (nolock) on u.Id = p.OwnerUserId
WHERE 
    p.CommunityOwnedDate IS NULL
    and t.TagName = @TagName
GROUP BY u.Id
ORDER BY UpVotes DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached