0

Please login or register to vote for this query.

(click on this box to dismiss)

The top 100 users in total downvotes received.

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

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

select top 100 u.Id as [User Link], u.Reputation,
(select count(*) from Posts p where u.Id = p.OwnerUserId) as Posts,
(select count(*) from Posts p join Votes v on v.PostId = p.Id where u.Id = p.OwnerUserId and v.VoteTypeId = 3) as Downvotes,
((select count(*) from Posts p join Votes v on v.PostId = p.Id where u.Id = p.OwnerUserId 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 u.Id = p.OwnerUserId and v.VoteTypeId = 3) + 0.0) / ((select count(*) from Posts p where u.Id = p.OwnerUserId) + 0.0)) desc

fork query

created nov 13 10 Tsuyoshi Ito