1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users of Linux, FreeBSD and other Un*x-like operating systems

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 'Active'
    WHEN 2 THEN 'Completed'
    WHEN 3 THEN 'Invalidated'
END    
FROM ReviewTasks
WHERE ReviewTaskTypeId=##type##
ORDER By CreationDate DESC

fork query

edited nov 30

created jul 3 20 Martin20528