Most loyal users


Please login or register to vote for this query.

(click on this box to dismiss)

Users with highest upvote to downvote ratio.

Stack Overflow

Q&A for professional and enthusiast programmers

select top 100
  row_number() over (order by u.UpVotes * 1.0 / u.DownVotes desc) as '#',
  u.Id as [User Link],
  format(u.UpVotes * 1.0 / DownVotes, 'p') as [Good 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 > 30 and u.UpVotes > 300
order by
  u.UpVotes * 1.0 / u.DownVotes desc

Enter Parameters

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