Questions that have been protected at some point with at least one deleted answer


Please login or register to vote for this query.

(click on this box to dismiss)

Philosophy Meta

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

SELECT ph.PostId AS [Post Link],
       ph.CreationDate AS [protected At],
       COUNT(DISTINCT(p.Id)) AS 'Deleted Answers'
FROM PostHistory ph
INNER JOIN PostsWithDeleted p ON ph.PostId = p.ParentId
WHERE ph.PostHistoryTypeId = 19
    AND p.DeletionDate IS NOT NULL
Group by ph.PostId, ph.CreationDate
ORDER BY [protected At] DESC;

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results