Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 18 | 8 | 5 | 4 | 245 | 56 | 1 | 37 | 6.83 | 0 |
Национальная сборная | 18 | 8 | 5 | 4 | 245 | 56 | 1 | 37 | 6.83 | 0 |
Отборочный турнир | 16 | 8 | 5 | 3 | 219 | 48 | 1 | 36 | 6.91 | 0 |
Финальный турнир | 2 | 0 | 0 | 1 | 26 | 8 | 0 | 1 | 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 |
ТОВЫ сборных | 22 | 4 | 5 | 1 | 253 | 61 | 4 | 45 | 6.82 | 0 |
Всего за сборные | 40 | 12 | 10 | 5 | 498 | 117 | 5 | 82 | 6.83 | 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` = 7574 WHERE `RP`.`player` = 7574 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (246904,246905,246911,10513296,10513297,10513303,10514091,10514360,10514500,11085750,11085751,11085757,11667096,11667101,11667106,11667362,11711940,11711945,11711947,11713173,11713638,11713763,11757788,11757793,11757795,11758741,11805243,11805244,11805250,11853428,11853433,11853436,11854428,11854676,11855206,11896674,11896679,11896682,11896911,11896985,11897053,11940876,11940881,11940884,11942514,11942648,11942745,11980426,11980431,11980434,12021432,12021437,12021440,12061902,12061907,12061910,12062548,12062943,12063054,12101888,12101893,12101896,12102546,12103521,12103698,173637,173642,173644,288815,288820,288822,333220,333221,333227) ) 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` = 7574 WHERE `RP`.`player` = 7574 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (246904,246905,246911,10513296,10513297,10513303,10514091,10514360,10514500,11085750,11085751,11085757,11667096,11667101,11667106,11667362,11711940,11711945,11711947,11713173,11713638,11713763,11757788,11757793,11757795,11758741,11805243,11805244,11805250,11853428,11853433,11853436,11854428,11854676,11855206,11896674,11896679,11896682,11896911,11896985,11897053,11940876,11940881,11940884,11942514,11942648,11942745,11980426,11980431,11980434,12021432,12021437,12021440,12061902,12061907,12061910,12062548,12062943,12063054,12101888,12101893,12101896,12102546,12103521,12103698,173637,173642,173644,288815,288820,288822,333220,333221,333227) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: