Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 1 | 0 | 0 | 4 | 8 | 0 | 1 | 0 | 6.50 | 0 |
Национальная сборная | 1 | 0 | 0 | 4 | 8 | 0 | 1 | 0 | 6.50 | 0 |
Отборочный турнир | 1 | 0 | 0 | 4 | 8 | 0 | 1 | 0 | 6.50 | 0 |
Финальный турнир | 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 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
ТОВЫ сборных | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Всего за сборные | 1 | 0 | 0 | 4 | 8 | 0 | 1 | 0 | 6.50 | 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` = 2786 WHERE `RP`.`player` = 2786 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125179,126366,128125,129034,130277,204108,206104,209385,209634,209717,280490,280496,280499,280504,280507,280509,338497,338499,338506,338509,338512,338518,10370806,10370811,10370816,10371779,10372463,10372530,10398479,10398484,10398487,10398492,10398495,10398500,10441259,10441264,10441266,10442087,10442245,10443327,10479293,10479298,10479301,10479306,10479309,10479314,10541989,10541991,10541998,10542001,10542004,10542010,10604702,10604705,10604708,10604711,10604718,10604721,10662976,10662979,10662982,10662985,10662992,10662995,10691408,10691409,10691415,10692381,10726174,10726177,10726180,10726183,10726190,10726193,10797039,10797041,10797048,10797051,10797054,10797060,10876629,10876631,10876638,10876641,10876644,10876650,10919761,10919763,10919770,10919773,10919776,10919782,10938008,10938009,10938015,10964532,10964538,10964541,10964546,10964549,10964551,10982917,10982922,10982925,10983324,11015085,11015090,11015093,11015098,11015101,11015106,11069463,11069468,11069470,11069476,11069479,11069481,11085759,11085764,11085767,11122421,11122426,11122428,11122434,11122437,11122439,11140263,11140268,11140270,11170237,11170242,11170245,11170250,11170253,11170258,11186637,11186642,11186644,11188240,11188363,11188465,11214155,11214160,11214163,11214168,11214171,11214176,11266765,11266770,11266772,11266778,11266781,11266783,11323045,11323050,11323052,11323058,11323061,11323063,11337865,11374574,11374575,11374581,11374585,11374588,11374594,11418353,11418358,11418360,11418366,11418369,11418371,11433504,11464352,11464353,11464359,11464363,11464366,11464372,11513560,11513565,11513570,11513571,11513578,11513581,11556542,11556547,11556552,11556553,11556560,11556563,11574742,11574743,11574749,11600512,11600513,11600519,11600523,11600526,11600532,11649148,11649149,11649155,11649159,11649162,11649168,11671438,11671439,11671445,11671449,11671452,11671458,11738931,11738932,11738938,11738942,11738945,11738951,11786835,11786840,11786845,11786846,11786853,11786856,11805211,11805229,11805234,11805239,11836978,11836983,11836985,11836991,11836994,11836996,11853395,11853396,11853402,11868680,11868685,11868687,11868693,11868696,11868698,11923801,11923802,11923808,11923812,11923815,11923821,11963835,11963836,11963842,11963846,11963849,11963855,12004103,12004104,12004110,12004114,12004117,12004123,12045259,12045260,12045266,12045270,12045273,12045279,12084453,12084454,12084460,12084464,12084467,12084473,19972,19973,19979,19983,19986,19992,71370,71375,71380,71381,71388,71391,111602,111607,111612,111613,111620,111623,158262,158267,158272,158273,158280,158283,192678,192683,192688,192689,192696,192699,232686,232691,232696,232697,232704,232707,247348,248140,248145,248150,273018,273023,273028,273029,273036,273039,312336,312341,312346,312347,312354,312357,357144,357149,357154,357155,357162,357165,371990,372784,372789,372794,373736) ) 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` = 2786 WHERE `RP`.`player` = 2786 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125179,126366,128125,129034,130277,204108,206104,209385,209634,209717,280490,280496,280499,280504,280507,280509,338497,338499,338506,338509,338512,338518,10370806,10370811,10370816,10371779,10372463,10372530,10398479,10398484,10398487,10398492,10398495,10398500,10441259,10441264,10441266,10442087,10442245,10443327,10479293,10479298,10479301,10479306,10479309,10479314,10541989,10541991,10541998,10542001,10542004,10542010,10604702,10604705,10604708,10604711,10604718,10604721,10662976,10662979,10662982,10662985,10662992,10662995,10691408,10691409,10691415,10692381,10726174,10726177,10726180,10726183,10726190,10726193,10797039,10797041,10797048,10797051,10797054,10797060,10876629,10876631,10876638,10876641,10876644,10876650,10919761,10919763,10919770,10919773,10919776,10919782,10938008,10938009,10938015,10964532,10964538,10964541,10964546,10964549,10964551,10982917,10982922,10982925,10983324,11015085,11015090,11015093,11015098,11015101,11015106,11069463,11069468,11069470,11069476,11069479,11069481,11085759,11085764,11085767,11122421,11122426,11122428,11122434,11122437,11122439,11140263,11140268,11140270,11170237,11170242,11170245,11170250,11170253,11170258,11186637,11186642,11186644,11188240,11188363,11188465,11214155,11214160,11214163,11214168,11214171,11214176,11266765,11266770,11266772,11266778,11266781,11266783,11323045,11323050,11323052,11323058,11323061,11323063,11337865,11374574,11374575,11374581,11374585,11374588,11374594,11418353,11418358,11418360,11418366,11418369,11418371,11433504,11464352,11464353,11464359,11464363,11464366,11464372,11513560,11513565,11513570,11513571,11513578,11513581,11556542,11556547,11556552,11556553,11556560,11556563,11574742,11574743,11574749,11600512,11600513,11600519,11600523,11600526,11600532,11649148,11649149,11649155,11649159,11649162,11649168,11671438,11671439,11671445,11671449,11671452,11671458,11738931,11738932,11738938,11738942,11738945,11738951,11786835,11786840,11786845,11786846,11786853,11786856,11805211,11805229,11805234,11805239,11836978,11836983,11836985,11836991,11836994,11836996,11853395,11853396,11853402,11868680,11868685,11868687,11868693,11868696,11868698,11923801,11923802,11923808,11923812,11923815,11923821,11963835,11963836,11963842,11963846,11963849,11963855,12004103,12004104,12004110,12004114,12004117,12004123,12045259,12045260,12045266,12045270,12045273,12045279,12084453,12084454,12084460,12084464,12084467,12084473,19972,19973,19979,19983,19986,19992,71370,71375,71380,71381,71388,71391,111602,111607,111612,111613,111620,111623,158262,158267,158272,158273,158280,158283,192678,192683,192688,192689,192696,192699,232686,232691,232696,232697,232704,232707,247348,248140,248145,248150,273018,273023,273028,273029,273036,273039,312336,312341,312346,312347,312354,312357,357144,357149,357154,357155,357162,357165,371990,372784,372789,372794,373736) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: