Downvotes by User

0

Please login or register to vote for this query.

(click on this box to dismiss)

Christianity

Q&A for committed Christians, experts in Christianity and those interested in learning more

-- Downvotes by User

Select top 100 
u.id [User Link], u.reputation, count( * ) as DownVotes

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