Invalidated reviews on posts with no comments and no edits

1

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

SELECT TOP(##num?1000##)
PostId AS [Post Link], CreationDate, DeletionDate,
'site://review/'
   +CASE ##type?4##
    WHEN 1 THEN 'suggested-edits'
    WHEN 2 THEN 'close'
    WHEN 3 THEN 'low-quality-posts'
    WHEN 4 THEN 'first-posts'
    WHEN 5 THEN 'late-answers'
    WHEN 6 THEN 'reopen'
    END+'/' + CAST(Id AS NVARCHAR) + '|Review task'
FROM ReviewTasks  
WHERE (ReviewTaskTypeId=##type?4##) AND (ReviewTaskStateId=3) 
---1 = Active
---2 = Completed
---3 = Invalidated
---no edits
  AND PostId NOT IN(SELECT PostId FROM PostHistory WHERE PostHIstoryTypeId IN (4,5,6))
---no comments                      
  AND PostId NOT IN(SELECT PostId FROM Comments)  
ORDER BY PostId DESC

Enter Parameters

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