View Deadweight (Phase 2) questions

1

Please login or register to vote for this query.

(click on this box to dismiss)

View latest questions older than 3 months that have score < 1 and all answers have score < 0

Stack Overflow

Q&A for programmers

-- Enter Query Title
-- Enter Query Description

select id as [Post Link],Title,Body  from posts as q
where PostTypeId=1
AND Score < 1
AND CreationDate < DATEADD(MONTH, -3, GETDATE())
AND ClosedDate is null
and AcceptedAnswerId is null
AND AnswerCount > 0
AND NOT EXISTS (
    select * from posts as a where PostTypeId=2 and ParentId=q.id and Score>=0
)
ORDER BY CreationDate DESC

Enter Parameters

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