Top users by tag

1

Please login or register to vote for this query.

(click on this box to dismiss)

Christianity

Q&A for committed Christians, experts in Christianity and those interested in learning more

select top 30 u.id as [User Link],  
       u.WebsiteUrl,
       t.TagName,
       sum(score) totscore
from Posts p, PostTags pt, Tags t, Users u
where p.CreationDate > DATEADD(year,-1,GETDATE())
AND PostTypeId = 2 -- answer
AND p.ParentId = pt.PostId
AND pt.TagId = t.id
AND p.OwnerUserId = u.id
AND t.TagName = ##tag:string?python##
group by u.id, 
         u.WebsiteUrl,
         t.TagName
order by totscore desc
select top 30 u.id as [User Link],  
       u.WebsiteUrl,
       t.TagName,
       sum(score) totscore
from Posts p, PostTags pt, Tags t, Users u
where 1=1
AND PostTypeId = 2 -- answer
AND p.ParentId = pt.PostId
AND pt.TagId = t.id
AND p.OwnerUserId = u.id
AND t.TagName = ##tag:string?python##
group by u.id, 
         u.WebsiteUrl,
         t.TagName
order by totscore desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results