Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 17 | 0 | 0 | 96 | 269 | 2 | 44 | 0 | 7.50 | 1549 |
Национальная сборная | 10 | 0 | 0 | 72 | 170 | 2 | 15 | 0 | 7.65 | 911 |
Отборочный турнир | 7 | 0 | 0 | 54 | 106 | 2 | 10 | 0 | 7.86 | 631 |
Финальный турнир | 3 | 0 | 0 | 18 | 64 | 0 | 5 | 0 | 7.17 | 280 |
Молодежная сборная | 7 | 0 | 0 | 24 | 99 | 0 | 29 | 0 | 7.29 | 638 |
Отборочный турнир | 4 | 0 | 0 | 15 | 50 | 0 | 15 | 0 | 7.38 | 364 |
Финальный турнир | 3 | 0 | 0 | 9 | 49 | 0 | 14 | 0 | 7.17 | 274 |
ТОВЫ сборных | 43 | 0 | 0 | 198 | 552 | 5 | 110 | 0 | 7.69 | 3356 |
Всего за сборные | 60 | 0 | 0 | 294 | 821 | 7 | 154 | 0 | 7.63 | 4905 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 46083 WHERE `RP`.`player` = 46083 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125190,126376,128141,129042,130295,204121,206114,209401,209642,209733,280492,280495,280498,280501,280508,280511,338617,338619,338626,338629,338632,338638,10398505,10398507,10398514,10398517,10398520,10398526,10479487,10479489,10479496,10479499,10479502,10479508,10542038,10542041,10542044,10542047,10542054,10542057,10604846,10604849,10604852,10604855,10604862,10604865,10663168,10663171,10663174,10663177,10663184,10663187,10726366,10726369,10726372,10726375,10726382,10726385,10796872,10796875,10796878,10796881,10796888,10796891,10825103,10876558,10876561,10876564,10876567,10876574,10876577,10892854,10919568,10919574,10919577,10919582,10919585,10919587,10964533,10964535,10964542,10964545,10964548,10964554,11015112,11015113,11015119,11015123,11015126,11015132,11069415,11069420,11069422,11069428,11069431,11069433,11122302,11122303,11122309,11122313,11122316,11122322,11170431,11170436,11170438,11170444,11170447,11170449,11214062,11214063,11214069,11214073,11214076,11214082,11266838,11266839,11266845,11266849,11266852,11266858,11284031,11322974,11322975,11322981,11322985,11322988,11322994,11337860,11374621,11374626,11374628,11374634,11374637,11374639,11418354,11418355,11418361,11418365,11418368,11418374,11464328,11464329,11464335,11464339,11464342,11464348,11513682,11513683,11513689,11513693,11513696,11513702,11556544,11556545,11556551,11556555,11556558,11556564,11573280,11600367,11600372,11600374,11600380,11600383,11600385,11649243,11649248,11649250,11649256,11649259,11649261,11666264,11671365,11671370,11671372,11671378,11671381,11671383,11739051,11739052,11739058,11739062,11739065,11739071,11786762,11786767,11786770,11786775,11786778,11786783,11836808,11836813,11836816,11836821,11836824,11836829,11868584,11868589,11868591,11868597,11868600,11868602,11895841,11923825,11923826,11923832,11923836,11923839,11923845,11963739,11963740,11963746,11963750,11963753,11963759,12004031,12004032,12004038,12004042,12004045,12004051,12045353,12045358,12045363,12045364,12045371,12045374,12084403,12084408,12084413,12084414,12084421,12084424,20018,20023,20028,20029,20036,20039,71564,71565,71571,71575,71578,71584,85594,111652,111653,111659,111663,111666,111672,158143,158148,158150,158156,158159,158161,192536,192537,192543,192547,192550,192556,232470,232475,232480,232481,232488,232491,273066,273071,273076,273077,273084,273087,312312,312317,312322,312323,312330,312333,331797,357000,357005,357010,357011,357018,357021) ) 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` = 46083 WHERE `RP`.`player` = 46083 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125190,126376,128141,129042,130295,204121,206114,209401,209642,209733,280492,280495,280498,280501,280508,280511,338617,338619,338626,338629,338632,338638,10398505,10398507,10398514,10398517,10398520,10398526,10479487,10479489,10479496,10479499,10479502,10479508,10542038,10542041,10542044,10542047,10542054,10542057,10604846,10604849,10604852,10604855,10604862,10604865,10663168,10663171,10663174,10663177,10663184,10663187,10726366,10726369,10726372,10726375,10726382,10726385,10796872,10796875,10796878,10796881,10796888,10796891,10825103,10876558,10876561,10876564,10876567,10876574,10876577,10892854,10919568,10919574,10919577,10919582,10919585,10919587,10964533,10964535,10964542,10964545,10964548,10964554,11015112,11015113,11015119,11015123,11015126,11015132,11069415,11069420,11069422,11069428,11069431,11069433,11122302,11122303,11122309,11122313,11122316,11122322,11170431,11170436,11170438,11170444,11170447,11170449,11214062,11214063,11214069,11214073,11214076,11214082,11266838,11266839,11266845,11266849,11266852,11266858,11284031,11322974,11322975,11322981,11322985,11322988,11322994,11337860,11374621,11374626,11374628,11374634,11374637,11374639,11418354,11418355,11418361,11418365,11418368,11418374,11464328,11464329,11464335,11464339,11464342,11464348,11513682,11513683,11513689,11513693,11513696,11513702,11556544,11556545,11556551,11556555,11556558,11556564,11573280,11600367,11600372,11600374,11600380,11600383,11600385,11649243,11649248,11649250,11649256,11649259,11649261,11666264,11671365,11671370,11671372,11671378,11671381,11671383,11739051,11739052,11739058,11739062,11739065,11739071,11786762,11786767,11786770,11786775,11786778,11786783,11836808,11836813,11836816,11836821,11836824,11836829,11868584,11868589,11868591,11868597,11868600,11868602,11895841,11923825,11923826,11923832,11923836,11923839,11923845,11963739,11963740,11963746,11963750,11963753,11963759,12004031,12004032,12004038,12004042,12004045,12004051,12045353,12045358,12045363,12045364,12045371,12045374,12084403,12084408,12084413,12084414,12084421,12084424,20018,20023,20028,20029,20036,20039,71564,71565,71571,71575,71578,71584,85594,111652,111653,111659,111663,111666,111672,158143,158148,158150,158156,158159,158161,192536,192537,192543,192547,192550,192556,232470,232475,232480,232481,232488,232491,273066,273071,273076,273077,273084,273087,312312,312317,312322,312323,312330,312333,331797,357000,357005,357010,357011,357018,357021) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: