Q&A about the site for Joomla! administrators, users, developers and designers
SELECT TOP 10 Users.Id [User Link], Count (*) DownvoteCount FROM Users JOIN Votes on Votes.UserId = Users.Id WHERE Votes.VoteTypeId = 3 GROUP BY Users.Id ORDER BY Count (*) DESC