Me as a review task

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT t.Id AS [PostLink], c.Name
FROM ReviewTasks t
  JOIN Posts p
    ON t.PostId = p.Id
  JOIN ReviewTaskTypes c
    ON t.ReviewTaskTypeId = c.Id
WHERE p.OwnerUserId = ##UserId##
ORDER BY c.Name DESC, t.Id ASC

Enter Parameters

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