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