Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 16 | 0 | 4 | 2 | 219 | 89 | 3 | 8 | 6.75 | 1214 |
Национальная сборная | 14 | 0 | 4 | 0 | 214 | 82 | 3 | 8 | 6.86 | 1089 |
Отборочный турнир | 10 | 0 | 4 | 0 | 159 | 59 | 3 | 7 | 6.80 | 720 |
Финальный турнир | 4 | 0 | 0 | 0 | 55 | 23 | 0 | 1 | 7.00 | 369 |
Молодежная сборная | 2 | 0 | 0 | 2 | 5 | 7 | 0 | 0 | 6.00 | 125 |
Отборочный турнир | 2 | 0 | 0 | 2 | 5 | 7 | 0 | 0 | 6.00 | 125 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
ТОВЫ сборных | 35 | 0 | 8 | 6 | 322 | 117 | 1 | 21 | 6.29 | 2602 |
Всего за сборные | 51 | 0 | 12 | 8 | 541 | 206 | 4 | 29 | 6.43 | 3816 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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(139, 208) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 49069 WHERE `RP`.`player` = 49069 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125231,126333,128182,129001,130028,204162,206069,209444,209599,209686,246950,246955,246960,280970,280976,280979,280984,280987,280989,303575,303580,303582,303669,304769,305241,338231,338236,338239,338244,338247,338252,10398163,10398168,10398171,10398176,10398179,10398184,10479222,10479228,10479231,10479236,10479239,10479241,10513331,10513336,10513338,10542444,10542450,10542453,10542458,10542461,10542463,10569127,10569132,10569134,10570043,10604627,10604632,10604635,10604640,10604643,10604648,10639571,10639576,10639579,10640811,10640943,10641038,10662949,10662954,10662957,10662962,10662965,10662970,10726411,10726416,10726419,10726424,10726427,10726432,10796701,10796706,10796709,10796714,10796717,10796722,10876460,10876466,10876469,10876474,10876477,10876479,10892862,10919881,10919883,10919890,10919893,10919896,10919902,10964292,10964295,10964298,10964301,10964308,10964311,11014726,11014731,11014736,11014737,11014744,11014747,11038269,11038274,11038276,11069535,11069540,11069542,11069548,11069551,11069553,11085725,11085730,11085732,11122109,11122114,11122116,11122122,11122125,11122127,11170527,11170532,11170534,11170540,11170543,11170545,11186673,11186678,11186680,11213917,11213922,11213924,11213930,11213933,11213935,11266670,11266671,11266677,11266681,11266684,11266690,11286117,11286122,11286124,11286604,11323307,11323312,11323315,11323320,11323323,11323328,11374862,11374863,11374869,11374873,11374876,11374882,11418712,11418717,11418722,11418723,11418730,11418733,11464758,11464763,11464768,11464769,11464776,11464779,11513752,11513757,11513762,11513763,11513770,11513773,11556854,11556859,11556864,11556865,11556872,11556875,11600678,11600683,11600688,11600689,11600696,11600699,11649578,11649583,11649588,11649589,11649596,11649599,11671652,11671657,11671662,11671663,11671670,11671673,11739337,11739342,11739347,11739348,11739355,11739358,11787027,11787032,11787037,11787038,11787045,11787048,11837073,11837078,11837083,11837084,11837091,11837094,11868991,11868996,11869001,11869002,11869009,11869012,11895846,11924065,11924066,11924072,11924076,11924079,11924085,11964147,11964148,11964154,11964158,11964161,11964167,12004317,12004322,12004327,12004328,12004335,12004338,12045497,12045502,12045507,12045508,12045515,12045518,12084787,12084792,12084797,12084798,12084805,12084808,20114,20119,20124,20125,20132,20135,47382,71804,71805,71811,71815,71818,71824,111676,111677,111683,111687,111690,111696,158406,158411,158416,158417,158424,158427,192776,192777,192783,192787,192790,192796,210950,210951,210957,232351,232356,232358,232364,232367,232369,273283,273288,273290,273296,273299,273301,312650,312651,312657,312661,312664,312670,357434,357435,357441,357445,357448,357454,371997,372820,372825,372830) ) 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(139, 208) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 49069 WHERE `RP`.`player` = 49069 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125231,126333,128182,129001,130028,204162,206069,209444,209599,209686,246950,246955,246960,280970,280976,280979,280984,280987,280989,303575,303580,303582,303669,304769,305241,338231,338236,338239,338244,338247,338252,10398163,10398168,10398171,10398176,10398179,10398184,10479222,10479228,10479231,10479236,10479239,10479241,10513331,10513336,10513338,10542444,10542450,10542453,10542458,10542461,10542463,10569127,10569132,10569134,10570043,10604627,10604632,10604635,10604640,10604643,10604648,10639571,10639576,10639579,10640811,10640943,10641038,10662949,10662954,10662957,10662962,10662965,10662970,10726411,10726416,10726419,10726424,10726427,10726432,10796701,10796706,10796709,10796714,10796717,10796722,10876460,10876466,10876469,10876474,10876477,10876479,10892862,10919881,10919883,10919890,10919893,10919896,10919902,10964292,10964295,10964298,10964301,10964308,10964311,11014726,11014731,11014736,11014737,11014744,11014747,11038269,11038274,11038276,11069535,11069540,11069542,11069548,11069551,11069553,11085725,11085730,11085732,11122109,11122114,11122116,11122122,11122125,11122127,11170527,11170532,11170534,11170540,11170543,11170545,11186673,11186678,11186680,11213917,11213922,11213924,11213930,11213933,11213935,11266670,11266671,11266677,11266681,11266684,11266690,11286117,11286122,11286124,11286604,11323307,11323312,11323315,11323320,11323323,11323328,11374862,11374863,11374869,11374873,11374876,11374882,11418712,11418717,11418722,11418723,11418730,11418733,11464758,11464763,11464768,11464769,11464776,11464779,11513752,11513757,11513762,11513763,11513770,11513773,11556854,11556859,11556864,11556865,11556872,11556875,11600678,11600683,11600688,11600689,11600696,11600699,11649578,11649583,11649588,11649589,11649596,11649599,11671652,11671657,11671662,11671663,11671670,11671673,11739337,11739342,11739347,11739348,11739355,11739358,11787027,11787032,11787037,11787038,11787045,11787048,11837073,11837078,11837083,11837084,11837091,11837094,11868991,11868996,11869001,11869002,11869009,11869012,11895846,11924065,11924066,11924072,11924076,11924079,11924085,11964147,11964148,11964154,11964158,11964161,11964167,12004317,12004322,12004327,12004328,12004335,12004338,12045497,12045502,12045507,12045508,12045515,12045518,12084787,12084792,12084797,12084798,12084805,12084808,20114,20119,20124,20125,20132,20135,47382,71804,71805,71811,71815,71818,71824,111676,111677,111683,111687,111690,111696,158406,158411,158416,158417,158424,158427,192776,192777,192783,192787,192790,192796,210950,210951,210957,232351,232356,232358,232364,232367,232369,273283,273288,273290,273296,273299,273301,312650,312651,312657,312661,312664,312670,357434,357435,357441,357445,357448,357454,371997,372820,372825,372830) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: