Non-deleted questions with most deleted answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics

Q&A for people studying math at any level and professionals in related fields

SELECT TOP 100
  P.ParentId AS [Post Link],
  COUNT(P.Id) AS [Deleted Answers]
FROM PostsWithDeleted P
INNER JOIN PostsWithDeleted PD ON PD.Id = P.ParentId
WHERE
  P.PostTypeId = 2
  AND P.DeletionDate IS NOT NULL
  AND PD.DeletionDate IS NULL
GROUP BY P.ParentId
ORDER BY [Deleted Answers] DESC

Enter Parameters

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