Me as a review task

0

Please login or register to vote for this query.

(click on this box to dismiss)

Lifehacks

Q&A for people looking to bypass life's everyday problems with simple tricks

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