Recent reviews of a specific type

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Apps

Q&A for apps, scripts, and development with the Stack Exchange API

SELECT TOP(##num?100##)
PostId AS [Post Link],
url = 'site://review/'+
+CASE ##type?2##
   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 varchar),
CreationDate, DeletionDate,
CASE ReviewTaskStateId
    WHEN 1 THEN 'Approved'
    WHEN 2 THEN 'Completed'
    WHEN 3 THEN 'Invalidated'
END    
FROM ReviewTasks
WHERE ReviewTaskTypeId=##type##
ORDER By CreationDate DESC

Enter Parameters

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