Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 10 | 3 | 0 | 4 | 120 | 53 | 1 | 15 | 6.95 | 690 |
Национальная сборная | 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 |
Молодежная сборная | 10 | 3 | 0 | 4 | 120 | 53 | 1 | 15 | 6.95 | 690 |
Отборочный турнир | 7 | 2 | 0 | 3 | 94 | 45 | 1 | 11 | 7.14 | 515 |
Финальный турнир | 3 | 1 | 0 | 1 | 26 | 8 | 0 | 4 | 6.50 | 175 |
ТОВЫ сборных | 7 | 7 | 3 | 1 | 105 | 59 | 0 | 10 | 8.57 | 339 |
Всего за сборные | 17 | 10 | 3 | 5 | 225 | 112 | 1 | 25 | 7.62 | 1029 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 71032 WHERE `RP`.`player` = 71032 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (303574,303579,303584,10370758,10370763,10370768,10371758,10441222,10441227,10441232,11085702,11085703,11085709,11087181,11286127,11286132,11286135,11286605,11286695,11287740,11339797,11339802,11339805,11618522,11618523,11618529,11619502,11620218,11620372,11711988,11711993,11711995,11805302,11805307,11805309,11806987,11807243,11807853,11853464,11853469,11853472,11854408,11854679,11855211,11896698,11896703,11896706,11896921,11896988,11897057,11940912,11940917,11940920,12061986,12061991,12061994,12062541,48025,48030,48033,86467,86472,86475,87289,87431,87503,173696,173701,173706,174577,210949,210954,210956,212518,212675,212764,248187,248192,248195,249071,249215,249767,333289,333294,333297) ) 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` = 71032 WHERE `RP`.`player` = 71032 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (303574,303579,303584,10370758,10370763,10370768,10371758,10441222,10441227,10441232,11085702,11085703,11085709,11087181,11286127,11286132,11286135,11286605,11286695,11287740,11339797,11339802,11339805,11618522,11618523,11618529,11619502,11620218,11620372,11711988,11711993,11711995,11805302,11805307,11805309,11806987,11807243,11807853,11853464,11853469,11853472,11854408,11854679,11855211,11896698,11896703,11896706,11896921,11896988,11897057,11940912,11940917,11940920,12061986,12061991,12061994,12062541,48025,48030,48033,86467,86472,86475,87289,87431,87503,173696,173701,173706,174577,210949,210954,210956,212518,212675,212764,248187,248192,248195,249071,249215,249767,333289,333294,333297) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: