13

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for professors, theologians, and those interested in exegetical analysis of biblical texts

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

fork query

edited aug 12 14

created may 5 14 The Guy with The Hat