Questions deleted long after creation

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

SELECT TOP(##num?250##)
Id, DATEDIFF(day, CreationDate, DeletionDate), Score,
url = 'site://q/' + CAST(Id AS varchar)
FROM PostsWithDeleted
WHERE (DATEDIFF(day, CreationDate, DeletionDate)>=##days?1095##) AND (Score>=##minscore?5##) AND
  (PostTypeId=1)
ORDER BY DATEDIFF(day, CreationDate, DeletionDate) DESC
--PosttypeId=1 questions
--PosttypeId=2 answers

Enter Parameters

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