Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 15 | 8 | 2 | 2 | 38 | 61 | 0 | 31 | 7.57 | 344 |
Национальная сборная | 8 | 5 | 2 | 2 | 25 | 30 | 0 | 20 | 7.62 | 344 |
Отборочный турнир | 8 | 5 | 2 | 2 | 25 | 30 | 0 | 20 | 7.62 | 344 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 7 | 3 | 0 | 0 | 13 | 31 | 0 | 11 | 7.50 | 0 |
Отборочный турнир | 5 | 3 | 0 | 0 | 11 | 21 | 0 | 5 | 7.30 | 0 |
Финальный турнир | 2 | 0 | 0 | 0 | 2 | 10 | 0 | 6 | 8.00 | 0 |
ТОВЫ сборных | 5 | 2 | 0 | 0 | 6 | 27 | 0 | 12 | 7.04 | 140 |
Всего за сборные | 20 | 10 | 2 | 2 | 44 | 88 | 0 | 43 | 7.43 | 484 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 41276 WHERE `RP`.`player` = 41276 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125216,126319,128169,128988,204147,206055,209429,209586,280849,280854,280857,280862,280865,280870,301749,338279,338284,338287,338292,338295,338300,10398259,10398264,10398267,10398272,10398275,10398280,10440272,10478981,10478986,10478989,10478994,10478997,10479002,10512400,10542347,10542352,10542355,10542360,10542363,10542368,10604651,10604656,10604659,10604664,10604667,10604672,10662759,10662761,10662768,10662771,10662774,10662780,10690373,10726389,10726391,10726398,10726401,10726404,10726410,10796702,10796708,10796711,10796716,10796719,10796721,10876267,10876272,10876275,10876280,10876283,10876288,10919855,10919860,10919863,10919868,10919871,10919876,10964218,10964224,10964227,10964232,10964235,10964237,10981496,11014752,11014753,11014759,11014763,11014766,11014772,11069656,11069657,11069663,11069667,11069670,11069676,11121988,11121993,11121998,11121999,11122006,11122009,11170694,11170699,11170704,11170705,11170712,11170715,11213868,11213873,11213878,11213879,11213886,11213889,11266718,11266719,11266725,11266729,11266732,11266738,11284036,11323454,11323455,11323461,11323465,11323468,11323474,11374910,11374911,11374917,11374921,11374924,11374930,11391971,11418738,11418739,11418745,11418749,11418752,11418758,11464568,11464569,11464575,11464579,11464582,11464588,11513800,11513805,11513810,11513811,11513818,11513821,11556902,11556907,11556912,11556913,11556920,11556923,11600750,11600755,11600760,11600761,11600768,11600771,11649434,11649439,11649444,11649445,11649452,11649455,11671628,11671633,11671638,11671639,11671646,11671649,11739265,11739270,11739275,11739276,11739283,11739286,11786859,11786864,11786869,11786870,11786877,11786880,11837241,11837246,11837251,11837252,11837259,11837262,11868943,11868948,11868953,11868954,11868961,11868964,11924063,11924068,11924073,11924074,11924081,11924084,11964145,11964150,11964155,11964156,11964163,11964166,12004293,12004298,12004303,12004304,12004311,12004314,12045521,12045526,12045531,12045532,12045539,12045542,12084693,12084694,12084700,12084704,12084707,12084713,20163,20168,20170,20176,20179,20181,71707,71712,71714,71720,71723,71725,111843,111848,111850,111856,111859,111861,158430,158435,158440,158441,158448,158451,192727,192732,192734,192740,192743,192745,210103,232448,232449,232455,232459,232462,232468,273306,273311,273316,273317,273324,273327,312696,312701,312706,312707,312714,312717,357409,357414,357416,357422,357425,357427,372005) ) 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` = 41276 WHERE `RP`.`player` = 41276 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125216,126319,128169,128988,204147,206055,209429,209586,280849,280854,280857,280862,280865,280870,301749,338279,338284,338287,338292,338295,338300,10398259,10398264,10398267,10398272,10398275,10398280,10440272,10478981,10478986,10478989,10478994,10478997,10479002,10512400,10542347,10542352,10542355,10542360,10542363,10542368,10604651,10604656,10604659,10604664,10604667,10604672,10662759,10662761,10662768,10662771,10662774,10662780,10690373,10726389,10726391,10726398,10726401,10726404,10726410,10796702,10796708,10796711,10796716,10796719,10796721,10876267,10876272,10876275,10876280,10876283,10876288,10919855,10919860,10919863,10919868,10919871,10919876,10964218,10964224,10964227,10964232,10964235,10964237,10981496,11014752,11014753,11014759,11014763,11014766,11014772,11069656,11069657,11069663,11069667,11069670,11069676,11121988,11121993,11121998,11121999,11122006,11122009,11170694,11170699,11170704,11170705,11170712,11170715,11213868,11213873,11213878,11213879,11213886,11213889,11266718,11266719,11266725,11266729,11266732,11266738,11284036,11323454,11323455,11323461,11323465,11323468,11323474,11374910,11374911,11374917,11374921,11374924,11374930,11391971,11418738,11418739,11418745,11418749,11418752,11418758,11464568,11464569,11464575,11464579,11464582,11464588,11513800,11513805,11513810,11513811,11513818,11513821,11556902,11556907,11556912,11556913,11556920,11556923,11600750,11600755,11600760,11600761,11600768,11600771,11649434,11649439,11649444,11649445,11649452,11649455,11671628,11671633,11671638,11671639,11671646,11671649,11739265,11739270,11739275,11739276,11739283,11739286,11786859,11786864,11786869,11786870,11786877,11786880,11837241,11837246,11837251,11837252,11837259,11837262,11868943,11868948,11868953,11868954,11868961,11868964,11924063,11924068,11924073,11924074,11924081,11924084,11964145,11964150,11964155,11964156,11964163,11964166,12004293,12004298,12004303,12004304,12004311,12004314,12045521,12045526,12045531,12045532,12045539,12045542,12084693,12084694,12084700,12084704,12084707,12084713,20163,20168,20170,20176,20179,20181,71707,71712,71714,71720,71723,71725,111843,111848,111850,111856,111859,111861,158430,158435,158440,158441,158448,158451,192727,192732,192734,192740,192743,192745,210103,232448,232449,232455,232459,232462,232468,273306,273311,273316,273317,273324,273327,312696,312701,312706,312707,312714,312717,357409,357414,357416,357422,357425,357427,372005) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: