0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

-- Downvotes by User

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 and u.id = ##UserId##
Group by
u.id, u.reputation
order by count(*) desc

fork query

created jan 3 11 kelly.french