Top answerer of HNQs

1

Please login or register to vote for this query.

(click on this box to dismiss)

Blender Meta

Q&A about the site for people who use Blender to create 3D graphics, animations, or games

SELECT TOP(##num?500##)
  a.OwnerUserId AS [User Link],
  a.OwnerDisplayName,
  COUNT(a.Id) AS Count,
  SUM(a.Score) AS Score
FROM Posts q INNER JOIN Posts a ON a.ParentId=q.Id
WHERE
  q.Id IN (SELECT p.Id
  FROM Posts p JOIN PostHistory ph ON p.Id=ph.PostId
  WHERE (ph.PostHistoryTypeId=52))
GROUP BY a.OwnerUserId, a.OwnerDisplayName
ORDER BY COUNT(a.Id) DESC

Enter Parameters

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