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 user experience researchers and experts

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

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
group by
  p.ParentId
,p.Id
having
count(v.Id) > 0
order by
 count(v.Id) desc

fork query

edited feb 4 12 christofian

created mar 11 11 Daniel DiPaolo