Posts that were deleted but not undeleted


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for people studying math at any level and professionals in related fields

select as [Post Link] 
from posts p
join posthistory h on h.postid =
join postHistoryTypes pht on = h.PostHistoryTypeId
where h.PostHistoryTypeId = 12
and not exists (select id from posthistory 
                   where postid =  h.postid
                   and PostHistoryTypeId = 13)
order by p.creationdate

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results