0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

select
  u.Id, u.DisplayName, u.Reputation, u.CreationDate, u.UpVotes, u.DownVotes,
  v.*
from
  Users u left join
  (
    select
      v.UserId, vt.Name, count(*) as Count
      from Votes v inner join VoteTypes vt on vt.Id = v.VoteTypeId
      group by v.UserId, vt.Name
  ) v on u.Id = v.UserId
where
  u.Id in (3773011, 3773011, 3773011, 1356107, 1356107, 1356107, 1026459, 1026459, 1026459, 1459669, 1459669, 1459669, 2370483, 2370483, 2370483, 3956566, 3956566, 3956566, 1839439, 1839439, 1839439)
-- group by
--  u.Id, u.DisplayName, u.Reputation, u.CreationDate, u.UpVotes, u.DownVotes,
--  v.VoteTypeId

fork query

edited jul 13 20

created jul 13 20 anonymous