Downvotes by User

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

Select u.id [User Link], u.reputation, count( * )

from
  VoteTypes  vt
  INNER JOIN VOTES v
  on v.voteTypeID  = vt.id
  INNER JOIN posts p on v.postID = p.id  
inner join users u on p.owneruserid = u.id
where
vt.ID = 3
Group by
u.id, u.reputation
order by count(*) desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached