Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences
SELECT TOP ##numberOfHits:int?100## rt.PostId AS [Post Link], rt.CreationDate, rt.DeletionDate, ReviewTaskTypeId, 'site://review/' +CASE ReviewTaskTypeId 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' WHEN 12 THEN 'first-questions' WHEN 13 THEN 'first-answers' END+'/' + CAST(rt.Id AS NVARCHAR) + '|Review task', CASE ReviewTaskStateId WHEN 1 THEN 'Active' WHEN 2 THEN 'Completed' WHEN 3 THEN 'Invalidated' END, CASE ReviewTaskTypeId WHEN 1 THEN 'Suggested Edit' WHEN 2 THEN 'Close Votes' WHEN 3 THEN 'Low Quality Posts' WHEN 4 THEN 'First Post' WHEN 5 THEN 'Late Answer' WHEN 6 THEN 'Reopen Vote' WHEN 12 THEN 'First Questions' WHEN 13 THEN 'First Answers' END, CASE rtr.ReviewTaskResultTypeId WHEN 1 THEN 'Skip' WHEN 2 THEN 'Approve (suggested edits)' WHEN 3 THEN 'Reject (suggested edits)' WHEN 4 THEN 'Delete (low quality)' WHEN 5 THEN 'Edit (first posts, late answers, low quality)' WHEN 6 THEN 'Close (close, low quality)' WHEN 7 THEN 'Looks OK (low quality)' WHEN 8 THEN 'Do Not Close (close)' WHEN 9 THEN 'Recommend Deletion (low quality answer)' WHEN 10 THEN 'Recommend Close (low quality question)' WHEN 11 THEN 'Other Action (first posts)' WHEN 12 THEN 'Reopen (reopen)' WHEN 13 THEN 'Leave Closed (reopen)' WHEN 14 THEN 'Edit and Reopen (reopen)' WHEN 15 THEN 'Excellent (community evaluation)' WHEN 16 THEN 'Satisfactory (community evaluation)' WHEN 17 THEN 'Needs Improvement (community evaluation)' WHEN 18 THEN 'No Action Needed (first posts, late answers)' END, rtr.ReviewTaskResultTypeId, p.ClosedDate -- p.DeletionDate FROM ReviewTasks rt RIGHT OUTER JOIN ReviewTaskResults rtr ON rtr.Id=rt.CompletedByReviewTaskId INNER JOIN PostsWithDeleted p ON p.Id=rt.PostId WHERE ReviewTaskTypeId IN (##types?1,2,12,13##) ORDER BY rt.CreationDate DESC --ReviewTaskTypeId (listed in ReviewTaskTypes) --1 = Suggested Edit --2 = Close Votes --3 = Low Quality Posts --4 = First Post --5 = Late Answer --6 = Reopen Vote --7 = Community Evaluation --8 = Link Validation --9 = Flagged Posts --10 = Triage --11 = Helper