0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for gardeners and landscapers

SELECT 
  'site://review/' + 
  CASE ReviewTaskTypes.Id
    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(ReviewTasks.Id AS nvarchar) +
  '| ' AS ReviewLinks,
  ReviewTasks.CreationDate AS VotesDate
  FROM   ReviewTaskTypes,ReviewTasks
SELECT * FROM ReviewTaskResults WHERE Comment is not null

fork query

edited jun 20 17 Nikita.Siomin

created jun 8 14 Gilles