Hard to delete

0

Please login or register to vote for this query.

(click on this box to dismiss)

Closed questions that need a lot of votes to delete

Stack Overflow

Q&A for programmers

-- Hard to delete
-- Closed questions that need a lot of votes to delete

Select q.Id as [Post Link], (Score + AnswerScore) / 20 + 3 as [Delete Votes] 
From Posts as q
join (Select Sum(Score) as AnswerScore, ParentId from Posts Where PostTypeId=2 Group By ParentId)
  as a on a.ParentId=q.Id
Where ClosedDate is not null 
  and ((Score + AnswerScore) / 20 + 3) > 10
Order By (Score + AnswerScore) / 20 Desc

Enter Parameters

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