Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 3 | 0 | 0 | 14 | 66 | 4 | 19 | 0 | 7.17 | 153 |
Национальная сборная | 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 |
Молодежная сборная | 3 | 0 | 0 | 14 | 66 | 4 | 19 | 0 | 7.17 | 153 |
Отборочный турнир | 2 | 0 | 0 | 10 | 38 | 0 | 16 | 0 | 7.25 | 92 |
Финальный турнир | 1 | 0 | 0 | 4 | 28 | 4 | 3 | 0 | 7.00 | 61 |
ТОВЫ сборных | 3 | 0 | 0 | 12 | 96 | 11 | 22 | 0 | 7.83 | 176 |
Всего за сборные | 6 | 0 | 0 | 26 | 162 | 15 | 41 | 0 | 7.50 | 329 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 81736 WHERE `RP`.`player` = 81736 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125222,126321,128991,130014,204153,206057,209589,209672,280826,280832,280835,280840,280843,280845,338185,338187,338194,338197,338200,338206,10398117,10398119,10398126,10398129,10398132,10398138,10440274,10441186,10441191,10441196,10442077,10442242,10443323,10479077,10479082,10479085,10479090,10479093,10479098,10512405,10542348,10542354,10542357,10542362,10542365,10542367,10604412,10604418,10604421,10604426,10604429,10604431,10662806,10662812,10662815,10662820,10662823,10662825,10691384,10691385,10691391,10726533,10726535,10726542,10726545,10726548,10726554,10757389,10796607,10796609,10796616,10796619,10796622,10796628,10876486,10876489,10876492,10876495,10876502,10876505,10919906,10919909,10919912,10919915,10919922,10919925,10964364,10964367,10964370,10964373,10964380,10964383,10982956,10982957,10982963,10983331,11014893,11014898,11014901,11014906,11014909,11014914,11036246,11038304,11038309,11038314,11038750,11069725,11069730,11069733,11069738,11069741,11069746,11122131,11122136,11122139,11122144,11122147,11122152,11140309,11140314,11140317,11141173,11141805,11141974,11170669,11170674,11170677,11170682,11170685,11170690,11186270,11186650,11186651,11186657,11213891,11213896,11213899,11213904,11213907,11213912,11229107,11229650,11229655,11229660,11230835,11231879,11232734,11266595,11266600,11266603,11266608,11266611,11266616,11323427,11323432,11323435,11323440,11323443,11323448,11339809,11339814,11339817,11340360,11374883,11374888,11374891,11374896,11374899,11374904,11418785,11418790,11418792,11418798,11418801,11418803,11434213,11434218,11434221,11464661,11464666,11464669,11464674,11464677,11464682,11479168,11481236,11481237,11481243,11481637,11513847,11513852,11513855,11513860,11513863,11513868,11531587,11531592,11531595,11531962,11532590,11532794,11556925,11556930,11556933,11556938,11556941,11556946,11600653,11600658,11600661,11600666,11600669,11600674,11618531,11618536,11618539,11649649,11649654,11649657,11649662,11649665,11649670,11667119,11667124,11667127,11671699,11671704,11671707,11671712,11671715,11671720,11739338,11739343,11739345,11739351,11739354,11739356,11757865,11757867,11757860,11758754,11758860,11758951,11787002,11787007,11787010,11787015,11787018,11787023,11805221,11837264,11837269,11837272,11837277,11837280,11837285,11852589,11853479,11853480,11853486,11868942,11868947,11868950,11868955,11868958,11868963,11924088,11924093,11924095,11924101,11924104,11924106,11964099,11964100,11964106,11964110,11964113,11964119,12004175,12004176,12004182,12004186,12004189,12004195,12045595,12045596,12045602,12045606,12045609,12045615,12084837,12084838,12084844,12084848,12084851,12084857,12101113,12101961,12101966,12101971,20307,20312,20314,20320,20323,20325,48049,48054,48057,48359,71801,71806,71809,71814,71817,71822,111865,111870,111873,111878,111881,111886,158573,158578,158581,158586,158589,158594,173659,173664,173667,174571,174672,175367,192749,192754,192757,192762,192765,192770,232325,232330,232333,232338,232341,232346,247351,248188,248193,248198,249074,249214,249770,273449,273454,273457,273462,273465,273470,288887,288892,288894,312455,312460,312463,312468,312471,312476,331808,357191,357196,357199,357204,357207,357212,372845,372850,372852,373750) ) 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` = 81736 WHERE `RP`.`player` = 81736 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125222,126321,128991,130014,204153,206057,209589,209672,280826,280832,280835,280840,280843,280845,338185,338187,338194,338197,338200,338206,10398117,10398119,10398126,10398129,10398132,10398138,10440274,10441186,10441191,10441196,10442077,10442242,10443323,10479077,10479082,10479085,10479090,10479093,10479098,10512405,10542348,10542354,10542357,10542362,10542365,10542367,10604412,10604418,10604421,10604426,10604429,10604431,10662806,10662812,10662815,10662820,10662823,10662825,10691384,10691385,10691391,10726533,10726535,10726542,10726545,10726548,10726554,10757389,10796607,10796609,10796616,10796619,10796622,10796628,10876486,10876489,10876492,10876495,10876502,10876505,10919906,10919909,10919912,10919915,10919922,10919925,10964364,10964367,10964370,10964373,10964380,10964383,10982956,10982957,10982963,10983331,11014893,11014898,11014901,11014906,11014909,11014914,11036246,11038304,11038309,11038314,11038750,11069725,11069730,11069733,11069738,11069741,11069746,11122131,11122136,11122139,11122144,11122147,11122152,11140309,11140314,11140317,11141173,11141805,11141974,11170669,11170674,11170677,11170682,11170685,11170690,11186270,11186650,11186651,11186657,11213891,11213896,11213899,11213904,11213907,11213912,11229107,11229650,11229655,11229660,11230835,11231879,11232734,11266595,11266600,11266603,11266608,11266611,11266616,11323427,11323432,11323435,11323440,11323443,11323448,11339809,11339814,11339817,11340360,11374883,11374888,11374891,11374896,11374899,11374904,11418785,11418790,11418792,11418798,11418801,11418803,11434213,11434218,11434221,11464661,11464666,11464669,11464674,11464677,11464682,11479168,11481236,11481237,11481243,11481637,11513847,11513852,11513855,11513860,11513863,11513868,11531587,11531592,11531595,11531962,11532590,11532794,11556925,11556930,11556933,11556938,11556941,11556946,11600653,11600658,11600661,11600666,11600669,11600674,11618531,11618536,11618539,11649649,11649654,11649657,11649662,11649665,11649670,11667119,11667124,11667127,11671699,11671704,11671707,11671712,11671715,11671720,11739338,11739343,11739345,11739351,11739354,11739356,11757865,11757867,11757860,11758754,11758860,11758951,11787002,11787007,11787010,11787015,11787018,11787023,11805221,11837264,11837269,11837272,11837277,11837280,11837285,11852589,11853479,11853480,11853486,11868942,11868947,11868950,11868955,11868958,11868963,11924088,11924093,11924095,11924101,11924104,11924106,11964099,11964100,11964106,11964110,11964113,11964119,12004175,12004176,12004182,12004186,12004189,12004195,12045595,12045596,12045602,12045606,12045609,12045615,12084837,12084838,12084844,12084848,12084851,12084857,12101113,12101961,12101966,12101971,20307,20312,20314,20320,20323,20325,48049,48054,48057,48359,71801,71806,71809,71814,71817,71822,111865,111870,111873,111878,111881,111886,158573,158578,158581,158586,158589,158594,173659,173664,173667,174571,174672,175367,192749,192754,192757,192762,192765,192770,232325,232330,232333,232338,232341,232346,247351,248188,248193,248198,249074,249214,249770,273449,273454,273457,273462,273465,273470,288887,288892,288894,312455,312460,312463,312468,312471,312476,331808,357191,357196,357199,357204,357207,357212,372845,372850,372852,373750) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: