"Unsung Hero" holders by their estimated rep as they got the badge

1

Please login or register to vote for this query.

(click on this box to dismiss)

Rep is estimated by the got upvotes * 10. It is not a very huge difference.

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

SELECT Posts.OwnerUserId AS [User Link], 10 * COUNT(*) AS EstimatedRep
FROM Badges, Posts, Votes
WHERE
  Badges.Name='Unsung Hero'
  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 meta site
loading Hold tight while we fetch your results