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.

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

fork query

edited jan 7

created jan 7 peterh - PLEASE DELETE THIS ACCOUNT