Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 16 | 8 | 0 | 1 | 84 | 86 | 0 | 38 | 7.22 | 1123 |
Национальная сборная | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Отборочный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 16 | 8 | 0 | 1 | 84 | 86 | 0 | 38 | 7.22 | 1123 |
Отборочный турнир | 13 | 8 | 0 | 1 | 57 | 69 | 0 | 34 | 7.38 | 881 |
Финальный турнир | 3 | 0 | 0 | 0 | 27 | 17 | 0 | 4 | 6.50 | 242 |
ТОВЫ сборных | 13 | 5 | 1 | 0 | 97 | 65 | 0 | 24 | 6.77 | 959 |
Всего за сборные | 29 | 13 | 1 | 1 | 181 | 151 | 0 | 62 | 7.02 | 2082 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(SELECT `RP`.*, 0 as `sezon`, `PG`.*, 0 as `sezon`, `PG`.`id` as `gid`, `PG`.`lastchangetable` as `sort`, `PT`.`pl_time` FROM `p_roster_pl` `RP` LEFT JOIN `p_rosters` `PR` ON `PR`.`id` = `RP`.`roster` RIGHT JOIN `p_games` `PG` ON `PG`.`id` = `PR`.`game` AND `PG`.`tournament` IN(208) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 85532 WHERE `RP`.`player` = 85532 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (303564,303565,303571,10758466,10758471,10758476,10760390,10760870,10761819,10937948,10937949,10937955,10939497,10940490,10941592,10982989,10982994,10982997,11085700,11085705,11085710,11339798,11339803,11339808,11393004,11393009,11393014,11481210,11481215,11481220,11481642,11481771,11481862,11574765,11574770,11574772,11853455,11853456,11853462,11854410,11940901,11940906,11940911,11942504,11980488,11980493,11980495,11981348,11981666,11982823,333279,333284,333286) ) UNION (SELECT `RP`.*, `PG`.*, `PG`.`id` as `gid`, `PG`.`lastchangetable` as `sort`, `PT`.`pl_time` FROM `p_roster_pl_arch` `RP` LEFT JOIN `p_rosters_arch` `PR` ON `PR`.`id` = `RP`.`roster` RIGHT JOIN `p_games_arch` `PG` ON `PG`.`id` = `PR`.`game` AND `PG`.`tournament` IN(208) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 85532 WHERE `RP`.`player` = 85532 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (303564,303565,303571,10758466,10758471,10758476,10760390,10760870,10761819,10937948,10937949,10937955,10939497,10940490,10941592,10982989,10982994,10982997,11085700,11085705,11085710,11339798,11339803,11339808,11393004,11393009,11393014,11481210,11481215,11481220,11481642,11481771,11481862,11574765,11574770,11574772,11853455,11853456,11853462,11854410,11940901,11940906,11940911,11942504,11980488,11980493,11980495,11981348,11981666,11982823,333279,333284,333286) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: