Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 7 | 2 | 0 | 23 | 165 | 12 | 17 | 3 | 7.14 | 582 |
Национальная сборная | 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 | 2 | 0 | 23 | 165 | 12 | 17 | 3 | 7.14 | 582 |
Отборочный турнир | 4 | 1 | 0 | 15 | 93 | 5 | 10 | 2 | 7.25 | 305 |
Финальный турнир | 3 | 1 | 0 | 8 | 72 | 7 | 7 | 1 | 7.00 | 277 |
ТОВЫ сборных | 3 | 0 | 0 | 4 | 55 | 2 | 5 | 0 | 6.17 | 174 |
Всего за сборные | 10 | 2 | 0 | 27 | 220 | 14 | 22 | 3 | 6.85 | 756 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 56627 WHERE `RP`.`player` = 56627 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125241,126340,128187,129008,130035,204172,206078,209447,209608,209691,280876,280879,280882,280885,280892,280895,338233,338235,338242,338245,338248,338254,10398238,10398241,10398244,10398247,10398254,10398257,10479104,10479107,10479110,10479113,10479120,10479123,10542350,10542353,10542356,10542359,10542366,10542369,10604558,10604561,10604564,10604567,10604574,10604577,10662712,10662715,10662718,10662721,10662728,10662731,10726438,10726441,10726444,10726447,10726454,10726457,10757386,10796776,10796779,10796782,10796785,10796792,10796795,10876462,10876465,10876468,10876471,10876478,10876481,10919834,10919837,10919840,10919843,10919850,10919853,10964267,10964269,10964276,10964279,10964282,10964288,11014846,11014851,11014856,11014857,11014864,11014867,11069654,11069659,11069664,11069665,11069672,11069675,11084881,11122204,11122209,11122214,11122215,11122222,11122225,11170624,11170625,11170631,11170635,11170638,11170644,11213798,11213799,11213805,11213809,11213812,11213818,11266692,11266697,11266702,11266703,11266710,11266713,11323430,11323431,11323437,11323441,11323444,11323450,11337853,11374886,11374887,11374893,11374897,11374900,11374906,11418591,11418596,11418599,11418604,11418607,11418612,11464757,11464762,11464765,11464770,11464773,11464778,11513967,11513972,11513975,11513980,11513983,11513988,11557045,11557050,11557053,11557058,11557061,11557066,11600533,11600538,11600541,11600546,11600549,11600554,11649555,11649560,11649562,11649568,11649571,11649573,11671678,11671679,11671685,11671689,11671692,11671698,11711138,11739195,11739196,11739202,11739206,11739209,11739215,11756965,11786954,11786959,11786962,11786967,11786970,11786975,11837024,11837029,11837032,11837037,11837040,11837045,11852587,11869014,11869019,11869022,11869027,11869030,11869035,11895845,11924014,11924019,11924022,11924027,11924030,11924035,11964051,11964052,11964058,11964062,11964065,11964071,11980324,12004295,12004296,12004302,12004306,12004309,12004315,12045546,12045551,12045553,12045559,12045562,12045564,12061193,12084764,12084769,12084771,12084777,12084780,12084782,20140,20141,20147,20151,20154,20160,71611,71616,71618,71624,71627,71629,111747,111752,111754,111760,111763,111765,158357,158362,158365,158370,158373,158378,192917,192922,192925,192930,192933,192938,232231,232236,232238,232244,232247,232249,273281,273286,273289,273294,273297,273302,288018,312601,312606,312608,312614,312617,312619,331806,357313,357318,357320,357326,357329,357331) ) 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) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 56627 WHERE `RP`.`player` = 56627 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125241,126340,128187,129008,130035,204172,206078,209447,209608,209691,280876,280879,280882,280885,280892,280895,338233,338235,338242,338245,338248,338254,10398238,10398241,10398244,10398247,10398254,10398257,10479104,10479107,10479110,10479113,10479120,10479123,10542350,10542353,10542356,10542359,10542366,10542369,10604558,10604561,10604564,10604567,10604574,10604577,10662712,10662715,10662718,10662721,10662728,10662731,10726438,10726441,10726444,10726447,10726454,10726457,10757386,10796776,10796779,10796782,10796785,10796792,10796795,10876462,10876465,10876468,10876471,10876478,10876481,10919834,10919837,10919840,10919843,10919850,10919853,10964267,10964269,10964276,10964279,10964282,10964288,11014846,11014851,11014856,11014857,11014864,11014867,11069654,11069659,11069664,11069665,11069672,11069675,11084881,11122204,11122209,11122214,11122215,11122222,11122225,11170624,11170625,11170631,11170635,11170638,11170644,11213798,11213799,11213805,11213809,11213812,11213818,11266692,11266697,11266702,11266703,11266710,11266713,11323430,11323431,11323437,11323441,11323444,11323450,11337853,11374886,11374887,11374893,11374897,11374900,11374906,11418591,11418596,11418599,11418604,11418607,11418612,11464757,11464762,11464765,11464770,11464773,11464778,11513967,11513972,11513975,11513980,11513983,11513988,11557045,11557050,11557053,11557058,11557061,11557066,11600533,11600538,11600541,11600546,11600549,11600554,11649555,11649560,11649562,11649568,11649571,11649573,11671678,11671679,11671685,11671689,11671692,11671698,11711138,11739195,11739196,11739202,11739206,11739209,11739215,11756965,11786954,11786959,11786962,11786967,11786970,11786975,11837024,11837029,11837032,11837037,11837040,11837045,11852587,11869014,11869019,11869022,11869027,11869030,11869035,11895845,11924014,11924019,11924022,11924027,11924030,11924035,11964051,11964052,11964058,11964062,11964065,11964071,11980324,12004295,12004296,12004302,12004306,12004309,12004315,12045546,12045551,12045553,12045559,12045562,12045564,12061193,12084764,12084769,12084771,12084777,12084780,12084782,20140,20141,20147,20151,20154,20160,71611,71616,71618,71624,71627,71629,111747,111752,111754,111760,111763,111765,158357,158362,158365,158370,158373,158378,192917,192922,192925,192930,192933,192938,232231,232236,232238,232244,232247,232249,273281,273286,273289,273294,273297,273302,288018,312601,312606,312608,312614,312617,312619,331806,357313,357318,357320,357326,357329,357331) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: