Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 11 | 0 | 0 | 47 | 145 | 1 | 22 | 2 | 6.77 | 422 |
Национальная сборная | 5 | 0 | 0 | 19 | 73 | 0 | 16 | 1 | 6.60 | 422 |
Отборочный турнир | 5 | 0 | 0 | 19 | 73 | 0 | 16 | 1 | 6.60 | 422 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 6 | 0 | 0 | 28 | 72 | 1 | 6 | 1 | 6.92 | 0 |
Отборочный турнир | 3 | 0 | 0 | 17 | 37 | 1 | 4 | 0 | 7.00 | 0 |
Финальный турнир | 3 | 0 | 0 | 11 | 35 | 0 | 2 | 1 | 6.83 | 0 |
ТОВЫ сборных | 9 | 0 | 0 | 28 | 106 | 0 | 15 | 0 | 6.56 | 91 |
Всего за сборные | 20 | 0 | 0 | 75 | 251 | 1 | 37 | 2 | 6.67 | 513 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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, 207) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 35857 WHERE `RP`.`player` = 35857 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125191,126378,128137,129046,130291,204120,206116,209397,209646,209729,280443,280445,280452,280455,280458,280464,338593,338595,338602,338605,338608,338614,10398578,10398581,10398584,10398587,10398594,10398597,10479320,10479323,10479326,10479329,10479336,10479339,10512415,10541941,10541943,10541950,10541953,10541956,10541962,10604750,10604753,10604756,10604759,10604766,10604769,10637428,10639512,10639517,10639522,10640818,10640940,10641036,10663047,10663049,10663056,10663059,10663062,10663068,10726269,10726271,10726278,10726281,10726284,10726290,10797015,10797017,10797024,10797027,10797030,10797036,10876677,10876679,10876686,10876689,10876692,10876698,10919545,10919547,10919554,10919557,10919560,10919566,10964582,10964585,10964588,10964591,10964598,10964601,10981489,11015016,11015017,11015023,11015027,11015030,11015036,11036229,11038316,11038321,11038326,11038801,11038881,11038977,11069464,11069465,11069471,11069475,11069478,11069484,11122374,11122375,11122381,11122385,11122388,11122394,11170430,11170435,11170440,11170441,11170448,11170451,11186272,11186600,11186605,11186610,11188244,11188361,11188466,11214014,11214015,11214021,11214025,11214028,11214034,11266886,11266887,11266893,11266897,11266900,11266906,11323068,11323073,11323078,11323079,11323086,11323089,11374644,11374649,11374654,11374655,11374662,11374665,11418306,11418307,11418313,11418317,11418320,11418326,11433505,11464304,11464305,11464311,11464315,11464318,11464324,11479157,11513634,11513635,11513641,11513645,11513648,11513654,11556592,11556593,11556599,11556603,11556606,11556612,11600390,11600395,11600400,11600401,11600408,11600411,11649146,11649151,11649156,11649157,11649164,11649167,11666267,11667084,11667089,11667094,11667358,11668032,11668167,11671269,11671274,11671276,11671282,11671285,11671287,11711938,11711943,11711946,11739024,11739029,11739032,11739037,11739040,11739045,11757774,11757779,11757782,11786666,11786671,11786674,11786679,11786682,11786687,11805266,11805271,11805273,11836880,11836885,11836888,11836893,11836896,11836901,11852597,11853417,11853422,11853427,11854424,11854672,11855207,11868774,11868779,11868782,11868787,11868790,11868795,11923702,11923707,11923710,11923715,11923718,11923723,11940007,11963786,11963791,11963793,11963799,11963802,11963804,11980320,11980403,11980408,11980413,12003982,12003987,12003989,12003995,12003998,12004000,12045354,12045359,12045361,12045367,12045370,12045372,12061904,12061909,12061911,12084330,12084335,12084338,12084343,12084346,12084351,12101902,12101907,12101909,12102550,19849,19854,19857,19862,19865,19870,47379,71417,71422,71425,71430,71433,71438,85600,86408,86413,86418,111435,111440,111442,111448,111451,111453,127019,127024,127026,158141,158146,158149,158154,158157,158162,172817,173650,173651,173657,174569,192701,192706,192709,192714,192717,192722,210098,210900,210905,210910,232589,232594,232597,232602,232605,232610,247345,248128,248133,248138,249065,249210,249764,273185,273190,273193,273198,273201,273206,287999,288814,288819,288824,289784,290022,290579,312191,312196,312199,312204,312207,312212,356951,356956,356959,356964,356967,356972,372795,372800,372803,373737) ) 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, 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` = 35857 WHERE `RP`.`player` = 35857 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125191,126378,128137,129046,130291,204120,206116,209397,209646,209729,280443,280445,280452,280455,280458,280464,338593,338595,338602,338605,338608,338614,10398578,10398581,10398584,10398587,10398594,10398597,10479320,10479323,10479326,10479329,10479336,10479339,10512415,10541941,10541943,10541950,10541953,10541956,10541962,10604750,10604753,10604756,10604759,10604766,10604769,10637428,10639512,10639517,10639522,10640818,10640940,10641036,10663047,10663049,10663056,10663059,10663062,10663068,10726269,10726271,10726278,10726281,10726284,10726290,10797015,10797017,10797024,10797027,10797030,10797036,10876677,10876679,10876686,10876689,10876692,10876698,10919545,10919547,10919554,10919557,10919560,10919566,10964582,10964585,10964588,10964591,10964598,10964601,10981489,11015016,11015017,11015023,11015027,11015030,11015036,11036229,11038316,11038321,11038326,11038801,11038881,11038977,11069464,11069465,11069471,11069475,11069478,11069484,11122374,11122375,11122381,11122385,11122388,11122394,11170430,11170435,11170440,11170441,11170448,11170451,11186272,11186600,11186605,11186610,11188244,11188361,11188466,11214014,11214015,11214021,11214025,11214028,11214034,11266886,11266887,11266893,11266897,11266900,11266906,11323068,11323073,11323078,11323079,11323086,11323089,11374644,11374649,11374654,11374655,11374662,11374665,11418306,11418307,11418313,11418317,11418320,11418326,11433505,11464304,11464305,11464311,11464315,11464318,11464324,11479157,11513634,11513635,11513641,11513645,11513648,11513654,11556592,11556593,11556599,11556603,11556606,11556612,11600390,11600395,11600400,11600401,11600408,11600411,11649146,11649151,11649156,11649157,11649164,11649167,11666267,11667084,11667089,11667094,11667358,11668032,11668167,11671269,11671274,11671276,11671282,11671285,11671287,11711938,11711943,11711946,11739024,11739029,11739032,11739037,11739040,11739045,11757774,11757779,11757782,11786666,11786671,11786674,11786679,11786682,11786687,11805266,11805271,11805273,11836880,11836885,11836888,11836893,11836896,11836901,11852597,11853417,11853422,11853427,11854424,11854672,11855207,11868774,11868779,11868782,11868787,11868790,11868795,11923702,11923707,11923710,11923715,11923718,11923723,11940007,11963786,11963791,11963793,11963799,11963802,11963804,11980320,11980403,11980408,11980413,12003982,12003987,12003989,12003995,12003998,12004000,12045354,12045359,12045361,12045367,12045370,12045372,12061904,12061909,12061911,12084330,12084335,12084338,12084343,12084346,12084351,12101902,12101907,12101909,12102550,19849,19854,19857,19862,19865,19870,47379,71417,71422,71425,71430,71433,71438,85600,86408,86413,86418,111435,111440,111442,111448,111451,111453,127019,127024,127026,158141,158146,158149,158154,158157,158162,172817,173650,173651,173657,174569,192701,192706,192709,192714,192717,192722,210098,210900,210905,210910,232589,232594,232597,232602,232605,232610,247345,248128,248133,248138,249065,249210,249764,273185,273190,273193,273198,273201,273206,287999,288814,288819,288824,289784,290022,290579,312191,312196,312199,312204,312207,312212,356951,356956,356959,356964,356967,356972,372795,372800,372803,373737) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: