Информация по кандидатам

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow на русском

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

-- --
-- http://ru.stackoverflow.com/election/1
-- Array.prototype.map.call($$(".post-signature.owner.candidate-score .user-details a"), a => a.href.match(/\d+/)[0]) + ''
-- 181472,15479,177221,182317,176610,178988,176051,178018
-- --
-- select * from Users where Id in (181472,15479,177221,182317,176610,178988,176051,178018)
-- --

select
  Id,
  DisplayName as Имя,
  N'http://ru.stackoverflow.com/users/' + cast(Id as nvarchar(8)) as [Ссылка на профиль],
  Reputation as Репутация,
  UpVotes as [Количество голосов за],
  DownVotes as [Количество голосов против],
  cast(cast(round(100.0 * UpVotes / (UpVotes+DownVotes), 3) as dec(10,3)) as nvarchar(16)) + N'%' as [Процент голосов за]
from
  Users u
where
  u.Id in (181472,15479,177221,182317,176610,178988,176051,178018)
order by
  u.Reputation desc

Enter Parameters

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