"Generalist" badge holders by the estimated rep as they got the badge

1

Please login or register to vote for this query.

(click on this box to dismiss)

Cognitive Sciences Meta

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

SELECT Posts.OwnerUserId AS [User Link], 10 * COUNT(*) AS EstimatedRep
FROM Badges, Posts, Votes
WHERE
  Badges.Name='Generalist'
  AND
  Badges.UserId = Posts.OwnerUserId
  AND
  Votes.PostId = Posts.Id
  AND
  Votes.CreationDate < Badges.Date
GROUP BY Posts.OwnerUserId
ORDER BY EstimatedRep DESC, Posts.OwnerUserId

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results