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.

Monero Meta

Q&A about the site for developers and users of the secure, private and untraceable cryptocurrency Monero

-- 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 to main site
loading Hold tight while we fetch your results