Longest delays between question creation and deletion

1

Please login or register to vote for this query.

(click on this box to dismiss)

Vegetarianism

Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results