Answers with the most number of downvotes. Excludes upvotes.
Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation
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 = 2 AND v.VoteTypeId = 3
GROUP BY v.postid, p.body
ORDER BY 'Downvotes' DESC