0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for operations research and analytics professionals, educators, and students

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
LEFT JOIN Posts a on rt.PostId = a.ParentId
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 AND
  a.Score > 0
GROUP BY p.Id, rt.ReviewTaskStateId
HAVING COUNT(rtr.Id) > 1 AND COUNT(a.Id) = 0
ORDER BY MAX(rt.CreationDate);

fork query

edited dec 9 Arnon.Weinberg

created dec 6 17 ArtOfCode-