Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair

Q&A for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

  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
  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
GROUP BY p.Id, rt.ReviewTaskStateId
HAVING COUNT(rtr.Id) >= ##MinReviewTasks:int?3##
ORDER BY MAX(rt.CreationDate) DESC;

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results