Won most bounties before the "Unsung Hero" badge

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

SELECT
  Badges.UserId AS [User Link],
  SUM(BountyAmount) AS BountiesRep,
  COUNT(*) AS BountyCount,
  MIN(Badges.Date) AS UnsungHeroWon
FROM Votes, Posts, Badges
WHERE
  Votes.PostId = Posts.Id
  AND
  Votes.VoteTypeId = 9
  AND
  Badges.UserId = Posts.OwnerUserId
  AND
  Badges.Name = 'Unsung Hero'
  AND
  Votes.CreationDate < Badges.Date
  AND
  Votes.BountyAmount > 0
GROUP BY Badges.UserId
ORDER BY BountiesRep DESC

Enter Parameters

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