Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 12 | 3 | 2 | 1 | 31 | 59 | 1 | 18 | 7.12 | 148 |
Национальная сборная | 10 | 3 | 2 | 0 | 30 | 56 | 1 | 16 | 7.20 | 148 |
Отборочный турнир | 9 | 2 | 1 | 0 | 27 | 50 | 1 | 14 | 7.00 | 91 |
Финальный турнир | 1 | 1 | 1 | 0 | 3 | 6 | 0 | 2 | 9.00 | 57 |
Молодежная сборная | 2 | 0 | 0 | 1 | 1 | 3 | 0 | 2 | 6.75 | 0 |
Отборочный турнир | 1 | 0 | 0 | 0 | 1 | 3 | 0 | 2 | 8.50 | 0 |
Финальный турнир | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 5.00 | 0 |
ТОВЫ сборных | 14 | 6 | 4 | 7 | 30 | 46 | 5 | 18 | 6.54 | 75 |
Всего за сборные | 26 | 9 | 6 | 8 | 61 | 105 | 6 | 36 | 6.81 | 223 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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(139, 208) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 9290 WHERE `RP`.`player` = 9290 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125239,126336,128189,129009,130038,204170,206074,209449,209607,209696,280804,280807,280810,280813,280820,280823,338258,338261,338264,338267,338274,338277,10398118,10398121,10398124,10398127,10398134,10398137,10479008,10479011,10479014,10479017,10479024,10479027,10542278,10542281,10542284,10542287,10542294,10542297,10604582,10604585,10604588,10604591,10604598,10604601,10637415,10639536,10639541,10639546,10662735,10662737,10662744,10662747,10662750,10662756,10691372,10691373,10691379,10692377,10692490,10693164,10726556,10726562,10726565,10726570,10726573,10726575,10796679,10796681,10796688,10796691,10796694,10796700,10825114,10826242,10826247,10826252,10826546,10826633,10827309,10876315,10876320,10876323,10876328,10876331,10876336,10893747,10893752,10893754,10893985,10920048,10920054,10920057,10920062,10920065,10920067,10964363,10964365,10964372,10964375,10964378,10964384,11014800,11014801,11014807,11014811,11014814,11014820,11038294,11038295,11038301,11069511,11069516,11069518,11069524,11069527,11069529,11122038,11122039,11122045,11122049,11122052,11122058,11139740,11170503,11170508,11170510,11170516,11170519,11170521,11186268,11186660,11186665,11186670,11213869,11213874,11213876,11213882,11213885,11213887,11229114,11229614,11229619,11229624,11230836,11266499,11266504,11266507,11266512,11266515,11266520,11323286,11323287,11323293,11323297,11323300,11323306,11337854,11374838,11374839,11374845,11374849,11374852,11374858,11418736,11418741,11418746,11418747,11418754,11418757,11434204,11434205,11434211,11464640,11464641,11464647,11464651,11464654,11464660,11513753,11513758,11513760,11513766,11513769,11513771,11556951,11556956,11556958,11556964,11556967,11556969,11600702,11600707,11600712,11600713,11600720,11600723,11649554,11649559,11649564,11649565,11649572,11649575,11671604,11671609,11671614,11671615,11671622,11671625,11711135,11739169,11739174,11739179,11739180,11739187,11739190,11756963,11757840,11757845,11757835,11786981,11786982,11786988,11786992,11786995,11787001,11837193,11837198,11837203,11837204,11837211,11837214,11868873,11868874,11868880,11868884,11868887,11868893,11923967,11923972,11923977,11923978,11923985,11923988,11940013,11964171,11964172,11964178,11964182,11964185,11964191,11980450,11980455,11980458,12004388,12004393,12004396,12004401,12004404,12004409,12021458,12021463,12021465,12045378,12045383,12045385,12045391,12045394,12045396,12061952,12061957,12061959,12062545,12062944,12063059,12084642,12084647,12084650,12084655,12084658,12084663,20164,20165,20171,20175,20178,20184,71754,71759,71764,71765,71772,71775,111698,111703,111708,111709,111716,111719,158550,158555,158560,158561,158568,158571,192750,192755,192760,192761,192768,192771,232280,232281,232287,232291,232294,232300,273428,273429,273435,273439,273442,273448,288016,288850,288855,288860,289798,312457,312462,312464,312470,312473,312475,357242,357243,357249,357253,357256,357262,372001) ) 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(139, 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` = 9290 WHERE `RP`.`player` = 9290 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125239,126336,128189,129009,130038,204170,206074,209449,209607,209696,280804,280807,280810,280813,280820,280823,338258,338261,338264,338267,338274,338277,10398118,10398121,10398124,10398127,10398134,10398137,10479008,10479011,10479014,10479017,10479024,10479027,10542278,10542281,10542284,10542287,10542294,10542297,10604582,10604585,10604588,10604591,10604598,10604601,10637415,10639536,10639541,10639546,10662735,10662737,10662744,10662747,10662750,10662756,10691372,10691373,10691379,10692377,10692490,10693164,10726556,10726562,10726565,10726570,10726573,10726575,10796679,10796681,10796688,10796691,10796694,10796700,10825114,10826242,10826247,10826252,10826546,10826633,10827309,10876315,10876320,10876323,10876328,10876331,10876336,10893747,10893752,10893754,10893985,10920048,10920054,10920057,10920062,10920065,10920067,10964363,10964365,10964372,10964375,10964378,10964384,11014800,11014801,11014807,11014811,11014814,11014820,11038294,11038295,11038301,11069511,11069516,11069518,11069524,11069527,11069529,11122038,11122039,11122045,11122049,11122052,11122058,11139740,11170503,11170508,11170510,11170516,11170519,11170521,11186268,11186660,11186665,11186670,11213869,11213874,11213876,11213882,11213885,11213887,11229114,11229614,11229619,11229624,11230836,11266499,11266504,11266507,11266512,11266515,11266520,11323286,11323287,11323293,11323297,11323300,11323306,11337854,11374838,11374839,11374845,11374849,11374852,11374858,11418736,11418741,11418746,11418747,11418754,11418757,11434204,11434205,11434211,11464640,11464641,11464647,11464651,11464654,11464660,11513753,11513758,11513760,11513766,11513769,11513771,11556951,11556956,11556958,11556964,11556967,11556969,11600702,11600707,11600712,11600713,11600720,11600723,11649554,11649559,11649564,11649565,11649572,11649575,11671604,11671609,11671614,11671615,11671622,11671625,11711135,11739169,11739174,11739179,11739180,11739187,11739190,11756963,11757840,11757845,11757835,11786981,11786982,11786988,11786992,11786995,11787001,11837193,11837198,11837203,11837204,11837211,11837214,11868873,11868874,11868880,11868884,11868887,11868893,11923967,11923972,11923977,11923978,11923985,11923988,11940013,11964171,11964172,11964178,11964182,11964185,11964191,11980450,11980455,11980458,12004388,12004393,12004396,12004401,12004404,12004409,12021458,12021463,12021465,12045378,12045383,12045385,12045391,12045394,12045396,12061952,12061957,12061959,12062545,12062944,12063059,12084642,12084647,12084650,12084655,12084658,12084663,20164,20165,20171,20175,20178,20184,71754,71759,71764,71765,71772,71775,111698,111703,111708,111709,111716,111719,158550,158555,158560,158561,158568,158571,192750,192755,192760,192761,192768,192771,232280,232281,232287,232291,232294,232300,273428,273429,273435,273439,273442,273448,288016,288850,288855,288860,289798,312457,312462,312464,312470,312473,312475,357242,357243,357249,357253,357256,357262,372001) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: