Questions deleted long after creation (with answercount)

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##)
q.Id, DATEDIFF(day, q.CreationDate, q.DeletionDate), q.Score, COUNT(a.Id) AS [Answers],
url = 'site://q/' + CAST(q.Id AS varchar)
FROM PostsWithDeleted q JOIN PostsWithDeleted a ON a.ParentId=q.Id
WHERE (DATEDIFF(day, q.CreationDate, q.DeletionDate)>=##days?1095##) AND (q.Score>=##minscore?5##) AND (q.PostTypeId=1)
GROUP BY q.Id, q.CreationDate, q.DeletionDate, q. Score
ORDER BY DATEDIFF(day, q.CreationDate, q.DeletionDate) DESC
--PosttypeId=1 questions
--PosttypeId=2 answers

Enter Parameters

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