Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 1 | 0 | 0 | 13 | 36 | 1 | 7 | 0 | 7.00 | 93 |
Национальная сборная | 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 |
Молодежная сборная | 1 | 0 | 0 | 13 | 36 | 1 | 7 | 0 | 7.00 | 93 |
Отборочный турнир | 1 | 0 | 0 | 13 | 36 | 1 | 7 | 0 | 7.00 | 93 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
ТОВЫ сборных | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Всего за сборные | 1 | 0 | 0 | 13 | 36 | 1 | 7 | 0 | 7.00 | 93 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 77335 WHERE `RP`.`player` = 77335 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125224,126325,128174,128993,130024,204157,206061,209436,209591,209682,280779,280781,280788,280791,280794,280800,303576,303577,303583,303672,304768,305242,338136,338142,338145,338150,338153,338155,10369070,10370722,10370727,10370732,10371755,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,10758456,10758457,10758463,10760389,10796630,10796636,10796639,10796644,10796647,10796649,10825112,10826266,10826271,10826276,10876268,10876274,10876277,10876282,10876285,10876287,10892867,10919905,10919907,10919914,10919917,10919920,10919926,10964195,10964197,10964204,10964207,10964210,10964216,10981497,10982990,10982995,10983000,10983337,10984029,10985558,11014943,11014948,11014950,11014956,11014959,11014961,11038305,11038310,11038312,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,11229638,11229643,11229648,11266477,11266482,11266484,11266490,11266493,11266495,11286129,11286134,11286136,11323357,11323362,11323364,11323370,11323373,11323375,11337856,11339786,11339791,11339796,11340355,11374931,11374936,11374939,11374944,11374947,11374952,11418545,11418550,11418552,11418558,11418561,11418563,11433515,11434202,11434207,11434212,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,11618497,11618502,11618504,11649505,11649510,11649513,11649518,11649521,11649526,11667121,11667126,11667128,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,11896713,11896714,11896720,11924064,11924069,11924071,11924077,11924080,11924082,11940014,11964050,11964055,11964057,11964063,11964066,11964068,11980486,11980491,11980494,11981345,11981696,11982822,12004220,12004225,12004228,12004233,12004236,12004241,12045424,12045429,12045432,12045437,12045440,12045445,12061950,12061955,12061958,12062538,12062947,12063056,12084666,12084671,12084674,12084679,12084682,12084687,12101115,12101973,12101978,12101983,12102561,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,288876,288877,288883,312674,312675,312681,312685,312688,312694,333267,333272,333274,333575,334624,334999,357215,357220,357223,357228,357231,357236,372843,372848,372851,373747,374301,374533) ) 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` = 77335 WHERE `RP`.`player` = 77335 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125224,126325,128174,128993,130024,204157,206061,209436,209591,209682,280779,280781,280788,280791,280794,280800,303576,303577,303583,303672,304768,305242,338136,338142,338145,338150,338153,338155,10369070,10370722,10370727,10370732,10371755,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,10758456,10758457,10758463,10760389,10796630,10796636,10796639,10796644,10796647,10796649,10825112,10826266,10826271,10826276,10876268,10876274,10876277,10876282,10876285,10876287,10892867,10919905,10919907,10919914,10919917,10919920,10919926,10964195,10964197,10964204,10964207,10964210,10964216,10981497,10982990,10982995,10983000,10983337,10984029,10985558,11014943,11014948,11014950,11014956,11014959,11014961,11038305,11038310,11038312,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,11229638,11229643,11229648,11266477,11266482,11266484,11266490,11266493,11266495,11286129,11286134,11286136,11323357,11323362,11323364,11323370,11323373,11323375,11337856,11339786,11339791,11339796,11340355,11374931,11374936,11374939,11374944,11374947,11374952,11418545,11418550,11418552,11418558,11418561,11418563,11433515,11434202,11434207,11434212,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,11618497,11618502,11618504,11649505,11649510,11649513,11649518,11649521,11649526,11667121,11667126,11667128,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,11896713,11896714,11896720,11924064,11924069,11924071,11924077,11924080,11924082,11940014,11964050,11964055,11964057,11964063,11964066,11964068,11980486,11980491,11980494,11981345,11981696,11982822,12004220,12004225,12004228,12004233,12004236,12004241,12045424,12045429,12045432,12045437,12045440,12045445,12061950,12061955,12061958,12062538,12062947,12063056,12084666,12084671,12084674,12084679,12084682,12084687,12101115,12101973,12101978,12101983,12102561,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,288876,288877,288883,312674,312675,312681,312685,312688,312694,333267,333272,333274,333575,334624,334999,357215,357220,357223,357228,357231,357236,372843,372848,372851,373747,374301,374533) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: