1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

SELECT TOP 100
  'site://q/' + CAST(Id AS VARCHAR(MAX)) + '|' + CAST(Id AS VARCHAR(MAX))
    AS Link,
  CreationDate,
  DeletionDate,
  DATEADD(S, DATEDIFF(S, CreationDate, DeletionDate), '2000-01-01') AS Diff
FROM PostsWithDeleted
WHERE
  PostTypeId = 1
  AND
  DeletionDate IS NOT NULL
ORDER BY Diff DESC

fork query

edited feb 7 22

created feb 7 22 peterh - PLEASE DELETE THIS ACCOUNT