Why is bounty start/close timing data removed from the data explorer?

0

Please login or register to vote for this query.

(click on this box to dismiss)

http://meta.stackexchange.com/questions/281217/why-is-bounty-start-close-timing-data-removed-from-the-data-explorer

Stack Overflow

Q&A for programmers

select top 1000 v.postid as [Post Link]
     , v.creationdate as [vote date]
     , ph.creationdate as [post notice datetime]
     , ph.text
     , ph.comment
     , v.bountyamount
     --  v.userid as [User Link]
from votes v 
inner join posthistory ph on ph.postid = v.postid
where 
(   v.votetypeid = 8 -- bounty start
and ph.posthistorytypeid = 33 -- post notice added
)
order by v.creationdate desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results