Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 7 | 2 | 0 | 23 | 165 | 12 | 17 | 3 | 7.14 | 582 |
Национальная сборная | 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 |
Молодежная сборная | 7 | 2 | 0 | 23 | 165 | 12 | 17 | 3 | 7.14 | 582 |
Отборочный турнир | 4 | 1 | 0 | 15 | 93 | 5 | 10 | 2 | 7.25 | 305 |
Финальный турнир | 3 | 1 | 0 | 8 | 72 | 7 | 7 | 1 | 7.00 | 277 |
ТОВЫ сборных | 3 | 0 | 0 | 4 | 55 | 2 | 5 | 0 | 6.17 | 174 |
Всего за сборные | 10 | 2 | 0 | 27 | 220 | 14 | 22 | 3 | 6.85 | 756 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 56627 WHERE `RP`.`player` = 56627 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (10569128,10569129,10569135,11085724,11085729,11085734,11087186,11186686,11186687,11186693,11286106,11286107,11286113,11339810,11339815,11339820,11393005,11393010,11393012,11394295,11394691,11394853,11434203,11434208,11434210,11435313,11481211,11481216,11481218,11531589,11531594,11531596,11574789,11574794,11574796,11575593,11712023,11712028,11712033,11757852,11757857,11757847,11758750,11758862,11758946,11853465,11853470,11853475,11854411,11854681,11855210,12021459,12021460,12021466,12022003,48040,48041,48047,48358,127055,127060,127062,128622,248177,248182,248184,249073,288862,288867,288872,333304,333305,333311) ) 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` = 56627 WHERE `RP`.`player` = 56627 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (10569128,10569129,10569135,11085724,11085729,11085734,11087186,11186686,11186687,11186693,11286106,11286107,11286113,11339810,11339815,11339820,11393005,11393010,11393012,11394295,11394691,11394853,11434203,11434208,11434210,11435313,11481211,11481216,11481218,11531589,11531594,11531596,11574789,11574794,11574796,11575593,11712023,11712028,11712033,11757852,11757857,11757847,11758750,11758862,11758946,11853465,11853470,11853475,11854411,11854681,11855210,12021459,12021460,12021466,12022003,48040,48041,48047,48358,127055,127060,127062,128622,248177,248182,248184,249073,288862,288867,288872,333304,333305,333311) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: