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

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 ps join posthistory pe on ps.postid=pe.postid
where ps.posthistorytypeid = 6 and pe.posthistorytypeid=6 and ps.text like '%<status-completed>%'
and pe.text not like '%<status-completed>%' and ps.creationdate < pe.creationdate

Enter Parameters

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