[delete]

0

Please login or register to vote for this query.

(click on this box to dismiss)

Operations Research Meta

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
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;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results