Aged Away Reviews

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- Technically, these are "invalidated" reviews, which is a superset of
-- aged away. But close enough.

SELECT TOP 500
  rt.PostId AS [Post Link],
  rt.Id AS [Review ID],
  rt.CreationDate AS [Review Created At]
FROM ReviewTasks AS rt
INNER JOIN PostsWithDeleted AS p ON rt.PostId = p.Id
WHERE
  rt.ReviewTaskStateId = 3 AND
  rt.DeletionDate IS NOT NULL AND
  p.DeletionDate IS NULL AND
  p.ClosedDate IS NULL
ORDER BY rt.CreationDate DESC;

Enter Parameters

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