Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 6 | 0 | 1 | 11 | 113 | 27 | 15 | 1 | 6.67 | 0 |
Национальная сборная | 5 | 0 | 1 | 11 | 88 | 14 | 12 | 0 | 6.80 | 0 |
Отборочный турнир | 5 | 0 | 1 | 11 | 88 | 14 | 12 | 0 | 6.80 | 0 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 1 | 0 | 0 | 0 | 25 | 13 | 3 | 1 | 6.00 | 0 |
Отборочный турнир | 1 | 0 | 0 | 0 | 25 | 13 | 3 | 1 | 6.00 | 0 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
ТОВЫ сборных | 3 | 0 | 0 | 7 | 37 | 5 | 10 | 0 | 6.33 | 0 |
Всего за сборные | 9 | 0 | 1 | 18 | 150 | 32 | 25 | 1 | 6.56 | 0 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 19932 WHERE `RP`.`player` = 19932 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125194,126385,128144,129051,130299,130662,204125,206121,209406,209649,210922,209737,280682,280688,280691,280696,280699,280701,338545,338547,338554,338557,338560,338566,10369074,10370570,10398362,10398365,10398368,10398371,10398378,10398381,10479392,10479395,10479398,10479401,10479408,10479411,10541990,10541993,10541996,10541999,10542006,10542009,10567349,10604798,10604801,10604804,10604807,10604814,10604817,10637423,10639500,10639505,10639510,10640817,10663215,10663217,10663224,10663227,10663230,10663236,10726126,10726129,10726132,10726135,10726142,10726145,10796944,10796947,10796950,10796953,10796960,10796963,10876678,10876681,10876684,10876687,10876694,10876697,10919666,10919669,10919672,10919675,10919682,10919685,10964486,10964489,10964492,10964495,10964502,10964505,11014966,11014971,11014976,11014977,11014984,11014987,11038318,11038319,11038325,11069392,11069393,11069399,11069403,11069406,11069412,11085761,11085766,11085768,11087192,11087486,11087611,11122326,11122327,11122333,11122337,11122340,11122346,11139728,11170359,11170364,11170366,11170372,11170375,11170377,11186278,11214085,11214090,11214092,11214098,11214101,11214103,11266910,11266911,11266917,11266921,11266924,11266930,11323070,11323071,11323077,11323081,11323084,11323090,11339764,11339765,11339771,11374694,11374695,11374701,11374705,11374708,11374714,11392946,11392947,11392953,11418498,11418499,11418505,11418509,11418512,11418518,11464448,11464449,11464455,11464459,11464462,11464468,11481164,11481165,11481171,11481634,11481767,11481860,11513559,11513564,11513567,11513572,11513575,11513580,11530197,11531516,11531521,11531526,11556663,11556668,11556670,11556676,11556679,11556681,11573282,11600437,11600442,11600445,11600450,11600453,11600458,11618462,11618463,11618469,11649363,11649368,11649370,11649376,11649379,11649381,11671413,11671418,11671420,11671426,11671429,11671431,11711952,11711957,11711959,11738954,11738959,11738961,11738967,11738970,11738972,11786789,11786790,11786796,11786800,11786803,11786809,11805204,11836834,11836839,11836841,11836847,11836850,11836852,11868657,11868658,11868664,11868668,11868671,11868677,11923775,11923780,11923785,11923786,11923793,11923796,11963811,11963812,11963818,11963822,11963825,11963831,12003933,12003938,12003943,12003944,12003951,12003954,12045283,12045284,12045290,12045294,12045297,12045303,12061929,12061930,12061936,12084477,12084478,12084484,12084488,12084491,12084497,19948,19949,19955,19959,19962,19968,47376,48074,48079,48084,48351,48815,49095,71537,71542,71545,71550,71553,71558,86395,86400,86403,111481,111486,111489,111494,111497,111502,158093,158098,158101,158106,158109,158114,172814,173612,173617,173622,192679,192684,192686,192692,192695,192697,210095,232543,232548,232550,232556,232559,232561,247347,273044,273045,273051,273055,273058,273064,312386,312387,312393,312397,312400,312406,356930,356931,356937,356941,356944,356950,371996) ) 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` = 19932 WHERE `RP`.`player` = 19932 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125194,126385,128144,129051,130299,130662,204125,206121,209406,209649,210922,209737,280682,280688,280691,280696,280699,280701,338545,338547,338554,338557,338560,338566,10369074,10370570,10398362,10398365,10398368,10398371,10398378,10398381,10479392,10479395,10479398,10479401,10479408,10479411,10541990,10541993,10541996,10541999,10542006,10542009,10567349,10604798,10604801,10604804,10604807,10604814,10604817,10637423,10639500,10639505,10639510,10640817,10663215,10663217,10663224,10663227,10663230,10663236,10726126,10726129,10726132,10726135,10726142,10726145,10796944,10796947,10796950,10796953,10796960,10796963,10876678,10876681,10876684,10876687,10876694,10876697,10919666,10919669,10919672,10919675,10919682,10919685,10964486,10964489,10964492,10964495,10964502,10964505,11014966,11014971,11014976,11014977,11014984,11014987,11038318,11038319,11038325,11069392,11069393,11069399,11069403,11069406,11069412,11085761,11085766,11085768,11087192,11087486,11087611,11122326,11122327,11122333,11122337,11122340,11122346,11139728,11170359,11170364,11170366,11170372,11170375,11170377,11186278,11214085,11214090,11214092,11214098,11214101,11214103,11266910,11266911,11266917,11266921,11266924,11266930,11323070,11323071,11323077,11323081,11323084,11323090,11339764,11339765,11339771,11374694,11374695,11374701,11374705,11374708,11374714,11392946,11392947,11392953,11418498,11418499,11418505,11418509,11418512,11418518,11464448,11464449,11464455,11464459,11464462,11464468,11481164,11481165,11481171,11481634,11481767,11481860,11513559,11513564,11513567,11513572,11513575,11513580,11530197,11531516,11531521,11531526,11556663,11556668,11556670,11556676,11556679,11556681,11573282,11600437,11600442,11600445,11600450,11600453,11600458,11618462,11618463,11618469,11649363,11649368,11649370,11649376,11649379,11649381,11671413,11671418,11671420,11671426,11671429,11671431,11711952,11711957,11711959,11738954,11738959,11738961,11738967,11738970,11738972,11786789,11786790,11786796,11786800,11786803,11786809,11805204,11836834,11836839,11836841,11836847,11836850,11836852,11868657,11868658,11868664,11868668,11868671,11868677,11923775,11923780,11923785,11923786,11923793,11923796,11963811,11963812,11963818,11963822,11963825,11963831,12003933,12003938,12003943,12003944,12003951,12003954,12045283,12045284,12045290,12045294,12045297,12045303,12061929,12061930,12061936,12084477,12084478,12084484,12084488,12084491,12084497,19948,19949,19955,19959,19962,19968,47376,48074,48079,48084,48351,48815,49095,71537,71542,71545,71550,71553,71558,86395,86400,86403,111481,111486,111489,111494,111497,111502,158093,158098,158101,158106,158109,158114,172814,173612,173617,173622,192679,192684,192686,192692,192695,192697,210095,232543,232548,232550,232556,232559,232561,247347,273044,273045,273051,273055,273058,273064,312386,312387,312393,312397,312400,312406,356930,356931,356937,356941,356944,356950,371996) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: