0

Please login or register to vote for this query.

(click on this box to dismiss)

The top 100 downvoters by percentage

Q&A about the site for administrators, end users, developers and designers for Craft CMS

-- Upvoters Hall of Shame (by percentage) 
-- The top 100 downvoters by percentage

SELECT TOP 100
    Id as [User Link],
    UpVotes,
    DownVotes,
    (UpVotes)*100/(DownVotes+UpVotes) as UpVotesPCT
FROM Users
WHERE  DownVotes > 300     -- Suppress lower vote counts; 

ORDER BY UpVotesPCT DESC

fork query

edited dec 18 13

created apr 18 11 anonymous