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)