Reviews for a post

1

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Overflow

Q&A about Stack Overflow

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

WHERE
    rt.PostId = ##PostId##

Enter Parameters

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