Extreme Downvoters

0

Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

/*Returns the top 100 downvoters, who have cast atleast 1000 downvotes and
5 upvotes and 100 reputation*/

select top 100 Id as [User Link],
               Reputation,
               Upvotes,
               DownVotes, 
               round(cast(DownVotes as float)*100/(Upvotes+ DownVotes),1)
                as DownvotePercentage
  from Users
 where Downvotes >= 1000 and UpVotes >= 5
   and Reputation >= 100
 order by DownvotePercentage desc,Downvotes desc, Reputation desc;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results