Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Сэйвы | Оц | Мин | Официальные матчи сборных | 10 | 0 | 0 | 1 | 40 | 0 | 0 | 55 | 7.90 | 0 |
Национальная сборная | 10 | 0 | 0 | 1 | 40 | 0 | 0 | 55 | 7.90 | 0 |
Отборочный турнир | 9 | 0 | 0 | 1 | 36 | 0 | 0 | 51 | 8.11 | 0 |
Финальный турнир | 1 | 0 | 0 | 0 | 4 | 0 | 0 | 4 | 6.00 | 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 |
ТОВЫ сборных | 7 | 0 | 0 | 2 | 50 | 0 | 0 | 36 | 7.79 | 0 |
Всего за сборные | 17 | 0 | 0 | 3 | 90 | 0 | 0 | 91 | 7.85 | 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(140) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 16268 WHERE `RP`.`player` = 16268 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125185,126372,128131,129040,130661,131992,204114,206110,209391,209562,209640,210919,280444,280447,280450,280453,280460,280463,338522,338525,338528,338531,338538,338541,10398386,10398389,10398392,10398395,10398402,10398405,10479368,10479371,10479374,10479377,10479384,10479387,10541942,10541945,10541948,10541951,10541958,10541961,10604822,10604825,10604828,10604831,10604838,10604841,10663096,10663099,10663102,10663105,10663112,10663115,10690370,10726270,10726273,10726276,10726279,10726286,10726289,10797040,10797043,10797046,10797049,10797056,10797059,10876534,10876537,10876540,10876543,10876550,10876553,10919786,10919789,10919792,10919795,10919802,10919805,10936992,10964606,10964609,10964612,10964615,10964622,10964625,11015040,11015041,11015047,11015051,11015054,11015060,11036236,11069343,11069348,11069350,11069356,11069359,11069361,11122325,11122330,11122332,11122338,11122341,11122343,11170384,11170385,11170391,11170395,11170398,11170404,11214158,11214159,11214165,11214169,11214172,11214178,11266790,11266791,11266797,11266801,11266804,11266810,11323164,11323169,11323174,11323175,11323182,11323185,11337866,11374669,11374674,11374676,11374682,11374685,11374687,11418351,11418356,11418359,11418364,11418367,11418372,11464301,11464306,11464309,11464314,11464317,11464322,11513727,11513732,11513735,11513740,11513743,11513748,11530195,11556637,11556642,11556645,11556650,11556653,11556658,11600271,11600276,11600278,11600284,11600287,11600289,11616916,11649267,11649272,11649274,11649280,11649283,11649285,11671389,11671394,11671396,11671402,11671405,11671407,11711125,11738883,11738884,11738890,11738894,11738897,11738903,11786764,11786769,11786771,11786777,11786780,11786782,11836832,11836837,11836840,11836845,11836848,11836853,11868750,11868755,11868758,11868763,11868766,11868771,11895836,11923776,11923781,11923783,11923789,11923792,11923794,11939998,11963738,11963743,11963745,11963751,11963754,11963756,12004127,12004128,12004134,12004138,12004141,12004147,12045113,12045118,12045123,12045124,12045131,12045134,12084524,12084529,12084531,12084537,12084540,12084542,19924,19925,19931,19935,19938,19944,71490,71495,71500,71501,71508,71511,111532,111533,111539,111543,111546,111552,158286,158291,158296,158297,158304,158307,192632,192633,192639,192643,192646,192652,232494,232499,232504,232505,232512,232515,273186,273191,273196,273197,273204,273207,312314,312315,312321,312325,312328,312334,357024,357029,357034,357035,357042,357045) ) 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(140) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 16268 WHERE `RP`.`player` = 16268 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125185,126372,128131,129040,130661,131992,204114,206110,209391,209562,209640,210919,280444,280447,280450,280453,280460,280463,338522,338525,338528,338531,338538,338541,10398386,10398389,10398392,10398395,10398402,10398405,10479368,10479371,10479374,10479377,10479384,10479387,10541942,10541945,10541948,10541951,10541958,10541961,10604822,10604825,10604828,10604831,10604838,10604841,10663096,10663099,10663102,10663105,10663112,10663115,10690370,10726270,10726273,10726276,10726279,10726286,10726289,10797040,10797043,10797046,10797049,10797056,10797059,10876534,10876537,10876540,10876543,10876550,10876553,10919786,10919789,10919792,10919795,10919802,10919805,10936992,10964606,10964609,10964612,10964615,10964622,10964625,11015040,11015041,11015047,11015051,11015054,11015060,11036236,11069343,11069348,11069350,11069356,11069359,11069361,11122325,11122330,11122332,11122338,11122341,11122343,11170384,11170385,11170391,11170395,11170398,11170404,11214158,11214159,11214165,11214169,11214172,11214178,11266790,11266791,11266797,11266801,11266804,11266810,11323164,11323169,11323174,11323175,11323182,11323185,11337866,11374669,11374674,11374676,11374682,11374685,11374687,11418351,11418356,11418359,11418364,11418367,11418372,11464301,11464306,11464309,11464314,11464317,11464322,11513727,11513732,11513735,11513740,11513743,11513748,11530195,11556637,11556642,11556645,11556650,11556653,11556658,11600271,11600276,11600278,11600284,11600287,11600289,11616916,11649267,11649272,11649274,11649280,11649283,11649285,11671389,11671394,11671396,11671402,11671405,11671407,11711125,11738883,11738884,11738890,11738894,11738897,11738903,11786764,11786769,11786771,11786777,11786780,11786782,11836832,11836837,11836840,11836845,11836848,11836853,11868750,11868755,11868758,11868763,11868766,11868771,11895836,11923776,11923781,11923783,11923789,11923792,11923794,11939998,11963738,11963743,11963745,11963751,11963754,11963756,12004127,12004128,12004134,12004138,12004141,12004147,12045113,12045118,12045123,12045124,12045131,12045134,12084524,12084529,12084531,12084537,12084540,12084542,19924,19925,19931,19935,19938,19944,71490,71495,71500,71501,71508,71511,111532,111533,111539,111543,111546,111552,158286,158291,158296,158297,158304,158307,192632,192633,192639,192643,192646,192652,232494,232499,232504,232505,232512,232515,273186,273191,273196,273197,273204,273207,312314,312315,312321,312325,312328,312334,357024,357029,357034,357035,357042,357045) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: