Top users for algorithm tag from July 2013

0

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

SELECT TOP 1000
  u.Id AS [User Link], 
  SUM(Score) AS TotalScore
FROM Tags t
  INNER JOIN PostTags pt ON pt.TagId = t.id
  INNER JOIN Posts     p ON p.ParentId = pt.PostId
  INNER JOIN Users     u ON u.Id = p.OwnerUserId
WHERE 
  TagName = 'algorithm'
  AND p.PostTypeId = 2 -- answer
  AND p.CommunityOwnedDate IS NULL -- not community wiki
GROUP BY u.id, TagName
ORDER BY TotalScore DESC;

Enter Parameters

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