Questions with the most number of downvotes. Excludes upvotes.
Q&A about the site for serious players and enthusiasts of poker
SELECT TOP 50 count(v.postid) as 'Downvotes', v.postid AS [Post Link] FROM votes v INNER JOIN posts p ON p.id=v.postid WHERE PostTypeId = 1 AND v.VoteTypeId = 3 GROUP BY v.postid, p.body ORDER BY 'Downvotes' DESC