Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 15 | 5 | 6 | 1 | 22 | 67 | 0 | 19 | 7.17 | 401 |
Национальная сборная | 6 | 4 | 4 | 0 | 14 | 14 | 0 | 12 | 7.17 | 401 |
Отборочный турнир | 5 | 4 | 4 | 0 | 14 | 11 | 0 | 11 | 7.50 | 370 |
Финальный турнир | 1 | 0 | 0 | 0 | 0 | 3 | 0 | 1 | 5.50 | 31 |
Молодежная сборная | 9 | 1 | 2 | 1 | 8 | 53 | 0 | 7 | 7.17 | 0 |
Отборочный турнир | 6 | 0 | 2 | 1 | 8 | 40 | 0 | 4 | 7.50 | 0 |
Финальный турнир | 3 | 1 | 0 | 0 | 0 | 13 | 0 | 3 | 6.50 | 0 |
ТОВЫ сборных | 7 | 2 | 0 | 0 | 10 | 28 | 0 | 7 | 6.56 | 197 |
Всего за сборные | 22 | 7 | 6 | 1 | 32 | 95 | 0 | 26 | 6.97 | 598 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 37515 WHERE `RP`.`player` = 37515 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (10639536,10639541,10639546,10691372,10691373,10691379,10692377,10692490,10693164,10826242,10826247,10826252,10826546,10826633,10827309,10893747,10893752,10893754,10893985,11038294,11038295,11038301,11186660,11186665,11186670,11229614,11229619,11229624,11230836,11434204,11434205,11434211,11757840,11757845,11757835,11980450,11980455,11980458,12021458,12021463,12021465,12061952,12061957,12061959,12062545,12062944,12063059,288850,288855,288860,289798) ) 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` = 37515 WHERE `RP`.`player` = 37515 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (10639536,10639541,10639546,10691372,10691373,10691379,10692377,10692490,10693164,10826242,10826247,10826252,10826546,10826633,10827309,10893747,10893752,10893754,10893985,11038294,11038295,11038301,11186660,11186665,11186670,11229614,11229619,11229624,11230836,11434204,11434205,11434211,11757840,11757845,11757835,11980450,11980455,11980458,12021458,12021463,12021465,12061952,12061957,12061959,12062545,12062944,12063059,288850,288855,288860,289798) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: