Questions that can be marked as answered by upvoting one of the available zero-score answers.
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