Recent reviews of a specific type

1

Please login or register to vote for this query.

(click on this box to dismiss)

Reverse Engineering Meta

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

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 to main site
loading Hold tight while we fetch your results