Closed, no up-voted/accepted answers and no pending reopen votes

0

Please login or register to vote for this query.

(click on this box to dismiss)

Network Engineering

Q&A for network engineers

select count(*)

from Posts q

where ClosedDate < getdate()-##deadline##

and not exists (select 1 from Posts a where ParentId=q.Id and Score>=1)

and AcceptedAnswerId is null

and isnull((select top 1 PostHistoryTypeId from PostHistory
where PostId=q.Id and PostHistoryTypeId in (14,15,35) order by CreationDate desc),0) not in (14,35)

and not exists (select 1 from Votes where VoteTypeId=7 and PostId=q.Id)

Enter Parameters

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