Downvoters Hall of Shame (by percentage)

0

Please login or register to vote for this query.

(click on this box to dismiss)

The top 100 downvoters by percentage

Lifehacks

Q&A for people looking to bypass life's everyday problems with simple tricks

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

SELECT TOP 100
    Id as [User Link],
    UpVotes,
    DownVotes,
    (DownVotes)*100/(DownVotes+UpVotes) as DownVotesPCT
FROM Users
WHERE UpVotes > 20 AND DownVotes > 20     -- Suppress lower vote counts; 
 AND UpVotes+DownVotes > 100 AND Id <> -1 -- these are habitual downvoters.
 and DisplayName like 'Ra%'
ORDER BY DownVotesPCT DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results