Select ReviewItem.Id, TaskType.Name FROM ReviewTaskResu...

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 * FROM ReviewTasks WHERE Id = 98825;
-- DeletionDate is decision date

-- SELECT * FROM ReviewTaskResults Where ReviewTaskId = 98825;

Select ReviewItem.Id, TaskType.Name 
  FROM ReviewTaskResults AS ReviewVote
  JOIN ReviewTasks AS ReviewItem 
    ON (ReviewVote.ReviewTaskId = ReviewItem.Id AND ReviewVote.CreationDate > ReviewItem.DeletionDate)
    JOIN ReviewTaskTypes AS TaskType ON (ReviewItem.ReviewTaskTypeId = TaskType.Id);

Enter Parameters

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