Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 23 | 0 | 5 | 42 | 332 | 45 | 43 | 0 | 7.30 | 998 |
Национальная сборная | 14 | 0 | 2 | 19 | 194 | 33 | 26 | 0 | 7.89 | 998 |
Отборочный турнир | 13 | 0 | 2 | 19 | 181 | 28 | 22 | 0 | 7.92 | 942 |
Финальный турнир | 1 | 0 | 0 | 0 | 13 | 5 | 4 | 0 | 7.50 | 56 |
Молодежная сборная | 9 | 0 | 3 | 23 | 138 | 12 | 17 | 0 | 6.39 | 0 |
Отборочный турнир | 7 | 0 | 3 | 19 | 109 | 9 | 14 | 0 | 6.71 | 0 |
Финальный турнир | 2 | 0 | 0 | 4 | 29 | 3 | 3 | 0 | 5.25 | 0 |
ТОВЫ сборных | 16 | 0 | 0 | 27 | 252 | 18 | 33 | 3 | 7.20 | 715 |
Всего за сборные | 39 | 0 | 5 | 69 | 584 | 63 | 76 | 3 | 7.26 | 1713 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 37512 WHERE `RP`.`player` = 37512 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (246877,246882,246885,250355,250960,251093,303503,303508,303510,303659,10639502,10639503,10639509,10758420,10758421,10758427,10760385,10826220,10826221,10826227,10826536,10826635,10827312,10893699,10893704,10893706,11339740,11339741,11339747,11434129,11434134,11434137,11435323,11481161,11481166,11481169,11531529,11531534,11531536,11574717,11574722,11574724,11618474,11618475,11618481,11619492,12021446,12021451,12021453,48110,48115,48120,173626,173627,173633,174564,174668,175361,248116,248121,248126,288813,288818,288821,289787,290018,290578,333230,333235,333240,333568,334620,334997,372786,372787,372793,373739) ) 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` = 37512 WHERE `RP`.`player` = 37512 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (246877,246882,246885,250355,250960,251093,303503,303508,303510,303659,10639502,10639503,10639509,10758420,10758421,10758427,10760385,10826220,10826221,10826227,10826536,10826635,10827312,10893699,10893704,10893706,11339740,11339741,11339747,11434129,11434134,11434137,11435323,11481161,11481166,11481169,11531529,11531534,11531536,11574717,11574722,11574724,11618474,11618475,11618481,11619492,12021446,12021451,12021453,48110,48115,48120,173626,173627,173633,174564,174668,175361,248116,248121,248126,288813,288818,288821,289787,290018,290578,333230,333235,333240,333568,334620,334997,372786,372787,372793,373739) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: