Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games
SELECT TOP ##numberOfHits:int?100## PostId AS [Post Link], CreationDate, '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 NVARCHAR) + '|Review task', CASE ReviewTaskStateId WHEN 1 THEN 'Active' WHEN 2 THEN 'Completed' WHEN 3 THEN 'Invalidated' END FROM ReviewTasks WHERE (ReviewTaskTypeId = ##type?1##) AND (ReviewTaskStateId = ##state?3##) ORDER BY 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