Aged Away Reviews on Potentially Bad Questions

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 500
  rt.PostId 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 p ON rt.PostId = p.Id
WHERE
  rt.ReviewTaskStateId = 3 AND
  rtr.ReviewTaskResultTypeId = 6 AND
  rt.DeletionDate IS NOT NULL AND
  p.DeletionDate IS NULL AND
  p.ClosedDate IS NULL
GROUP BY rt.PostId, rt.ReviewTaskStateId
HAVING COUNT(rtr.Id) >= ##MinReviewTasks:int?3##
ORDER BY MAX(rt.CreationDate) DESC;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results