Track excessive Downvoters

0

Please login or register to vote for this query.

(click on this box to dismiss)

List users by downvote percentage

Super User

Q&A for computer enthusiasts and power users

-- Enter Query Title
-- Enter Query Description

SELECT Id, Reputation, DisplayName, UpVotes, DownVotes, (DownVotes)*100/(DownVotes+UpVotes) as DownVotesPCT
FROM Users
WHERE UpVotes > 5 AND DownVotes > 5
 AND UpVotes+DownVotes > 20 -- suppress people not voting to much in the result
ORDER BY DownVotesPCT desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached