Bounties Earned

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select posts.id as [Post Link],posts.creationdate as 'Answer Date',donors.bountyamount as 'Bounty Offered',donors.creationdate as 'Bounty Date',recipients.bountyamount as 'Bounty Awarded',recipients.creationdate as 'Award Date',donors.userid as [User Link]
  from ((votes recipients join posts on recipients.postid=posts.id and recipients.votetypeid=9)
    left join votes donors on donors.postid=posts.parentid and donors.creationdate<recipients.creationdate and donors.votetypeid=8)
  where posts.owneruserid=##UserID##;

Enter Parameters

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