Finding all deleted questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT 'site://q/' + CAST(p.Id AS nvarchar(10)) AS 'Post Link', p.DeletionDate AS 'DelDate'

FROM PostsWithDeleted p

WHERE p.DeletionDate IS NOT NULL AND p.PostTypeId = 1

ORDER BY p.DeletionDate DESC

Enter Parameters

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