Posts that were deleted but not undeleted

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics

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

select p.id as [Post Link] 
from posts p
join posthistory h on h.postid = p.id
join postHistoryTypes pht on pht.id = 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

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