Questions entered in the review queue (in the date range)

2

Please login or register to vote for this query.

(click on this box to dismiss)

MathOverflow

Q&A for professional mathematicians

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
---since the table ReviewTasks contains only date, we don't get any information about hours/minutes
FROM ReviewTasks
WHERE (ReviewTaskTypeId=##type##) AND (CreationDate >= '##Date1?2020-01-01##') AND (CreationDate <= '##Date2?2020-03-01##')
---1 = Suggested Edit
---2 = Close Votes
---3 = Low Quality Posts
---4 = First Post
---5 = Late Answer
---6 = Reopen Vote
ORDER BY Id DESC

Enter Parameters

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