0

Please login or register to vote for this query.

(click on this box to dismiss)

Shows the most downvoted answers (with at least 25 downvotes)

Q&A for professional and enthusiast programmers

-- Most downvoted answers
-- Shows the most downvoted answers 

select
  p.ParentId as [Post Link]
 ,p.Id
 ,count(v.Id)
from
 Posts p
 inner join Votes v
   on v.PostId = p.Id
where
  v.VoteTypeId = 3 AND
  p.ParentId IS NOT NULL
group by
  p.ParentId
,p.Id
having
count(v.Id) > 0
order by
 count(v.Id) desc

fork query

edited jun 21 12 giraff

created mar 11 11 Daniel DiPaolo