Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Сэйвы | Оц | Мин | Официальные матчи сборных | 12 | 0 | 1 | 0 | 77 | 0 | 0 | 59 | 6.88 | 1108 |
Национальная сборная | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Отборочный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 12 | 0 | 1 | 0 | 77 | 0 | 0 | 59 | 6.88 | 1108 |
Отборочный турнир | 9 | 0 | 1 | 0 | 57 | 0 | 0 | 45 | 7.06 | 830 |
Финальный турнир | 3 | 0 | 0 | 0 | 20 | 0 | 0 | 14 | 6.33 | 278 |
ТОВЫ сборных | 11 | 0 | 0 | 1 | 65 | 0 | 0 | 39 | 7.64 | 873 |
Всего за сборные | 23 | 0 | 1 | 1 | 142 | 0 | 0 | 98 | 7.24 | 1981 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Сэйвы | Оц | Мин |
(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) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 83433 WHERE `RP`.`player` = 83433 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125224,126325,128174,128993,130024,204157,206061,209436,209591,209682,280779,280781,280788,280791,280794,280800,338136,338142,338145,338150,338153,338155,10369070,10398211,10398216,10398219,10398224,10398227,10398232,10440276,10479125,10479130,10479133,10479138,10479141,10479146,10542443,10542448,10542451,10542456,10542459,10542464,10604629,10604631,10604638,10604641,10604644,10604650,10662831,10662833,10662840,10662843,10662846,10662852,10726461,10726463,10726470,10726473,10726476,10726482,10796630,10796636,10796639,10796644,10796647,10796649,10825112,10876268,10876274,10876277,10876282,10876285,10876287,10892867,10919905,10919907,10919914,10919917,10919920,10919926,10964195,10964197,10964204,10964207,10964210,10964216,10981497,11014943,11014948,11014950,11014956,11014959,11014961,11069607,11069612,11069614,11069620,11069623,11069625,11122157,11122162,11122164,11122170,11122173,11122175,11170671,11170676,11170678,11170684,11170687,11170689,11213773,11213778,11213780,11213786,11213789,11213791,11229115,11266477,11266482,11266484,11266490,11266493,11266495,11323357,11323362,11323364,11323370,11323373,11323375,11337856,11374931,11374936,11374939,11374944,11374947,11374952,11418545,11418550,11418552,11418558,11418561,11418563,11433515,11464759,11464764,11464766,11464772,11464775,11464777,11479167,11513945,11513950,11513952,11513958,11513961,11513963,11556856,11556857,11556863,11556867,11556870,11556876,11600752,11600753,11600759,11600763,11600766,11600772,11649505,11649510,11649513,11649518,11649521,11649526,11671555,11671560,11671563,11671568,11671571,11671576,11739290,11739295,11739297,11739303,11739306,11739308,11787005,11787006,11787012,11787016,11787019,11787025,11837145,11837150,11837155,11837156,11837163,11837166,11852586,11868849,11868850,11868856,11868860,11868863,11868869,11924064,11924069,11924071,11924077,11924080,11924082,11940014,11964050,11964055,11964057,11964063,11964066,11964068,12004220,12004225,12004228,12004233,12004236,12004241,12045424,12045429,12045432,12045437,12045440,12045445,12084666,12084671,12084674,12084679,12084682,12084687,12101115,20209,20214,20217,20222,20225,20230,71779,71784,71786,71792,71795,71797,111748,111749,111755,111759,111762,111768,158552,158553,158559,158563,158566,158572,192824,192825,192831,192835,192838,192844,232424,232425,232431,232435,232438,232444,273284,273285,273291,273295,273298,273304,312674,312675,312681,312685,312688,312694,357215,357220,357223,357228,357231,357236) ) 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) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 83433 WHERE `RP`.`player` = 83433 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125224,126325,128174,128993,130024,204157,206061,209436,209591,209682,280779,280781,280788,280791,280794,280800,338136,338142,338145,338150,338153,338155,10369070,10398211,10398216,10398219,10398224,10398227,10398232,10440276,10479125,10479130,10479133,10479138,10479141,10479146,10542443,10542448,10542451,10542456,10542459,10542464,10604629,10604631,10604638,10604641,10604644,10604650,10662831,10662833,10662840,10662843,10662846,10662852,10726461,10726463,10726470,10726473,10726476,10726482,10796630,10796636,10796639,10796644,10796647,10796649,10825112,10876268,10876274,10876277,10876282,10876285,10876287,10892867,10919905,10919907,10919914,10919917,10919920,10919926,10964195,10964197,10964204,10964207,10964210,10964216,10981497,11014943,11014948,11014950,11014956,11014959,11014961,11069607,11069612,11069614,11069620,11069623,11069625,11122157,11122162,11122164,11122170,11122173,11122175,11170671,11170676,11170678,11170684,11170687,11170689,11213773,11213778,11213780,11213786,11213789,11213791,11229115,11266477,11266482,11266484,11266490,11266493,11266495,11323357,11323362,11323364,11323370,11323373,11323375,11337856,11374931,11374936,11374939,11374944,11374947,11374952,11418545,11418550,11418552,11418558,11418561,11418563,11433515,11464759,11464764,11464766,11464772,11464775,11464777,11479167,11513945,11513950,11513952,11513958,11513961,11513963,11556856,11556857,11556863,11556867,11556870,11556876,11600752,11600753,11600759,11600763,11600766,11600772,11649505,11649510,11649513,11649518,11649521,11649526,11671555,11671560,11671563,11671568,11671571,11671576,11739290,11739295,11739297,11739303,11739306,11739308,11787005,11787006,11787012,11787016,11787019,11787025,11837145,11837150,11837155,11837156,11837163,11837166,11852586,11868849,11868850,11868856,11868860,11868863,11868869,11924064,11924069,11924071,11924077,11924080,11924082,11940014,11964050,11964055,11964057,11964063,11964066,11964068,12004220,12004225,12004228,12004233,12004236,12004241,12045424,12045429,12045432,12045437,12045440,12045445,12084666,12084671,12084674,12084679,12084682,12084687,12101115,20209,20214,20217,20222,20225,20230,71779,71784,71786,71792,71795,71797,111748,111749,111755,111759,111762,111768,158552,158553,158559,158563,158566,158572,192824,192825,192831,192835,192838,192844,232424,232425,232431,232435,232438,232444,273284,273285,273291,273295,273298,273304,312674,312675,312681,312685,312688,312694,357215,357220,357223,357228,357231,357236) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: