Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 5 | 0 | 0 | 29 | 127 | 5 | 12 | 0 | 7.30 | 396 |
Национальная сборная | 1 | 0 | 0 | 3 | 27 | 1 | 6 | 0 | 7.00 | 65 |
Отборочный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Финальный турнир | 1 | 0 | 0 | 3 | 27 | 1 | 6 | 0 | 7.00 | 65 |
Молодежная сборная | 4 | 0 | 0 | 26 | 100 | 4 | 6 | 0 | 7.38 | 331 |
Отборочный турнир | 4 | 0 | 0 | 26 | 100 | 4 | 6 | 0 | 7.38 | 331 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
ТОВЫ сборных | 11 | 0 | 0 | 60 | 208 | 4 | 34 | 0 | 7.36 | 968 |
Всего за сборные | 16 | 0 | 0 | 89 | 335 | 9 | 46 | 0 | 7.34 | 1364 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 65439 WHERE `RP`.`player` = 65439 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125210,126311,128160,128977,130018,204141,206047,209422,209577,209676,280730,280736,280739,280744,280747,280749,303561,303566,303569,303668,338087,338092,338095,338100,338103,338108,10369066,10398115,10398120,10398123,10398128,10398131,10398136,10441185,10441190,10441193,10479053,10479058,10479061,10479066,10479069,10479074,10513365,10513370,10513373,10514101,10542227,10542232,10542235,10542240,10542243,10542248,10604483,10604488,10604491,10604496,10604499,10604504,10662733,10662738,10662741,10662746,10662749,10662754,10690379,10726508,10726514,10726517,10726522,10726525,10726527,10757383,10796750,10796756,10796759,10796764,10796767,10796769,10876317,10876319,10876326,10876329,10876332,10876338,10892861,10893746,10893751,10893756,10893992,10894517,10895374,10920047,10920052,10920055,10920060,10920063,10920068,10937933,10937938,10937941,10964409,10964414,10964417,10964422,10964425,10964430,10981499,11014773,11014778,11014781,11014786,11014789,11014794,11038291,11038296,11038299,11069509,11069514,11069517,11069522,11069525,11069530,11085701,11085706,11085708,11121989,11121994,11121996,11122002,11122005,11122007,11140273,11140278,11140281,11170717,11170722,11170725,11170730,11170733,11170738,11213845,11213850,11213852,11213858,11213861,11213863,11266621,11266626,11266628,11266634,11266637,11266639,11284043,11323453,11323458,11323460,11323466,11323469,11323471,11337855,11375005,11375010,11375012,11375018,11375021,11375023,11418688,11418693,11418698,11418699,11418706,11418709,11464782,11464787,11464792,11464793,11464800,11464803,11513754,11513755,11513761,11513765,11513768,11513774,11530208,11531600,11531605,11531610,11556975,11556980,11556982,11556988,11556991,11556993,11600703,11600708,11600710,11600716,11600719,11600721,11616923,11649412,11649413,11649419,11649423,11649426,11649432,11671510,11671511,11671517,11671521,11671524,11671530,11739291,11739292,11739298,11739302,11739305,11739311,11786933,11786934,11786940,11786944,11786947,11786953,11805291,11805292,11805298,11837195,11837196,11837202,11837206,11837209,11837215,11868897,11868898,11868904,11868908,11868911,11868917,11895848,11896735,11896740,11896745,11924134,11924139,11924142,11924147,11924150,11924155,11964170,11964175,11964177,11964183,11964186,11964188,12004174,12004179,12004181,12004187,12004190,12004192,12045425,12045430,12045435,12045436,12045443,12045446,12084691,12084696,12084701,12084702,12084709,12084712,12101116,20188,20189,20195,20199,20202,20208,71682,71687,71692,71693,71700,71703,111722,111727,111732,111733,111740,111743,126207,127078,127083,127088,158456,158457,158463,158467,158470,158476,192752,192753,192759,192763,192766,192772,232352,232353,232359,232363,232366,232372,248178,248179,248185,273308,273309,273315,273319,273322,273328,288009,288886,288891,288896,312577,312582,312584,312590,312593,312595,331805,357362,357363,357369,357373,357376,357382) ) 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` = 65439 WHERE `RP`.`player` = 65439 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125210,126311,128160,128977,130018,204141,206047,209422,209577,209676,280730,280736,280739,280744,280747,280749,303561,303566,303569,303668,338087,338092,338095,338100,338103,338108,10369066,10398115,10398120,10398123,10398128,10398131,10398136,10441185,10441190,10441193,10479053,10479058,10479061,10479066,10479069,10479074,10513365,10513370,10513373,10514101,10542227,10542232,10542235,10542240,10542243,10542248,10604483,10604488,10604491,10604496,10604499,10604504,10662733,10662738,10662741,10662746,10662749,10662754,10690379,10726508,10726514,10726517,10726522,10726525,10726527,10757383,10796750,10796756,10796759,10796764,10796767,10796769,10876317,10876319,10876326,10876329,10876332,10876338,10892861,10893746,10893751,10893756,10893992,10894517,10895374,10920047,10920052,10920055,10920060,10920063,10920068,10937933,10937938,10937941,10964409,10964414,10964417,10964422,10964425,10964430,10981499,11014773,11014778,11014781,11014786,11014789,11014794,11038291,11038296,11038299,11069509,11069514,11069517,11069522,11069525,11069530,11085701,11085706,11085708,11121989,11121994,11121996,11122002,11122005,11122007,11140273,11140278,11140281,11170717,11170722,11170725,11170730,11170733,11170738,11213845,11213850,11213852,11213858,11213861,11213863,11266621,11266626,11266628,11266634,11266637,11266639,11284043,11323453,11323458,11323460,11323466,11323469,11323471,11337855,11375005,11375010,11375012,11375018,11375021,11375023,11418688,11418693,11418698,11418699,11418706,11418709,11464782,11464787,11464792,11464793,11464800,11464803,11513754,11513755,11513761,11513765,11513768,11513774,11530208,11531600,11531605,11531610,11556975,11556980,11556982,11556988,11556991,11556993,11600703,11600708,11600710,11600716,11600719,11600721,11616923,11649412,11649413,11649419,11649423,11649426,11649432,11671510,11671511,11671517,11671521,11671524,11671530,11739291,11739292,11739298,11739302,11739305,11739311,11786933,11786934,11786940,11786944,11786947,11786953,11805291,11805292,11805298,11837195,11837196,11837202,11837206,11837209,11837215,11868897,11868898,11868904,11868908,11868911,11868917,11895848,11896735,11896740,11896745,11924134,11924139,11924142,11924147,11924150,11924155,11964170,11964175,11964177,11964183,11964186,11964188,12004174,12004179,12004181,12004187,12004190,12004192,12045425,12045430,12045435,12045436,12045443,12045446,12084691,12084696,12084701,12084702,12084709,12084712,12101116,20188,20189,20195,20199,20202,20208,71682,71687,71692,71693,71700,71703,111722,111727,111732,111733,111740,111743,126207,127078,127083,127088,158456,158457,158463,158467,158470,158476,192752,192753,192759,192763,192766,192772,232352,232353,232359,232363,232366,232372,248178,248179,248185,273308,273309,273315,273319,273322,273328,288009,288886,288891,288896,312577,312582,312584,312590,312593,312595,331805,357362,357363,357369,357373,357376,357382) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: