Deleted questions with many answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP ##number##
  q.Id, q.Id AS [Post Link],
  COUNT(*) AS NumAnswers
FROM PostsWithDeleted q
INNER JOIN PostsWithDeleted a ON a.ParentId = q.Id
WHERE (q.Deletiondate IS NOT NULL) and (q.PostTypeId =1) and (a.PostTypeId=2)
GROUP BY q.id
ORDER BY NumAnswers DESC

Enter Parameters

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