Search for question with positive score where all answers have zero score

0

Please login or register to vote for this query.

(click on this box to dismiss)

https://meta.stackexchange.com/questions/261610/search-for-question-with-positive-score-where-all-answers-have-zero-score

Stack Overflow

Q&A for professional and enthusiast programmers

select top 1000  
       q.id as [Post Link]
     , q.score [question score]
     , q.answercount
     , q.creationdate
from posts q 
where q.score > 0               -- positive scoring question
and q.answercount > 0           -- with at least one answer
and q.acceptedanswerid is null  -- no accepted answer
and (select count(*) 
     from posts 
     where posttypeid = 2
     and parentid = q.id
     and score  = 0) = q.answercount -- all answers score zero
order by q.creationdate desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results