Top Answerers for a Given Tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Stats of a Tag only gives the Top-20 answerers. This query can list more of them and give other info as well.

Mythology

Q&A for enthusiasts and scholars of mythology and folklore

SELECT TOP ##n##
  Users.Id as [User Link],
  COUNT(Answers.Id) as Answers
FROM Tags    
  JOIN PostTags ON PostTags.TagId = Tags.Id
  JOIN Posts ON Posts.Id = PostTags.PostId 
  JOIN Posts as Answers ON Answers.ParentId = Posts.Id
  JOIN Users ON Users.Id = Answers.OwnerUserId
WHERE    
  Tags.TagName = '##TagName##'
GROUP BY 
  Users.Id
ORDER BY 
  Answers DESC

Enter Parameters

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