Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 23 | 0 | 0 | 152 | 232 | 5 | 41 | 4 | 6.96 | 2051 |
Национальная сборная | 10 | 0 | 0 | 70 | 105 | 4 | 16 | 1 | 6.70 | 832 |
Отборочный турнир | 10 | 0 | 0 | 70 | 105 | 4 | 16 | 1 | 6.70 | 832 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 13 | 0 | 0 | 82 | 127 | 1 | 25 | 3 | 7.15 | 1219 |
Отборочный турнир | 10 | 0 | 0 | 67 | 98 | 1 | 20 | 3 | 7.40 | 942 |
Финальный турнир | 3 | 0 | 0 | 15 | 29 | 0 | 5 | 0 | 6.33 | 277 |
ТОВЫ сборных | 38 | 1 | 0 | 265 | 454 | 7 | 39 | 6 | 7.17 | 3000 |
Всего за сборные | 61 | 1 | 0 | 417 | 686 | 12 | 80 | 10 | 7.09 | 5051 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 73191 WHERE `RP`.`player` = 73191 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125195,126380,129053,130300,130665,131998,204124,206118,209568,209651,210923,209740,280513,280518,280521,280526,280529,280534,301758,338543,338548,338551,338556,338559,338564,10398456,10398462,10398465,10398470,10398473,10398475,10479247,10479249,10479256,10479259,10479262,10479268,10512413,10542014,10542017,10542020,10542023,10542030,10542033,10604774,10604777,10604780,10604783,10604790,10604793,10663048,10663051,10663054,10663057,10663064,10663067,10726198,10726201,10726204,10726207,10726214,10726217,10796919,10796921,10796928,10796931,10796934,10796940,10825104,10876725,10876727,10876734,10876737,10876740,10876746,10919641,10919643,10919650,10919653,10919656,10919662,10964557,10964559,10964566,10964569,10964572,10964578,11015014,11015019,11015024,11015025,11015032,11015035,11069344,11069345,11069351,11069355,11069358,11069364,11084874,11122422,11122423,11122429,11122433,11122436,11122442,11139727,11170360,11170361,11170367,11170371,11170374,11170380,11214084,11214089,11214094,11214095,11214102,11214105,11266909,11266914,11266916,11266922,11266925,11266927,11323092,11323097,11323102,11323103,11323110,11323113,11374643,11374648,11374651,11374656,11374659,11374664,11418329,11418334,11418336,11418342,11418345,11418347,11464423,11464428,11464430,11464436,11464439,11464441,11479154,11513729,11513734,11513736,11513742,11513745,11513747,11556541,11556546,11556549,11556554,11556557,11556562,11600415,11600420,11600422,11600428,11600431,11600433,11616919,11649361,11649366,11649369,11649374,11649377,11649382,11666265,11671411,11671416,11671419,11671424,11671427,11671432,11738882,11738887,11738889,11738895,11738898,11738900,11786740,11786745,11786747,11786753,11786756,11786758,11805213,11836882,11836887,11836889,11836895,11836898,11836900,11868752,11868757,11868759,11868765,11868768,11868770,11923800,11923805,11923807,11923813,11923816,11923818,11963858,11963863,11963865,11963871,11963874,11963876,12004007,12004008,12004014,12004018,12004021,12004027,12045185,12045190,12045195,12045196,12045203,12045206,12061175,12084501,12084502,12084508,12084512,12084515,12084521,19898,19903,19908,19909,19916,19919,71468,71469,71475,71479,71482,71488,111460,111461,111467,111471,111474,111480,158120,158121,158127,158131,158134,158140,192656,192657,192663,192667,192670,192676,210097,232544,232545,232551,232555,232558,232564,272970,272975,272980,272981,272988,272991,312384,312389,312394,312395,312402,312405,356928,356933,356938,356939,356946,356949) ) 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` = 73191 WHERE `RP`.`player` = 73191 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125195,126380,129053,130300,130665,131998,204124,206118,209568,209651,210923,209740,280513,280518,280521,280526,280529,280534,301758,338543,338548,338551,338556,338559,338564,10398456,10398462,10398465,10398470,10398473,10398475,10479247,10479249,10479256,10479259,10479262,10479268,10512413,10542014,10542017,10542020,10542023,10542030,10542033,10604774,10604777,10604780,10604783,10604790,10604793,10663048,10663051,10663054,10663057,10663064,10663067,10726198,10726201,10726204,10726207,10726214,10726217,10796919,10796921,10796928,10796931,10796934,10796940,10825104,10876725,10876727,10876734,10876737,10876740,10876746,10919641,10919643,10919650,10919653,10919656,10919662,10964557,10964559,10964566,10964569,10964572,10964578,11015014,11015019,11015024,11015025,11015032,11015035,11069344,11069345,11069351,11069355,11069358,11069364,11084874,11122422,11122423,11122429,11122433,11122436,11122442,11139727,11170360,11170361,11170367,11170371,11170374,11170380,11214084,11214089,11214094,11214095,11214102,11214105,11266909,11266914,11266916,11266922,11266925,11266927,11323092,11323097,11323102,11323103,11323110,11323113,11374643,11374648,11374651,11374656,11374659,11374664,11418329,11418334,11418336,11418342,11418345,11418347,11464423,11464428,11464430,11464436,11464439,11464441,11479154,11513729,11513734,11513736,11513742,11513745,11513747,11556541,11556546,11556549,11556554,11556557,11556562,11600415,11600420,11600422,11600428,11600431,11600433,11616919,11649361,11649366,11649369,11649374,11649377,11649382,11666265,11671411,11671416,11671419,11671424,11671427,11671432,11738882,11738887,11738889,11738895,11738898,11738900,11786740,11786745,11786747,11786753,11786756,11786758,11805213,11836882,11836887,11836889,11836895,11836898,11836900,11868752,11868757,11868759,11868765,11868768,11868770,11923800,11923805,11923807,11923813,11923816,11923818,11963858,11963863,11963865,11963871,11963874,11963876,12004007,12004008,12004014,12004018,12004021,12004027,12045185,12045190,12045195,12045196,12045203,12045206,12061175,12084501,12084502,12084508,12084512,12084515,12084521,19898,19903,19908,19909,19916,19919,71468,71469,71475,71479,71482,71488,111460,111461,111467,111471,111474,111480,158120,158121,158127,158131,158134,158140,192656,192657,192663,192667,192670,192676,210097,232544,232545,232551,232555,232558,232564,272970,272975,272980,272981,272988,272991,312384,312389,312394,312395,312402,312405,356928,356933,356938,356939,356946,356949) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: