Ru Moderators 2020 votes

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow на русском

Вопросы и ответы для программистов

-- $$(".candidate-score .user-details a").map(x => x.href.match(/\d+/)).join(", ")

select
  u.Id, u.DisplayName, u.Reputation, u.CreationDate, u.UpVotes, u.DownVotes, ROUND(100.0 * u.UpVotes / (u.UpVotes + u.DownVotes), 1) as UpVotePercent,
  v.Name as VoteName, v.Count
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 (185348, 236727, 369536, 280323, 186999, 184435, 396366, 343345, 5648, 387552, 14955)
order by
  u.DisplayName, v.Name

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results