0

Please login or register to vote for this query.

(click on this box to dismiss)

The top 100 users in total downvotes received per post.

Q&A about the site for serious players and enthusiasts of chess

-- Most downvoted users
-- The top 100 users in total downvotes received per post.

select top 100 u.Id as [User Link], u.Reputation,
(select count(*) from Posts p where p.OwnerUserId = u.Id) as Posts,
(select count(*) from Posts p join Votes v on v.PostId = p.Id
 where p.OwnerUserId = u.Id and v.VoteTypeId = 3) as Downvotes,
((select count(*) from Posts p join Votes v on v.PostId = p.Id
  where p.OwnerUserId = u.Id and v.VoteTypeId = 3) + 0.0) /
((select count(*) from Posts p where u.Id = p.OwnerUserId) + 0.0) as Ratio
from Users u
where (select count(*) from Posts p where u.Id = p.OwnerUserId) > 100
order by ((select count(*) from Posts p join Votes v on v.PostId = p.Id
           where p.OwnerUserId = u.Id and v.VoteTypeId = 3) + 0.0) /
         ((select count(*) from Posts p where p.OwnerUserId = u.Id) + 0.0) desc

fork query

created nov 13 10 Tsuyoshi Ito