Questions that can be marked as answered by upvoting one of the available zero-score answers.
Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs
-- 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 (SELECT COUNT(*) FROM Votes v WHERE v.PostId = q.Id AND v.VoteTypeId = 6) = 2 ORDER BY q.Id ASC