Top bounty hunters

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 TOP 100 id,DisplayName,

(select sum(BountyAmount) from votes 
where votetypeid=9
and (select TOP 1 OwnerUserId from posts where id = votes.postid)=users.id 
) as "Rep from bounties",

(select sum(BountyAmount) from votes 
where votetypeid=9
and (select TOP 1 OwnerUserId from posts where id = votes.postid)=users.id 
)*100.0/Reputation as "% Rep from bounties"

from users
where reputation > 20

order by (select sum(BountyAmount) from votes 
where votetypeid=9
and (select TOP 1 OwnerUserId from posts where id = votes.postid)=users.id 
) desc

Enter Parameters

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