Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 8 | 0 | 1 | 79 | 256 | 10 | 34 | 0 | 7.38 | 555 |
Национальная сборная | 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 |
Молодежная сборная | 8 | 0 | 1 | 79 | 256 | 10 | 34 | 0 | 7.38 | 555 |
Отборочный турнир | 5 | 0 | 1 | 56 | 186 | 10 | 25 | 0 | 7.70 | 402 |
Финальный турнир | 3 | 0 | 0 | 23 | 70 | 0 | 9 | 0 | 6.83 | 153 |
ТОВЫ сборных | 5 | 0 | 0 | 43 | 156 | 7 | 21 | 0 | 7.80 | 325 |
Всего за сборные | 13 | 0 | 1 | 122 | 412 | 17 | 55 | 0 | 7.54 | 880 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 81760 WHERE `RP`.`player` = 81760 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125214,126312,128165,128976,130021,204145,206050,209425,209578,209677,246914,246919,246924,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,10569126,10569131,10569136,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,10893771,10893776,10893778,10893990,10894518,10895370,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,11085738,11085739,11085745,11087184,11087489,11087615,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,11339800,11339801,11339807,11340359,11340456,11341834,11374955,11374960,11374963,11374968,11374971,11374976,11393003,11393008,11393011,11394298,11394690,11394854,11418783,11418788,11418791,11418796,11418799,11418804,11464805,11464810,11464813,11464818,11464821,11464826,11481223,11481228,11481230,11513919,11513924,11513927,11513932,11513935,11513940,11530209,11531566,11531567,11531573,11531957,11532592,11532795,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,11805279,11805280,11805286,11837097,11837102,11837107,11837108,11837115,11837118,11868871,11868876,11868881,11868882,11868889,11868892,11896725,11896726,11896732,11896916,11924137,11924138,11924144,11924148,11924151,11924157,11940890,11940895,11940897,11942507,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,173662,173663,173669,174578,174669,175368,192893,192898,192901,192906,192909,192914,232207,232212,232214,232220,232223,232225,247358,248176,248181,248186,249070,273307,273312,273314,273320,273323,273325,288888,288889,288895,289797,290023,290584,312529,312534,312536,312542,312545,312547,357290,357291,357297,357301,357304,357310,372821,372826,372828,373745,374302,374535) ) 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` = 81760 WHERE `RP`.`player` = 81760 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125214,126312,128165,128976,130021,204145,206050,209425,209578,209677,246914,246919,246924,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,10569126,10569131,10569136,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,10893771,10893776,10893778,10893990,10894518,10895370,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,11085738,11085739,11085745,11087184,11087489,11087615,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,11339800,11339801,11339807,11340359,11340456,11341834,11374955,11374960,11374963,11374968,11374971,11374976,11393003,11393008,11393011,11394298,11394690,11394854,11418783,11418788,11418791,11418796,11418799,11418804,11464805,11464810,11464813,11464818,11464821,11464826,11481223,11481228,11481230,11513919,11513924,11513927,11513932,11513935,11513940,11530209,11531566,11531567,11531573,11531957,11532592,11532795,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,11805279,11805280,11805286,11837097,11837102,11837107,11837108,11837115,11837118,11868871,11868876,11868881,11868882,11868889,11868892,11896725,11896726,11896732,11896916,11924137,11924138,11924144,11924148,11924151,11924157,11940890,11940895,11940897,11942507,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,173662,173663,173669,174578,174669,175368,192893,192898,192901,192906,192909,192914,232207,232212,232214,232220,232223,232225,247358,248176,248181,248186,249070,273307,273312,273314,273320,273323,273325,288888,288889,288895,289797,290023,290584,312529,312534,312536,312542,312545,312547,357290,357291,357297,357301,357304,357310,372821,372826,372828,373745,374302,374535) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: