1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

SELECT TOP ##numberOfHits:int?100## 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 
  FROM ReviewTasks rt RIGHT OUTER JOIN ReviewTaskResults rtr ON rtr.Id=rt.CompletedByReviewTaskId
  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

fork query

edited oct 30

created oct 30 Martin20528