Non deleted questions with no answers and a negative score

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

-- Non deleted questions with no answers and a negative score

select Id as [Post Link], Score from Posts 
where isnull(AnswerCount,0) = 0 and Score < 0 and PostTypeId = 1 and CreationDate < GetDate() -30 and ClosedDate is null
order by Score asc, CreationDate asc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached