Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 10 | 7 | 0 | 1 | 63 | 18 | 0 | 12 | 6.75 | 455 |
Национальная сборная | 1 | 0 | 0 | 0 | 9 | 1 | 0 | 0 | 5.00 | 29 |
Отборочный турнир | 1 | 0 | 0 | 0 | 9 | 1 | 0 | 0 | 5.00 | 29 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 9 | 7 | 0 | 1 | 54 | 17 | 0 | 12 | 6.94 | 426 |
Отборочный турнир | 9 | 7 | 0 | 1 | 54 | 17 | 0 | 12 | 6.94 | 426 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
ТОВЫ сборных | 16 | 7 | 0 | 3 | 133 | 27 | 0 | 15 | 6.50 | 1029 |
Всего за сборные | 26 | 14 | 0 | 4 | 196 | 45 | 0 | 27 | 6.60 | 1484 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 75608 WHERE `RP`.`player` = 75608 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,10893698,10893703,10893708,10894000,10894521,10895372,10919568,10919574,10919577,10919582,10919585,10919587,10964533,10964535,10964542,10964545,10964548,10964554,11015112,11015113,11015119,11015123,11015126,11015132,11038330,11038331,11038337,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,11339774,11339779,11339784,11340350,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,11574728,11574733,11574738,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,11757789,11757790,11757796,11758744,11786762,11786767,11786770,11786775,11786778,11786783,11836808,11836813,11836816,11836821,11836824,11836829,11853418,11853423,11853425,11868584,11868589,11868591,11868597,11868600,11868602,11895841,11923825,11923826,11923832,11923836,11923839,11923845,11963739,11963740,11963746,11963750,11963753,11963759,11980441,11980442,11980448,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,127020,127021,127027,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, 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` = 75608 WHERE `RP`.`player` = 75608 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,10893698,10893703,10893708,10894000,10894521,10895372,10919568,10919574,10919577,10919582,10919585,10919587,10964533,10964535,10964542,10964545,10964548,10964554,11015112,11015113,11015119,11015123,11015126,11015132,11038330,11038331,11038337,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,11339774,11339779,11339784,11340350,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,11574728,11574733,11574738,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,11757789,11757790,11757796,11758744,11786762,11786767,11786770,11786775,11786778,11786783,11836808,11836813,11836816,11836821,11836824,11836829,11853418,11853423,11853425,11868584,11868589,11868591,11868597,11868600,11868602,11895841,11923825,11923826,11923832,11923836,11923839,11923845,11963739,11963740,11963746,11963750,11963753,11963759,11980441,11980442,11980448,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,127020,127021,127027,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}: