Top Sponsors

1

Please login or register to vote for this query.

(click on this box to dismiss)

A list of users that have paid bounties on other users' questions, sorted by total rep manually awarded, then by date.

Amateur Radio

Q&A for amateur radio enthusiasts

/*
select * from (

select q.Id,
       q.CreationDate,
       q.OwnerUserId AskerId,
       bo.BountyAmount,
       bo.CreationDate BountyStart,
       bo.UserId BountyOwner
from Votes bo inner join Posts q on bo.PostId = q.Id
where q.PostTypeId = 1 -- Question
  and bo.VoteTypeId = 8 -- BountyStart
--  and q.OwnerUserId != bo.UserId
) subQ

*/

select 
  votes.PostId, 
  votes.BountyAmount, 
  votes.UserId [User Link],
  votes.CreationDate DateOpened,
  posts.Title Title,
  posts.OwnerUserId QuestionOwner,
  posts.CreationDate QuestionDate
from votes 
  inner join posts on votes.PostId = posts.Id  
  inner join users on votes.UserId = users.Id
where votetypeid = 8 and votes.UserId != posts.OwnerUserId
order by PostTypeId

Enter Parameters

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