The top 20 answers with the most down-votes (ignores up-votes)
Q&A for professional and enthusiast programmers
-- Most Down-Voted Answers -- The top 20 answers with the most down-votes (ignores up-votes) select top 20 count(v.postid) as 'Vote count', v.postid AS [Post Link],p.body from votes v inner join posts p on p.id=v.postid where PostTypeId = 2 and VoteTypeId=3 group by v.postid,p.body order by 'Vote count'