Posts with most delete votes


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select top 100 p.Id as [Post Link], count(v.Id) as [Delete Votes] from posts p 
  inner join votes v 
    on v.PostId=p.Id
    where v.VoteTypeId=10 
group by p.Id
order by [Delete Votes] desc

Enter Parameters

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