1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

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

fork query

created may 26 20 jon.doe33775