0

Please login or register to vote for this query.

(click on this box to dismiss)

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

SELECT TOP ##number##
  q.Id, 
  url = 'site://q/' + CAST(q.Id AS varchar),
  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

fork query

edited apr 26 18

created apr 26 18 jon.doe7173