Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 5 | 0 | 0 | 31 | 68 | 1 | 8 | 0 | 6.40 | 431 |
Национальная сборная | 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 |
Молодежная сборная | 5 | 0 | 0 | 31 | 68 | 1 | 8 | 0 | 6.40 | 431 |
Отборочный турнир | 5 | 0 | 0 | 31 | 68 | 1 | 8 | 0 | 6.40 | 431 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
ТОВЫ сборных | 8 | 0 | 0 | 71 | 112 | 2 | 8 | 0 | 6.81 | 733 |
Всего за сборные | 13 | 0 | 0 | 102 | 180 | 3 | 16 | 0 | 6.65 | 1164 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 69873 WHERE `RP`.`player` = 69873 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125216,126319,128169,128988,204147,206055,209429,209586,246937,246942,246945,250364,250964,251097,280849,280854,280857,280862,280865,280870,301749,338279,338284,338287,338292,338295,338300,10370747,10370752,10370754,10398259,10398264,10398267,10398272,10398275,10398280,10440272,10441210,10441215,10441220,10478981,10478986,10478989,10478994,10478997,10479002,10512400,10513330,10513335,10513340,10514102,10514363,10514496,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,10758492,10758493,10758499,10796702,10796708,10796711,10796716,10796719,10796721,10826241,10826246,10826249,10826549,10876267,10876272,10876275,10876280,10876283,10876288,10893769,10893774,10893777,10919855,10919860,10919863,10919868,10919871,10919876,10964218,10964224,10964227,10964232,10964235,10964237,10981496,10982966,10982971,10982976,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,11229615,11229620,11229622,11266718,11266719,11266725,11266729,11266732,11266738,11284036,11286128,11286133,11286138,11323454,11323455,11323461,11323465,11323468,11323474,11374910,11374911,11374917,11374921,11374924,11374930,11391971,11392992,11392997,11393002,11394294,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,12061953,12061954,12061960,12084693,12084694,12084700,12084704,12084707,12084713,12101974,12101979,12101981,20163,20168,20170,20176,20179,20181,48063,48068,48070,71707,71712,71714,71720,71723,71725,111843,111848,111850,111856,111859,111861,158430,158435,158440,158441,158448,158451,173685,173690,173692,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,333291,333296,333298,333577,334623,335001,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, 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` = 69873 WHERE `RP`.`player` = 69873 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125216,126319,128169,128988,204147,206055,209429,209586,246937,246942,246945,250364,250964,251097,280849,280854,280857,280862,280865,280870,301749,338279,338284,338287,338292,338295,338300,10370747,10370752,10370754,10398259,10398264,10398267,10398272,10398275,10398280,10440272,10441210,10441215,10441220,10478981,10478986,10478989,10478994,10478997,10479002,10512400,10513330,10513335,10513340,10514102,10514363,10514496,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,10758492,10758493,10758499,10796702,10796708,10796711,10796716,10796719,10796721,10826241,10826246,10826249,10826549,10876267,10876272,10876275,10876280,10876283,10876288,10893769,10893774,10893777,10919855,10919860,10919863,10919868,10919871,10919876,10964218,10964224,10964227,10964232,10964235,10964237,10981496,10982966,10982971,10982976,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,11229615,11229620,11229622,11266718,11266719,11266725,11266729,11266732,11266738,11284036,11286128,11286133,11286138,11323454,11323455,11323461,11323465,11323468,11323474,11374910,11374911,11374917,11374921,11374924,11374930,11391971,11392992,11392997,11393002,11394294,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,12061953,12061954,12061960,12084693,12084694,12084700,12084704,12084707,12084713,12101974,12101979,12101981,20163,20168,20170,20176,20179,20181,48063,48068,48070,71707,71712,71714,71720,71723,71725,111843,111848,111850,111856,111859,111861,158430,158435,158440,158441,158448,158451,173685,173690,173692,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,333291,333296,333298,333577,334623,335001,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}: