Unanswered questions that have at least one zero-score answer

1

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.

Moderators

Q&A for community managers, administrators, and moderators

-- 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
 
 -- no 1+ score answers
 and (select count(*) from Posts a where a.PostTypeId = 2 and a.ParentId = q.Id and a.Score > 0) = 0
 
 -- has a 0-score answer
 and (select count(*) from Posts a where a.PostTypeId = 2 and a.ParentId = q.Id and a.Score = 0) > 0
 
 -- the question is not closed
 and ClosedDate is null
 
 -- the question does not have an accepted answer
 and AcceptedAnswerId is null
 
ORDER BY q.LastActivityDate ASC

Enter Parameters

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