Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 7 | 0 | 0 | 15 | 49 | 9 | 7 | 0 | 5.79 | 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 |
Молодежная сборная | 7 | 0 | 0 | 15 | 49 | 9 | 7 | 0 | 5.79 | 0 |
Отборочный турнир | 7 | 0 | 0 | 15 | 49 | 9 | 7 | 0 | 5.79 | 0 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
ТОВЫ сборных | 6 | 0 | 0 | 5 | 55 | 9 | 16 | 0 | 6.08 | 0 |
Всего за сборные | 13 | 0 | 0 | 20 | 104 | 18 | 23 | 0 | 5.92 | 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(139) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 3939 WHERE `RP`.`player` = 3939 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125214,126312,128165,128976,130021,204145,206050,209425,209578,209677,280731,280733,280740,280743,280746,280752,338138,338141,338144,338147,338154,338157,10398214,10398217,10398220,10398223,10398230,10398233,10479176,10479179,10479182,10479185,10479192,10479195,10512399,10542421,10542423,10542430,10542433,10542436,10542442,10567346,10604461,10604463,10604470,10604473,10604476,10604482,10662783,10662785,10662792,10662795,10662798,10662804,10726509,10726511,10726518,10726521,10726524,10726530,10796799,10796801,10796808,10796811,10796814,10796820,10876485,10876487,10876494,10876497,10876500,10876506,10919951,10919956,10919959,10919964,10919967,10919972,10936975,10964169,10964174,10964177,10964182,10964185,10964190,11014823,11014828,11014830,11014836,11014839,11014841,11069512,11069513,11069519,11069523,11069526,11069532,11084885,11121987,11121992,11121995,11122000,11122003,11122008,11170479,11170484,11170486,11170492,11170495,11170497,11213726,11213727,11213733,11213737,11213740,11213746,11266716,11266721,11266726,11266727,11266734,11266737,11323356,11323361,11323366,11323367,11323374,11323377,11374955,11374960,11374963,11374968,11374971,11374976,11418783,11418788,11418791,11418796,11418799,11418804,11464805,11464810,11464813,11464818,11464821,11464826,11513919,11513924,11513927,11513932,11513935,11513940,11530209,11557021,11557026,11557029,11557034,11557037,11557042,11573287,11600583,11600588,11600590,11600596,11600599,11600601,11649531,11649536,11649538,11649544,11649547,11649549,11666269,11671486,11671487,11671493,11671497,11671500,11671506,11739313,11739318,11739323,11739324,11739331,11739334,11786955,11786960,11786965,11786966,11786973,11786976,11837097,11837102,11837107,11837108,11837115,11837118,11868871,11868876,11868881,11868882,11868889,11868892,11924137,11924138,11924144,11924148,11924151,11924157,11964192,11964197,11964200,11964205,11964208,11964213,12004294,12004299,12004301,12004307,12004310,12004312,12021336,12045522,12045527,12045529,12045535,12045538,12045540,12084741,12084742,12084748,12084752,12084755,12084761,12101119,20308,20309,20315,20319,20322,20328,71658,71663,71668,71669,71676,71679,111746,111751,111756,111757,111764,111767,158360,158361,158367,158371,158374,158380,192893,192898,192901,192906,192909,192914,232207,232212,232214,232220,232223,232225,247358,273307,273312,273314,273320,273323,273325,312529,312534,312536,312542,312545,312547,357290,357291,357297,357301,357304,357310) ) 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` = 3939 WHERE `RP`.`player` = 3939 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125214,126312,128165,128976,130021,204145,206050,209425,209578,209677,280731,280733,280740,280743,280746,280752,338138,338141,338144,338147,338154,338157,10398214,10398217,10398220,10398223,10398230,10398233,10479176,10479179,10479182,10479185,10479192,10479195,10512399,10542421,10542423,10542430,10542433,10542436,10542442,10567346,10604461,10604463,10604470,10604473,10604476,10604482,10662783,10662785,10662792,10662795,10662798,10662804,10726509,10726511,10726518,10726521,10726524,10726530,10796799,10796801,10796808,10796811,10796814,10796820,10876485,10876487,10876494,10876497,10876500,10876506,10919951,10919956,10919959,10919964,10919967,10919972,10936975,10964169,10964174,10964177,10964182,10964185,10964190,11014823,11014828,11014830,11014836,11014839,11014841,11069512,11069513,11069519,11069523,11069526,11069532,11084885,11121987,11121992,11121995,11122000,11122003,11122008,11170479,11170484,11170486,11170492,11170495,11170497,11213726,11213727,11213733,11213737,11213740,11213746,11266716,11266721,11266726,11266727,11266734,11266737,11323356,11323361,11323366,11323367,11323374,11323377,11374955,11374960,11374963,11374968,11374971,11374976,11418783,11418788,11418791,11418796,11418799,11418804,11464805,11464810,11464813,11464818,11464821,11464826,11513919,11513924,11513927,11513932,11513935,11513940,11530209,11557021,11557026,11557029,11557034,11557037,11557042,11573287,11600583,11600588,11600590,11600596,11600599,11600601,11649531,11649536,11649538,11649544,11649547,11649549,11666269,11671486,11671487,11671493,11671497,11671500,11671506,11739313,11739318,11739323,11739324,11739331,11739334,11786955,11786960,11786965,11786966,11786973,11786976,11837097,11837102,11837107,11837108,11837115,11837118,11868871,11868876,11868881,11868882,11868889,11868892,11924137,11924138,11924144,11924148,11924151,11924157,11964192,11964197,11964200,11964205,11964208,11964213,12004294,12004299,12004301,12004307,12004310,12004312,12021336,12045522,12045527,12045529,12045535,12045538,12045540,12084741,12084742,12084748,12084752,12084755,12084761,12101119,20308,20309,20315,20319,20322,20328,71658,71663,71668,71669,71676,71679,111746,111751,111756,111757,111764,111767,158360,158361,158367,158371,158374,158380,192893,192898,192901,192906,192909,192914,232207,232212,232214,232220,232223,232225,247358,273307,273312,273314,273320,273323,273325,312529,312534,312536,312542,312545,312547,357290,357291,357297,357301,357304,357310) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: