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 expert genealogists and people interested in genealogy or family history

-- 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  DownVotes > 20     -- Suppress lower vote counts; 
 AND Id <> -1 -- these are habitual downvoters.
ORDER BY DownVotesPCT DESC

fork query

edited feb 20 13

created apr 18 11 anonymous