0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT TOP 4500
  id as [Post Link]  -- crashing SEDE again
  --id
  , ClosedDate
  , DeletionDate
  , CommunityOwnedDate
  , CreationDate
FROM
  PostsWithDeleted
WHERE
  DeletionDate is not null
AND
  PostTypeId IN (1, 2)
ORDER BY
  CreationDate;

fork query

edited jul 6 Brock Adams

created jul 6 Werner