Users with highest downvote to upvote ratio.
Q&A about the site for users of TeX, LaTeX, ConTeXt, and related typesetting systems
select top 1000 row_number() over (order by u.DownVotes * 1.0 / (u.UpVotes + 1) desc) as '#', u.Id as [User Link], format(u.DownVotes * 1.0 / (UpVotes + DownVotes), 'p') as [Evil Ratio], u.UpVotes as [Up], u.DownVotes as [Down], u.UpVotes + u.DownVotes as [Total], u.Reputation as [Rep], u.LastAccessDate as [Last Access], ( select top 4 t.TagName + ', ' as 'data()' from Posts as q inner join Posts as a on a.ParentId = q.Id inner join PostTags as pt on pt.PostId = q.Id inner join Tags as t on pt.TagId = t.Id where a.OwnerUserId = u.Id and a.PostTypeId = 2 group by TagName order by sum(a.Score) desc for xml path('') ) + ' ...' as [Top Tags] from Users as u where u.DownVotes > 1 AND u.UpVotes > 100 and u.Id <> -1 AND u.Reputation > 10000 order by u.DownVotes * 1.0 / (UpVotes + DownVotes) desc