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 en español

Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática

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 sites:
loading Hold tight while we fetch your results