4

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

Q&A for those who study, teach, research and apply economics and econometrics

-- 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

fork query

created aug 30 11 Jason Down