Most downvoted answers

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)

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results