select creationdate , text , name from posthistory ph inn...

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 creationdate
     , text
     , name
from posthistory ph
inner join posthistorytypes pht on pht.id = ph.posthistorytypeid
where postid = ##postid?53334142##
and posthistorytypeid in (2,5,8)
order by creationdate

select ph.creationdate
     , text
     , name
     , p.id 
from posthistory ph
inner join posthistorytypes pht on pht.id = ph.posthistorytypeid
inner join posts p on ph.postid = p.id
where p.creationdate between '##startdate?2019-02-14##' and '##enddate?2019-02-15##'
and posthistorytypeid in (2,5,8)
order by ph.creationdate

Enter Parameters

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