Answered questions that have at least two zero-score answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Questions that can be marked as answered by upvoting one of the available zero-score answers.

Stack Overflow

Q&A for professional and enthusiast programmers

-- Unanswered questions that have at least one zero-score answer
-- Questions that can be marked as answered by upvoting one of the available zero-score answers.
SELECT q.Id AS [Post Link]
FROM Posts q 
WHERE q.PostTypeId = 1 
      AND q.ClosedDate IS NULL
      AND q.AcceptedAnswerId > 0
      AND q.AnswerCount > 2
      AND EXISTS (SELECT a.Id
                  FROM Posts a
                  WHERE a.Score = 0
                        AND a.ParentId = q.Id)
ORDER BY q.CreationDate DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results