Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 8 | 0 | 0 | 44 | 98 | 0 | 42 | 0 | 7.00 | 0 |
Национальная сборная | 8 | 0 | 0 | 44 | 98 | 0 | 42 | 0 | 7.00 | 0 |
Отборочный турнир | 6 | 0 | 0 | 36 | 76 | 0 | 30 | 0 | 7.25 | 0 |
Финальный турнир | 2 | 0 | 0 | 8 | 22 | 0 | 12 | 0 | 6.25 | 0 |
Молодежная сборная | 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 |
ТОВЫ сборных | 9 | 0 | 0 | 39 | 91 | 1 | 37 | 0 | 7.00 | 0 |
Всего за сборные | 17 | 0 | 0 | 83 | 189 | 1 | 79 | 0 | 7.00 | 0 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 4149 WHERE `RP`.`player` = 4149 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (10370806,10370811,10370816,10371779,10372463,10372530,10441259,10441264,10441266,10442087,10442245,10443327,10691408,10691409,10691415,10692381,10938008,10938009,10938015,10982917,10982922,10982925,10983324,11085759,11085764,11085767,11140263,11140268,11140270,11186637,11186642,11186644,11188240,11188363,11188465,11574742,11574743,11574749,11805229,11805234,11805239,11853395,11853396,11853402,248140,248145,248150,372784,372789,372794,373736) ) 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` = 4149 WHERE `RP`.`player` = 4149 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (10370806,10370811,10370816,10371779,10372463,10372530,10441259,10441264,10441266,10442087,10442245,10443327,10691408,10691409,10691415,10692381,10938008,10938009,10938015,10982917,10982922,10982925,10983324,11085759,11085764,11085767,11140263,11140268,11140270,11186637,11186642,11186644,11188240,11188363,11188465,11574742,11574743,11574749,11805229,11805234,11805239,11853395,11853396,11853402,248140,248145,248150,372784,372789,372794,373736) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: