You know how they never give us the feature to look up reviews by the post involved? Well, now you can.
Q&A for enthusiasts and power users of the Android operating system
CREATE TABLE #ReviewUris ( TypeId TINYINT NOT NULL, UriComponent NVARCHAR(255) NOT NULL ); INSERT INTO #ReviewUris VALUES (1, 'suggested-edits'), (2, 'close'), (3, 'low-quality-posts'), (4, 'first-posts'), (5, 'late-answers'), (6, 'reopen'); -- don't know what the rest are SELECT 'site://review/' + RI.UriComponent + '/' + CAST(RT.Id AS NVARCHAR) + '|' + CAST(RT.Id AS NVARCHAR) AS [Review Link], (SELECT Name FROM ReviewTaskTypes WHERE Id = RT.ReviewTaskTypeId) AS [Review Type] FROM Posts AS P INNER JOIN ReviewTasks AS RT ON P.Id = RT.PostId INNER JOIN #ReviewUris AS RI ON RT.ReviewTaskTypeId = RI.TypeId WHERE P.Id = ##PostId:int##