Aged Away Reviews on Potentially Bad Questions

1

Please login or register to vote for this query.

(click on this box to dismiss)

Find questions that have multiple close votes that have aged away - Exclude questions already closed or deleted - Exclude highly-voted questions - Exclude questions with accepted or highly-voted answers - Exclude questions with leave-open or reopen votes

Operations Research Meta

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

-- Find questions that have multiple close votes that have aged away

SELECT TOP ##MostRecent:int?100##
  p.Id AS [Post Link],
  MAX(rt.CreationDate) AS [Review Created At],
  COUNT(DISTINCT(rt.Id))+COUNT(DISTINCT(rtr.Id)) AS [Close Vote Count]
FROM ReviewTasks AS rt
INNER JOIN PostsWithDeleted AS p ON p.Id = rt.PostId
LEFT JOIN ReviewTaskResults AS rtr ON rtr.ReviewTaskId = rt.Id AND rtr.ReviewTaskResultTypeId <> 1
LEFT JOIN Posts a on a.ParentId = rt.PostId
WHERE
  rt.ReviewTaskTypeId in (2,6) AND
-- - Exclude questions already closed or deleted
  p.DeletionDate IS NULL AND
  p.ClosedDate IS NULL AND
-- - Exclude highly-voted questions
  p.Score <= 2 AND
-- - Exclude questions with accepted or highly-voted answers
  p.AcceptedAnswerId IS NULL
GROUP BY p.Id
HAVING
  MAX(ISNULL(a.Score,0)) <= 1 AND
-- - Exclude questions with leave-open or reopen votes
  COUNT(DISTINCT(rt.ReviewTaskTypeId)) = 1 AND
  MAX(rt.ReviewTaskTypeId) = 2 AND
  COUNT(DISTINCT(ISNULL(rtr.ReviewTaskResultTypeId,6))) = 1 AND
  MAX(ISNULL(rtr.ReviewTaskResultTypeId,6)) = 6 AND
  COUNT(DISTINCT(rt.Id))+COUNT(DISTINCT(rtr.Id)) > 1
ORDER BY MAX(rt.CreationDate) DESC;

Enter Parameters

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