Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 18 | 0 | 0 | 32 | 183 | 36 | 39 | 3 | 7.17 | 56 |
Национальная сборная | 13 | 0 | 0 | 15 | 116 | 16 | 24 | 3 | 7.23 | 56 |
Отборочный турнир | 12 | 0 | 0 | 14 | 113 | 16 | 24 | 3 | 7.17 | 56 |
Финальный турнир | 1 | 0 | 0 | 1 | 3 | 0 | 0 | 0 | 8.00 | 0 |
Молодежная сборная | 5 | 0 | 0 | 17 | 67 | 20 | 15 | 0 | 7.00 | 0 |
Отборочный турнир | 4 | 0 | 0 | 15 | 54 | 15 | 14 | 0 | 7.25 | 0 |
Финальный турнир | 1 | 0 | 0 | 2 | 13 | 5 | 1 | 0 | 6.00 | 0 |
ТОВЫ сборных | 21 | 0 | 0 | 25 | 176 | 24 | 35 | 3 | 7.05 | 29 |
Всего за сборные | 39 | 0 | 0 | 57 | 359 | 60 | 74 | 6 | 7.10 | 85 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 27948 WHERE `RP`.`player` = 27948 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (10691420,10691421,10691427,10826218,10826223,10826228,11085748,11085753,11085758,11087198,11140250,11140255,11140260,11229579,11229584,11229586,11339776,11339777,11339783,11340353,11340451,11341830,11531553,11531558,11531560,11531955,11532585,11532798,11618460,11618465,11618470,11619491,11620214,11620374,11667072,11667077,11667082,11667364,11668029,11668174,11805241,11805246,11805251,11806991,11853406,11853411,11853413,11854426,11854677,11855208,11896664,11896669,11896671) ) 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` = 27948 WHERE `RP`.`player` = 27948 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (10691420,10691421,10691427,10826218,10826223,10826228,11085748,11085753,11085758,11087198,11140250,11140255,11140260,11229579,11229584,11229586,11339776,11339777,11339783,11340353,11340451,11341830,11531553,11531558,11531560,11531955,11532585,11532798,11618460,11618465,11618470,11619491,11620214,11620374,11667072,11667077,11667082,11667364,11668029,11668174,11805241,11805246,11805251,11806991,11853406,11853411,11853413,11854426,11854677,11855208,11896664,11896669,11896671) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: