Q&A about the site for serious players and enthusiasts of chess
SELECT rt.PostId AS [Post Link], 'site://review/' + CASE WHEN rtt.Id = 1 OR rtt.Id = 4 OR rtt.Id = 5 THEN REPLACE(LOWER(rtt.Name), ' ', '-') + 's' WHEN rtt.Id = 2 THEN 'close' WHEN rtt.Id = 3 THEN REPLACE(LOWER(rtt.Name), ' ', '-') WHEN rtt.Id = 6 THEN 'reopen' END + '/' + CAST(rt.Id AS nvarchar) AS [Review Link], rtt.Name AS [Review Type] FROM ReviewTasks rt INNER JOIN ReviewTaskTypes rtt ON rt.ReviewTaskTypeId = rtt.Id INNER JOIN Posts p ON rt.PostId = p.Id WHERE p.OwnerUserId = ##UserId## ORDER BY rt.CreationDate, rtt.Name