Downvotes by User

Please login or register to vote for this query.

(click on this box to dismiss)

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

created dec 2 10