List of past bounties on a SE site


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for professional mathematicians

with awarded as
select v.postid
     , v.bountyamount
     , v.creationdate
     , p.parentid questionid
     , p.owneruserid 
     from votes v
     inner join posts p on = v.postid 
     where v.votetypeid = 9 -- award 

select top ##maxrows?100##
'site://q/' + cast(v.postid as nvarchar)+ '|' + q.title as [Question]
     , v.bountyamount
     , v.creationdate
     , v.userid as [User Link]
     , a.postid as [Post Link]
     , a.bountyamount
     , a.owneruserid as [User Link]
from votes v
inner join posts q on = v.postid
left outer join awarded a 
  on v.postid = a.questionid 
 and a.creationdate 
 between v.creationdate 
 and dateadd(d, 8, v.creationdate)
where v.votetypeid = 8 -- bounty start
order by v.creationdate desc

Enter Parameters

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