select p.id as [Post Link] , owneruserid as [User Link] ,...

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 p.id as [Post Link]
     , owneruserid as [User Link]
     , v.bountyamount
     , vs.userid as [User Link]
from posts p 
inner join votes v on v.postid = p.id
inner join votes vs on vs.postid = p.parentid
where v.votetypeid = 9 -- bounty
and vs.votetypeid = 8
and p.owneruserid = ##userid:int?2415822## 
order by v.bountyamount desc

Enter Parameters

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