Блог пользователя dvSuraev

Автор dvSuraev, 10 лет назад, По-русски

Завершился тренировочный раунд на CodeCup.

От России участвовали Сергей Повалихин и Алексей Калинин (второе и восьмое место соответственно)

пример боя

Результаты

  • Проголосовать: нравится
  • +1
  • Проголосовать: не нравится

»
10 лет назад, # |
  Проголосовать: нравится +5 Проголосовать: не нравится

лол

Database error: Invalid SQL: SELECT MAX(a.nplayers) as nmax FROM (SELECT COUNT(*) AS nplayers FROM tblgameplayer WHERE gap_ga_id IN (SELECT ga_id, ga_white_prg_id, ga_black_prg_id, ga_finished, ga_status, cr_roundnr, usw.us_fullname AS usname0, resw.res_score AS score0, resw.res_status AS status0, usb.us_fullname AS usname1, resb.res_score AS score1, resb.res_status AS status1 FROM tblcompetitiongame INNER JOIN tblgame ON (cg_ga_id=ga_id) LEFT JOIN tblgameresult AS resw ON (ga_id=resw.res_ga_id AND resw.res_prg_nr=0) LEFT JOIN tblgameresult AS resb ON (ga_id=resb.res_ga_id AND resb.res_prg_nr=1) LEFT JOIN tblcompetitionround ON (cg_cr_id=cr_id) LEFT JOIN tblsubmission AS subw ON (ga_white_prg_id=subw.sub_prg_id) LEFT JOIN tblcontestuser AS cuw ON (subw.sub_cu_id=cuw.cu_id) LEFT JOIN tblusers AS usw ON (cuw.cu_us_id=usw.us_id) LEFT JOIN tblsubmission AS subb ON (ga_black_prg_id=subb.sub_prg_id) LEFT JOIN tblcontestuser AS cub ON (subb.sub_cu_id=cub.cu_id) LEFT JOIN tblusers AS usb ON (cub.cu_us_id=usb.us_id) WHERE (cg_comp_id='175') AND (cg_white_ent_id='3788' OR cg_black_ent_id='3788') ORDER BY cr_roundnr, ga_id) GROUP BY gap_ga_id) AS a