Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 59 | 29 | 3 | 8 | 270 | 166 | 0 | 89 | 6.92 | 2944 |
Национальная сборная | 45 | 24 | 3 | 6 | 244 | 111 | 0 | 71 | 7.04 | 2184 |
Отборочный турнир | 25 | 13 | 1 | 5 | 152 | 58 | 0 | 40 | 7.02 | 1195 |
Финальный турнир | 20 | 11 | 2 | 1 | 92 | 53 | 0 | 31 | 7.08 | 989 |
Молодежная сборная | 14 | 5 | 0 | 2 | 26 | 55 | 0 | 18 | 6.50 | 760 |
Отборочный турнир | 13 | 5 | 0 | 2 | 25 | 55 | 0 | 13 | 6.50 | 718 |
Финальный турнир | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 5 | 6.50 | 42 |
ТОВЫ сборных | 27 | 13 | 4 | 6 | 143 | 91 | 1 | 45 | 7.28 | 1381 |
Всего за сборные | 86 | 42 | 7 | 14 | 413 | 257 | 1 | 134 | 7.03 | 4325 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 52283 WHERE `RP`.`player` = 52283 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125211,126313,128162,128979,130016,204140,206049,209424,209579,209674,280802,280808,280811,280816,280819,280821,338208,338214,338217,338222,338225,338227,10398261,10398263,10398270,10398273,10398276,10398282,10479128,10479131,10479134,10479137,10479144,10479147,10542398,10542401,10542404,10542407,10542414,10542417,10604462,10604465,10604468,10604471,10604478,10604481,10662832,10662835,10662838,10662841,10662848,10662851,10726558,10726561,10726564,10726567,10726574,10726577,10796655,10796657,10796664,10796667,10796670,10796676,10825109,10876389,10876391,10876398,10876401,10876404,10876410,10919833,10919835,10919842,10919845,10919848,10919854,10964313,10964318,10964321,10964326,10964329,10964334,11014797,11014802,11014805,11014810,11014813,11014818,11036238,11069605,11069610,11069613,11069618,11069621,11069626,11122181,11122186,11122188,11122194,11122197,11122199,11170648,11170649,11170655,11170659,11170662,11170668,11213964,11213969,11213974,11213975,11213982,11213985,11266500,11266505,11266510,11266511,11266518,11266521,11323260,11323265,11323270,11323271,11323278,11323281,11374860,11374865,11374870,11374871,11374878,11374881,11391978,11418714,11418715,11418721,11418725,11418728,11418734,11464566,11464571,11464576,11464577,11464584,11464587,11513848,11513853,11513858,11513859,11513866,11513869,11556806,11556811,11556816,11556817,11556824,11556827,11600536,11600537,11600543,11600547,11600550,11600556,11616924,11649579,11649584,11649586,11649592,11649595,11649597,11671726,11671727,11671733,11671737,11671740,11671746,11739339,11739340,11739346,11739350,11739353,11739359,11786931,11786936,11786941,11786942,11786949,11786952,11837169,11837174,11837179,11837180,11837187,11837190,11868895,11868900,11868905,11868906,11868913,11868916,11924159,11924164,11924169,11924170,11924177,11924180,11964123,11964124,11964130,11964134,11964137,11964143,12004247,12004248,12004254,12004258,12004261,12004267,12021342,12045379,12045380,12045386,12045390,12045393,12045399,12084739,12084744,12084749,12084750,12084757,12084760,20282,20287,20292,20293,20300,20303,71827,71832,71834,71840,71843,71845,111721,111726,111729,111734,111737,111742,158575,158580,158582,158588,158591,158593,192871,192876,192878,192884,192887,192889,232278,232283,232288,232289,232296,232299,273282,273287,273292,273293,273300,273303,312456,312461,312466,312467,312474,312477,357192,357197,357202,357203,357210,357213) ) 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` = 52283 WHERE `RP`.`player` = 52283 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125211,126313,128162,128979,130016,204140,206049,209424,209579,209674,280802,280808,280811,280816,280819,280821,338208,338214,338217,338222,338225,338227,10398261,10398263,10398270,10398273,10398276,10398282,10479128,10479131,10479134,10479137,10479144,10479147,10542398,10542401,10542404,10542407,10542414,10542417,10604462,10604465,10604468,10604471,10604478,10604481,10662832,10662835,10662838,10662841,10662848,10662851,10726558,10726561,10726564,10726567,10726574,10726577,10796655,10796657,10796664,10796667,10796670,10796676,10825109,10876389,10876391,10876398,10876401,10876404,10876410,10919833,10919835,10919842,10919845,10919848,10919854,10964313,10964318,10964321,10964326,10964329,10964334,11014797,11014802,11014805,11014810,11014813,11014818,11036238,11069605,11069610,11069613,11069618,11069621,11069626,11122181,11122186,11122188,11122194,11122197,11122199,11170648,11170649,11170655,11170659,11170662,11170668,11213964,11213969,11213974,11213975,11213982,11213985,11266500,11266505,11266510,11266511,11266518,11266521,11323260,11323265,11323270,11323271,11323278,11323281,11374860,11374865,11374870,11374871,11374878,11374881,11391978,11418714,11418715,11418721,11418725,11418728,11418734,11464566,11464571,11464576,11464577,11464584,11464587,11513848,11513853,11513858,11513859,11513866,11513869,11556806,11556811,11556816,11556817,11556824,11556827,11600536,11600537,11600543,11600547,11600550,11600556,11616924,11649579,11649584,11649586,11649592,11649595,11649597,11671726,11671727,11671733,11671737,11671740,11671746,11739339,11739340,11739346,11739350,11739353,11739359,11786931,11786936,11786941,11786942,11786949,11786952,11837169,11837174,11837179,11837180,11837187,11837190,11868895,11868900,11868905,11868906,11868913,11868916,11924159,11924164,11924169,11924170,11924177,11924180,11964123,11964124,11964130,11964134,11964137,11964143,12004247,12004248,12004254,12004258,12004261,12004267,12021342,12045379,12045380,12045386,12045390,12045393,12045399,12084739,12084744,12084749,12084750,12084757,12084760,20282,20287,20292,20293,20300,20303,71827,71832,71834,71840,71843,71845,111721,111726,111729,111734,111737,111742,158575,158580,158582,158588,158591,158593,192871,192876,192878,192884,192887,192889,232278,232283,232288,232289,232296,232299,273282,273287,273292,273293,273300,273303,312456,312461,312466,312467,312474,312477,357192,357197,357202,357203,357210,357213) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: