Answers with the most number of downvotes. Excludes upvotes.
Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles
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