The top 20 questions with the most down-votes (ignores up-votes)
Q&A about the site for administrators, end users, developers and designers for Craft CMS
-- Most Down-Voted Questions -- The top 20 questions with the most down-votes (ignores up-votes) select top 20 count(v2.id)-count(v.id) as 'Vote count', p.id AS [Post Link],p.body from posts p left join votes v ON (v.postid=p.id AND v.VoteTypeId=3) left join votes v2 ON (v2.postid=p.id AND v.VoteTypeId=2) where PostTypeId = 2 group by p.id, p.body order by 'Vote count' desc