Moderators 2020 votes

0

Please login or register to vote for this query.

(click on this box to dismiss)

Philosophy Meta

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results