Reviews on your posts

13

Please login or register to vote for this query.

(click on this box to dismiss)

The Great Outdoors

Q&A for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment

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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results