0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for materials modelers and data scientists

SELECT TOP 500
  p.Id AS [Post Link],
  COUNT(rtr.Id) AS [Close Review Count],
  MAX(rt.CreationDate) AS [Review Created At]
FROM ReviewTasks AS rt
INNER JOIN ReviewTaskResults AS rtr ON rtr.ReviewTaskId = rt.Id
INNER JOIN PostsWithDeleted AS pwd ON rt.PostId = pwd.Id
INNER JOIN Posts p ON rt.PostId = p.Id
WHERE
  rt.ReviewTaskStateId = 3 AND
  rtr.ReviewTaskResultTypeId = 6 AND
  rt.DeletionDate IS NOT NULL AND
  pwd.DeletionDate IS NULL AND
  pwd.ClosedDate IS NULL AND
  p.AcceptedAnswerId IS NULL AND
  p.Score < 3
GROUP BY p.Id, rt.ReviewTaskStateId
HAVING COUNT(rtr.Id) > 1
ORDER BY MAX(rt.CreationDate) DESC;

fork query

edited dec 9 21 Arnon.Weinberg

created dec 6 17 ArtOfCode-