0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

WITH ControverseReviews AS (
  SELECT Review.Id, Queue.Name, (SELECT COUNT(Vote.Id) 
         FROM ReviewTaskResults AS Vote 
         WHERE Vote.ReviewTaskId = Review.Id
               -- exclude skips
               AND Vote.ReviewTaskResultTypeId != 1)
         AS Votes 
  FROM ReviewTasks AS Review
    JOIN ReviewTaskTypes AS Queue ON (Review.ReviewTaskTypeId = Queue.Id)
)
SELECT * FROM ControverseReviews WHERE Votes >= ##controversy:int?7##
ORDER BY Votes DESC

fork query

edited apr 4 19

created apr 4 19 Vogel612