Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Сэйвы | Оц | Мин | Официальные матчи сборных | 1 | 0 | 1 | 0 | 8 | 0 | 0 | 2 | 6.00 | 91 |
Национальная сборная | 1 | 0 | 1 | 0 | 8 | 0 | 0 | 2 | 6.00 | 91 |
Отборочный турнир | 1 | 0 | 1 | 0 | 8 | 0 | 0 | 2 | 6.00 | 91 |
Финальный турнир | 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 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
ТОВЫ сборных | 4 | 0 | 0 | 1 | 21 | 0 | 0 | 11 | 6.12 | 319 |
Всего за сборные | 5 | 0 | 1 | 1 | 29 | 0 | 0 | 13 | 6.10 | 410 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Сэйвы | Оц | Мин |
(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` = 63899 WHERE `RP`.`player` = 63899 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125188,126379,128140,129044,130293,204119,206115,209402,209644,209731,246878,246883,246888,250352,280659,280661,280668,280671,280674,280680,338474,338477,338480,338483,338490,338493,10369075,10398506,10398509,10398512,10398515,10398522,10398525,10441236,10441237,10441243,10442085,10442246,10443321,10479246,10479252,10479255,10479260,10479263,10479265,10513283,10513288,10513290,10514087,10514362,10514499,10542083,10542088,10542091,10542096,10542099,10542104,10567354,10569198,10569203,10569208,10570035,10570141,10570554,10604723,10604728,10604731,10604736,10604739,10604744,10663069,10663074,10663077,10663082,10663085,10663090,10726316,10726322,10726325,10726330,10726333,10726335,10757376,10796990,10796996,10796999,10797004,10797007,10797009,10825100,10876556,10876562,10876565,10876570,10876573,10876575,10919713,10919715,10919722,10919725,10919728,10919734,10964485,10964487,10964494,10964497,10964500,10964506,10982943,10982948,10982950,11015039,11015044,11015046,11015052,11015055,11015057,11069295,11069300,11069302,11069308,11069311,11069313,11122277,11122282,11122284,11122290,11122293,11122295,11170311,11170316,11170318,11170324,11170327,11170329,11186277,11186636,11186641,11186646,11214133,11214138,11214140,11214146,11214149,11214151,11229603,11229608,11229610,11230827,11231871,11232730,11266979,11266984,11266987,11266992,11266995,11267000,11323115,11323120,11323123,11323128,11323131,11323136,11339751,11339756,11339758,11340351,11340452,11341832,11374619,11374624,11374627,11374632,11374635,11374640,11392933,11392938,11392940,11394292,11418375,11418380,11418383,11418388,11418391,11418396,11434153,11434158,11434161,11435328,11464397,11464402,11464405,11464410,11464413,11464418,11479159,11481176,11481177,11481183,11481631,11481768,11481866,11513655,11513660,11513663,11513668,11513671,11513676,11531551,11531556,11531559,11556733,11556738,11556741,11556746,11556749,11556754,11574741,11574746,11574748,11600317,11600322,11600325,11600330,11600333,11600338,11618473,11618478,11618480,11649265,11649270,11649273,11649278,11649281,11649286,11666261,11671387,11671392,11671395,11671400,11671403,11671408,11739050,11739055,11739057,11739063,11739066,11739068,11756950,11786668,11786673,11786675,11786681,11786684,11786686,11836786,11836791,11836793,11836799,11836802,11836804,11853430,11853435,11853437,11854425,11868630,11868635,11868638,11868643,11868646,11868651,11895839,11923704,11923709,11923711,11923717,11923720,11923722,11940878,11940883,11940885,11942511,11942650,11942744,11963906,11963911,11963913,11963919,11963922,11963924,11980440,11980445,11980447,12003908,12003913,12003916,12003921,12003924,12003929,12045211,12045212,12045218,12045222,12045225,12045231,12061916,12061921,12061923,12084404,12084409,12084411,12084417,12084420,12084422,12101110,12101927,12101928,12101934,20091,20096,20098,20104,20107,20109,71443,71448,71450,71456,71459,71461,85601,111433,111438,111441,111446,111449,111454,126193,158333,158338,158341,158346,158349,158354,192584,192585,192591,192595,192598,192604,210099,210912,210917,210922,212520,232519,232524,232526,232532,232535,232537,248117,248122,248124,249068,273065,273070,273073,273078,273081,273086,288825,288830,288833,289785,290021,290577,312431,312436,312439,312444,312447,312452,333241,333246,333249,333569,334619,334995,357143,357148,357151,357156,357159,357164,372771,372776,372779,373742,374295,374530) ) 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` = 63899 WHERE `RP`.`player` = 63899 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125188,126379,128140,129044,130293,204119,206115,209402,209644,209731,246878,246883,246888,250352,280659,280661,280668,280671,280674,280680,338474,338477,338480,338483,338490,338493,10369075,10398506,10398509,10398512,10398515,10398522,10398525,10441236,10441237,10441243,10442085,10442246,10443321,10479246,10479252,10479255,10479260,10479263,10479265,10513283,10513288,10513290,10514087,10514362,10514499,10542083,10542088,10542091,10542096,10542099,10542104,10567354,10569198,10569203,10569208,10570035,10570141,10570554,10604723,10604728,10604731,10604736,10604739,10604744,10663069,10663074,10663077,10663082,10663085,10663090,10726316,10726322,10726325,10726330,10726333,10726335,10757376,10796990,10796996,10796999,10797004,10797007,10797009,10825100,10876556,10876562,10876565,10876570,10876573,10876575,10919713,10919715,10919722,10919725,10919728,10919734,10964485,10964487,10964494,10964497,10964500,10964506,10982943,10982948,10982950,11015039,11015044,11015046,11015052,11015055,11015057,11069295,11069300,11069302,11069308,11069311,11069313,11122277,11122282,11122284,11122290,11122293,11122295,11170311,11170316,11170318,11170324,11170327,11170329,11186277,11186636,11186641,11186646,11214133,11214138,11214140,11214146,11214149,11214151,11229603,11229608,11229610,11230827,11231871,11232730,11266979,11266984,11266987,11266992,11266995,11267000,11323115,11323120,11323123,11323128,11323131,11323136,11339751,11339756,11339758,11340351,11340452,11341832,11374619,11374624,11374627,11374632,11374635,11374640,11392933,11392938,11392940,11394292,11418375,11418380,11418383,11418388,11418391,11418396,11434153,11434158,11434161,11435328,11464397,11464402,11464405,11464410,11464413,11464418,11479159,11481176,11481177,11481183,11481631,11481768,11481866,11513655,11513660,11513663,11513668,11513671,11513676,11531551,11531556,11531559,11556733,11556738,11556741,11556746,11556749,11556754,11574741,11574746,11574748,11600317,11600322,11600325,11600330,11600333,11600338,11618473,11618478,11618480,11649265,11649270,11649273,11649278,11649281,11649286,11666261,11671387,11671392,11671395,11671400,11671403,11671408,11739050,11739055,11739057,11739063,11739066,11739068,11756950,11786668,11786673,11786675,11786681,11786684,11786686,11836786,11836791,11836793,11836799,11836802,11836804,11853430,11853435,11853437,11854425,11868630,11868635,11868638,11868643,11868646,11868651,11895839,11923704,11923709,11923711,11923717,11923720,11923722,11940878,11940883,11940885,11942511,11942650,11942744,11963906,11963911,11963913,11963919,11963922,11963924,11980440,11980445,11980447,12003908,12003913,12003916,12003921,12003924,12003929,12045211,12045212,12045218,12045222,12045225,12045231,12061916,12061921,12061923,12084404,12084409,12084411,12084417,12084420,12084422,12101110,12101927,12101928,12101934,20091,20096,20098,20104,20107,20109,71443,71448,71450,71456,71459,71461,85601,111433,111438,111441,111446,111449,111454,126193,158333,158338,158341,158346,158349,158354,192584,192585,192591,192595,192598,192604,210099,210912,210917,210922,212520,232519,232524,232526,232532,232535,232537,248117,248122,248124,249068,273065,273070,273073,273078,273081,273086,288825,288830,288833,289785,290021,290577,312431,312436,312439,312444,312447,312452,333241,333246,333249,333569,334619,334995,357143,357148,357151,357156,357159,357164,372771,372776,372779,373742,374295,374530) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: