0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited apr 25 15

created nov 22 14 Unihedron