Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 2 | 0 | 0 | 4 | 37 | 4 | 2 | 0 | 5.50 | 151 |
Национальная сборная | 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 |
Молодежная сборная | 2 | 0 | 0 | 4 | 37 | 4 | 2 | 0 | 5.50 | 151 |
Отборочный турнир | 2 | 0 | 0 | 4 | 37 | 4 | 2 | 0 | 5.50 | 151 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
ТОВЫ сборных | 6 | 0 | 1 | 6 | 79 | 20 | 1 | 0 | 6.17 | 294 |
Всего за сборные | 8 | 0 | 1 | 10 | 116 | 24 | 3 | 0 | 6.00 | 445 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 52032 WHERE `RP`.`player` = 52032 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125248,126347,129017,130046,204181,206083,209615,209704,280921,280926,280929,280934,280937,280942,338088,338094,338097,338102,338105,338107,10398235,10398240,10398243,10398248,10398251,10398256,10479006,10479012,10479015,10479020,10479023,10479025,10542299,10542304,10542307,10542312,10542315,10542320,10567343,10604555,10604560,10604563,10604568,10604571,10604576,10662951,10662953,10662960,10662963,10662966,10662972,10726603,10726608,10726611,10726616,10726619,10726624,10796605,10796610,10796613,10796618,10796621,10796626,10825107,10876387,10876392,10876395,10876400,10876403,10876408,10919832,10919838,10919841,10919846,10919849,10919851,10936974,10964315,10964317,10964324,10964327,10964330,10964336,10981501,11014920,11014921,11014927,11014931,11014934,11014940,11069606,11069611,11069616,11069617,11069624,11069627,11084879,11122110,11122111,11122117,11122121,11122124,11122130,11170525,11170530,11170533,11170538,11170541,11170546,11213771,11213776,11213779,11213784,11213787,11213792,11266573,11266578,11266580,11266586,11266589,11266591,11323283,11323288,11323291,11323296,11323299,11323304,11374981,11374986,11374988,11374994,11374997,11374999,11418546,11418547,11418553,11418557,11418560,11418566,11464734,11464739,11464744,11464745,11464752,11464755,11513992,11513997,11514002,11514003,11514010,11514013,11556830,11556835,11556840,11556841,11556848,11556851,11600534,11600539,11600544,11600545,11600552,11600555,11649458,11649463,11649468,11649469,11649476,11649479,11671532,11671537,11671542,11671543,11671550,11671553,11711139,11739315,11739316,11739322,11739326,11739329,11739335,11786932,11786937,11786939,11786945,11786948,11786950,11837074,11837079,11837081,11837087,11837090,11837092,11868825,11868826,11868832,11868836,11868839,11868845,11923991,11923996,11924001,11924002,11924009,11924012,11964049,11964054,11964059,11964060,11964067,11964070,12004271,12004272,12004278,12004282,12004285,12004291,12021343,12045619,12045620,12045626,12045630,12045633,12045639,12061187,12084645,12084646,12084652,12084656,12084659,12084665,20354,20359,20364,20365,20372,20375,71706,71711,71716,71717,71724,71727,85605,111867,111872,111874,111880,111883,111885,158502,158507,158512,158513,158520,158523,192822,192827,192832,192833,192840,192843,232374,232379,232384,232385,232392,232395,273236,273237,273243,273247,273250,273256,288015,312602,312603,312609,312613,312616,312622,357314,357315,357321,357325,357328,357334) ) 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` = 52032 WHERE `RP`.`player` = 52032 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125248,126347,129017,130046,204181,206083,209615,209704,280921,280926,280929,280934,280937,280942,338088,338094,338097,338102,338105,338107,10398235,10398240,10398243,10398248,10398251,10398256,10479006,10479012,10479015,10479020,10479023,10479025,10542299,10542304,10542307,10542312,10542315,10542320,10567343,10604555,10604560,10604563,10604568,10604571,10604576,10662951,10662953,10662960,10662963,10662966,10662972,10726603,10726608,10726611,10726616,10726619,10726624,10796605,10796610,10796613,10796618,10796621,10796626,10825107,10876387,10876392,10876395,10876400,10876403,10876408,10919832,10919838,10919841,10919846,10919849,10919851,10936974,10964315,10964317,10964324,10964327,10964330,10964336,10981501,11014920,11014921,11014927,11014931,11014934,11014940,11069606,11069611,11069616,11069617,11069624,11069627,11084879,11122110,11122111,11122117,11122121,11122124,11122130,11170525,11170530,11170533,11170538,11170541,11170546,11213771,11213776,11213779,11213784,11213787,11213792,11266573,11266578,11266580,11266586,11266589,11266591,11323283,11323288,11323291,11323296,11323299,11323304,11374981,11374986,11374988,11374994,11374997,11374999,11418546,11418547,11418553,11418557,11418560,11418566,11464734,11464739,11464744,11464745,11464752,11464755,11513992,11513997,11514002,11514003,11514010,11514013,11556830,11556835,11556840,11556841,11556848,11556851,11600534,11600539,11600544,11600545,11600552,11600555,11649458,11649463,11649468,11649469,11649476,11649479,11671532,11671537,11671542,11671543,11671550,11671553,11711139,11739315,11739316,11739322,11739326,11739329,11739335,11786932,11786937,11786939,11786945,11786948,11786950,11837074,11837079,11837081,11837087,11837090,11837092,11868825,11868826,11868832,11868836,11868839,11868845,11923991,11923996,11924001,11924002,11924009,11924012,11964049,11964054,11964059,11964060,11964067,11964070,12004271,12004272,12004278,12004282,12004285,12004291,12021343,12045619,12045620,12045626,12045630,12045633,12045639,12061187,12084645,12084646,12084652,12084656,12084659,12084665,20354,20359,20364,20365,20372,20375,71706,71711,71716,71717,71724,71727,85605,111867,111872,111874,111880,111883,111885,158502,158507,158512,158513,158520,158523,192822,192827,192832,192833,192840,192843,232374,232379,232384,232385,232392,232395,273236,273237,273243,273247,273250,273256,288015,312602,312603,312609,312613,312616,312622,357314,357315,357321,357325,357328,357334) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: