0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT Q.Id AS [Post Link], A.Id -- COUNT(DISTINCT(A.Id))
FROM Posts Q
JOIN PostsWithDeleted A 
  ON A.ParentId = Q.Id
WHERE Q.Id = 321055
  AND Q.PostTypeId = 1 -- Question
  AND A.PostTypeId = 2 -- Answer
  AND A.DeletionDate IS NOT NULL

--SELECT Id AS [Post Link]
--FROM PostsWithDeleted
--WHERE DeletionDate IS NOT NULL
-- AND PostTypeId = 2
-- AND ParentId = 321055

view current version

edited jul 9 20

created jul 9 20 Jeff Schaller