Most downvoted users

0

Please login or register to vote for this query.

(click on this box to dismiss)

The top 100 users in total downvotes received.

Stack Overflow

Q&A for professional and enthusiast programmers

select A.id as postId, A.ownerUserId as userId, B.downvotes
  from Posts as A inner join (  
    select postId, count(*) as downvotes
    from Votes
    where voteTypeId = 3
    group by postId
  ) as B
  on A.id = B.postId

Enter Parameters

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