0

Please login or register to vote for this query.

(click on this box to dismiss)

https://meta.stackexchange.com/questions/307406/list-of-past-bounties-on-a-se-site/307426?noredirect=1#comment999884_307426

Q&A for professional mathematicians

select top ##maxrows?100##
       v.postid as [Post Link]
     , v.bountyamount
     , v.creationdate
     , v.userid [User Link]
     , w.postid as [Post Link]
     , w.bountyamount
     , p.owneruserid [User Link]
from votes v
left outer join posts p on p.parentid = v.postid
left outer join votes w on w.postid = p.id
where v.votetypeid = 8 
and v.creationdate > dateadd(mm, -6 , getdate())
and (w.votetypeid = 9 or w.votetypeid is null)
order by creationdate desc

view current version

edited feb 27 18

created feb 27 18 rene