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 TOP ##Results:int?100##
       task.Id AS [Task ID],
       type.Name AS [Task Type],
       state.Name AS [Task State],
       task.PostId AS [Post Link],
       task.CreationDate AS [Creation Date]
FROM ReviewTasks task
INNER JOIN ReviewTaskTypes type ON task.ReviewTaskTypeId = type.Id
INNER JOIN ReviewTaskStates state ON task.ReviewTaskStateId = state.Id
ORDER BY state.Name ASC

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results