axon answers count

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy Meta

Q&A about the site for science fiction and fantasy enthusiasts

--DECLARE @TagId int = ##TagId##

SELECT OwnerUserId, DisplayName, COUNT(OwnerUserId) as NumAnswers FROM Posts
  INNER JOIN Users ON Users.Id = OwnerUserId
WHERE Posts.Id IN (
  SELECT Posts.AcceptedAnswerId
  FROM
    Posts
    INNER JOIN PostTags ON Posts.Id = PostTags.PostId
    INNER JOIN Tags ON PostTags.TagId = Tags.Id
  WHERE 
  TagId = '83655' -- [axon] tag
  --TagId = @TagId
)
GROUP BY OwnerUserId, DisplayName
ORDER BY NumAnswers DESC

Enter Parameters

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