1

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

created jan 7 14 jon.doe12549