select * from posthistory as ps join posthistory as pe on...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts

Q&A for enthusiasts and power users of the Android operating system

select * from posthistory as ps join posthistory as pe on ps.postid=pe.postid
where ps.posthistorytypeid = 6 and pe.posthistorytypeid=6
and ps.creationdate < pe.creationdate
and ps.text like '%<status-completed>%'

Enter Parameters

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