View Deadweight (Phase 2) questions


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 professional and enthusiast 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
    select * from posts as a where PostTypeId=2 and and Score>=0
ORDER BY CreationDate DESC

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results