Most evil users


Please login or register to vote for this query.

(click on this box to dismiss)

Users with highest downvote to upvote ratio.

Stack Overflow на русском Meta

Вопросы и ответы о сайте для программистов

select top 100
  row_number() over (order by u.DownVotes * 1.0 / u.UpVotes desc) as '#',
  u.Id as [User Link],
  format(u.DownVotes * 1.0 / UpVotes, 'p') as [Evil Ratio],
  u.UpVotes as [Up],
  u.DownVotes as [Down],
  u.Reputation as [Rep],
  u.LastAccessDate as [Last Access],
    select top 4
      t.TagName + ', ' as 'data()'
      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
      a.OwnerUserId = u.Id and a.PostTypeId = 2
    group by
    order by
      sum(a.Score) desc
    for xml path('')
  ) + ' ...' as [Top Tags]
  Users as u
  u.DownVotes > 100
  and u.Id <> -1
order by
  u.DownVotes * 1.0 / u.UpVotes desc

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results