Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 25 | 13 | 5 | 1 | 174 | 97 | 1 | 63 | 7.34 | 1587 |
Национальная сборная | 15 | 4 | 3 | 1 | 108 | 30 | 0 | 20 | 6.97 | 839 |
Отборочный турнир | 9 | 1 | 2 | 1 | 69 | 21 | 0 | 14 | 6.83 | 552 |
Финальный турнир | 6 | 3 | 1 | 0 | 39 | 9 | 0 | 6 | 7.17 | 287 |
Молодежная сборная | 10 | 9 | 2 | 0 | 66 | 67 | 1 | 43 | 7.90 | 748 |
Отборочный турнир | 7 | 5 | 2 | 0 | 45 | 47 | 1 | 34 | 8.07 | 518 |
Финальный турнир | 3 | 4 | 0 | 0 | 21 | 20 | 0 | 9 | 7.50 | 230 |
ТОВЫ сборных | 17 | 6 | 3 | 7 | 103 | 89 | 0 | 37 | 7.53 | 941 |
Всего за сборные | 42 | 19 | 8 | 8 | 277 | 186 | 1 | 100 | 7.42 | 2528 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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(207) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 53423 WHERE `RP`.`player` = 53423 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (246868,246869,246875,303527,303532,303534,10569188,10569189,10569195,10691419,10691424,10691426,10826196,10826197,10826203,10826534,10982930,10982935,10982940,10983325,11038339,11038344,11038347,11085786,11085787,11085793,11087194,11087485,11087617,11140237,11140242,11140245,11186635,11186640,11186643,11434144,11434145,11434151,11481175,11481180,11481182,11531515,11531520,11531523,11531956,11667073,11667078,11667080,11667357,11757810,11757815,11757818,11758746,11758856,11758949,11853393,11853398,11853403,11854429,11896652,11896657,11896659,11896906,11940840,11940845,11940848,11942515,12061940,12061945,12061947,12101903,12101904,12101910,48112,48113,48119,126994,126999,127004,128613) ) 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(207) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 53423 WHERE `RP`.`player` = 53423 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (246868,246869,246875,303527,303532,303534,10569188,10569189,10569195,10691419,10691424,10691426,10826196,10826197,10826203,10826534,10982930,10982935,10982940,10983325,11038339,11038344,11038347,11085786,11085787,11085793,11087194,11087485,11087617,11140237,11140242,11140245,11186635,11186640,11186643,11434144,11434145,11434151,11481175,11481180,11481182,11531515,11531520,11531523,11531956,11667073,11667078,11667080,11667357,11757810,11757815,11757818,11758746,11758856,11758949,11853393,11853398,11853403,11854429,11896652,11896657,11896659,11896906,11940840,11940845,11940848,11942515,12061940,12061945,12061947,12101903,12101904,12101910,48112,48113,48119,126994,126999,127004,128613) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: