shows all deleted post within a specified range
Q&A about the site for gardeners and landscapers
SELECT p.id as [Post Link] FROM Posts p, PostHistory ph WHERE p.PostTypeId = 2 AND p.id = ph.id AND ph.PostHistoryTypeId = '20'