Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 36 | 2 | 9 | 19 | 390 | 34 | 32 | 11 | 6.74 | 1382 |
Национальная сборная | 28 | 2 | 9 | 2 | 323 | 25 | 6 | 11 | 6.96 | 1382 |
Отборочный турнир | 21 | 2 | 3 | 1 | 238 | 19 | 5 | 10 | 6.81 | 877 |
Финальный турнир | 7 | 0 | 6 | 1 | 85 | 6 | 1 | 1 | 7.43 | 505 |
Молодежная сборная | 8 | 0 | 0 | 17 | 67 | 9 | 26 | 0 | 5.94 | 0 |
Отборочный турнир | 6 | 0 | 0 | 15 | 61 | 7 | 23 | 0 | 5.92 | 0 |
Финальный турнир | 2 | 0 | 0 | 2 | 6 | 2 | 3 | 0 | 6.00 | 0 |
ТОВЫ сборных | 29 | 0 | 6 | 14 | 319 | 36 | 10 | 2 | 6.58 | 761 |
Всего за сборные | 65 | 2 | 15 | 33 | 709 | 70 | 42 | 13 | 6.66 | 2143 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 24312 WHERE `RP`.`player` = 24312 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,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,11069464,11069465,11069471,11069475,11069478,11069484,11122374,11122375,11122381,11122385,11122388,11122394,11170430,11170435,11170440,11170441,11170448,11170451,11186272,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,11671269,11671274,11671276,11671282,11671285,11671287,11739024,11739029,11739032,11739037,11739040,11739045,11786666,11786671,11786674,11786679,11786682,11786687,11836880,11836885,11836888,11836893,11836896,11836901,11852597,11868774,11868779,11868782,11868787,11868790,11868795,11923702,11923707,11923710,11923715,11923718,11923723,11940007,11963786,11963791,11963793,11963799,11963802,11963804,11980320,12003982,12003987,12003989,12003995,12003998,12004000,12045354,12045359,12045361,12045367,12045370,12045372,12084330,12084335,12084338,12084343,12084346,12084351,19849,19854,19857,19862,19865,19870,47379,71417,71422,71425,71430,71433,71438,85600,111435,111440,111442,111448,111451,111453,158141,158146,158149,158154,158157,158162,172817,192701,192706,192709,192714,192717,192722,210098,232589,232594,232597,232602,232605,232610,247345,273185,273190,273193,273198,273201,273206,287999,312191,312196,312199,312204,312207,312212,356951,356956,356959,356964,356967,356972) ) 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` = 24312 WHERE `RP`.`player` = 24312 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,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,11069464,11069465,11069471,11069475,11069478,11069484,11122374,11122375,11122381,11122385,11122388,11122394,11170430,11170435,11170440,11170441,11170448,11170451,11186272,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,11671269,11671274,11671276,11671282,11671285,11671287,11739024,11739029,11739032,11739037,11739040,11739045,11786666,11786671,11786674,11786679,11786682,11786687,11836880,11836885,11836888,11836893,11836896,11836901,11852597,11868774,11868779,11868782,11868787,11868790,11868795,11923702,11923707,11923710,11923715,11923718,11923723,11940007,11963786,11963791,11963793,11963799,11963802,11963804,11980320,12003982,12003987,12003989,12003995,12003998,12004000,12045354,12045359,12045361,12045367,12045370,12045372,12084330,12084335,12084338,12084343,12084346,12084351,19849,19854,19857,19862,19865,19870,47379,71417,71422,71425,71430,71433,71438,85600,111435,111440,111442,111448,111451,111453,158141,158146,158149,158154,158157,158162,172817,192701,192706,192709,192714,192717,192722,210098,232589,232594,232597,232602,232605,232610,247345,273185,273190,273193,273198,273201,273206,287999,312191,312196,312199,312204,312207,312212,356951,356956,356959,356964,356967,356972) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: