Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 2 | 0 | 0 | 8 | 20 | 0 | 4 | 0 | 6.75 | 138 |
Национальная сборная | 1 | 0 | 0 | 7 | 16 | 0 | 3 | 0 | 6.50 | 92 |
Отборочный турнир | 1 | 0 | 0 | 7 | 16 | 0 | 3 | 0 | 6.50 | 92 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 1 | 0 | 0 | 1 | 4 | 0 | 1 | 0 | 7.00 | 46 |
Отборочный турнир | 1 | 0 | 0 | 1 | 4 | 0 | 1 | 0 | 7.00 | 46 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
ТОВЫ сборных | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Всего за сборные | 2 | 0 | 0 | 8 | 20 | 0 | 4 | 0 | 6.75 | 138 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 65717 WHERE `RP`.`player` = 65717 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125167,126354,128113,129022,130265,204096,206092,209373,209622,209705,280466,280472,280475,280480,280483,280485,338567,338572,338575,338580,338583,338588,10369078,10370572,10398383,10398388,10398391,10398396,10398399,10398404,10440281,10479461,10479466,10479469,10479474,10479477,10479482,10512418,10542011,10542016,10542019,10542024,10542027,10542032,10604916,10604922,10604925,10604930,10604933,10604935,10663119,10663121,10663128,10663131,10663134,10663140,10726196,10726202,10726205,10726210,10726213,10726215,10796991,10796993,10797000,10797003,10797006,10797012,10876531,10876536,10876539,10876544,10876547,10876552,10892859,10919711,10919716,10919719,10919724,10919727,10919732,10964531,10964536,10964539,10964544,10964547,10964552,10981490,11015037,11015042,11015045,11015050,11015053,11015058,11069389,11069394,11069397,11069402,11069405,11069410,11122467,11122472,11122475,11122480,11122483,11122488,11170309,11170314,11170317,11170322,11170325,11170330,11214203,11214208,11214211,11214216,11214219,11214224,11266883,11266888,11266891,11266896,11266899,11266904,11323067,11323072,11323075,11323080,11323083,11323088,11374741,11374746,11374748,11374754,11374757,11374759,11418522,11418523,11418529,11418533,11418536,11418542,11464520,11464521,11464527,11464531,11464534,11464540,11479162,11513586,11513587,11513593,11513597,11513600,11513606,11556687,11556692,11556694,11556700,11556703,11556705,11573277,11600391,11600396,11600398,11600404,11600407,11600409,11649339,11649344,11649346,11649352,11649355,11649357,11671461,11671466,11671468,11671474,11671477,11671479,11739098,11739103,11739105,11739111,11739114,11739116,11786788,11786793,11786795,11786801,11786804,11786806,11836883,11836884,11836890,11836894,11836897,11836903,11868777,11868778,11868784,11868788,11868791,11868797,11923681,11923682,11923688,11923692,11923695,11923701,11963882,11963887,11963889,11963895,11963898,11963900,12003958,12003963,12003965,12003971,12003974,12003976,12021331,12045307,12045308,12045314,12045318,12045321,12045327,12084357,12084358,12084364,12084368,12084371,12084377,12101109,19876,19877,19883,19887,19890,19896,71563,71568,71570,71576,71579,71581,111603,111608,111610,111616,111619,111621,126189,158167,158172,158174,158180,158183,158185,192463,192468,192470,192476,192479,192481,232568,232569,232575,232579,232582,232588,273139,273144,273146,273152,273155,273157,312241,312246,312248,312254,312257,312259,357145,357150,357152,357158,357161,357163) ) 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) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 65717 WHERE `RP`.`player` = 65717 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125167,126354,128113,129022,130265,204096,206092,209373,209622,209705,280466,280472,280475,280480,280483,280485,338567,338572,338575,338580,338583,338588,10369078,10370572,10398383,10398388,10398391,10398396,10398399,10398404,10440281,10479461,10479466,10479469,10479474,10479477,10479482,10512418,10542011,10542016,10542019,10542024,10542027,10542032,10604916,10604922,10604925,10604930,10604933,10604935,10663119,10663121,10663128,10663131,10663134,10663140,10726196,10726202,10726205,10726210,10726213,10726215,10796991,10796993,10797000,10797003,10797006,10797012,10876531,10876536,10876539,10876544,10876547,10876552,10892859,10919711,10919716,10919719,10919724,10919727,10919732,10964531,10964536,10964539,10964544,10964547,10964552,10981490,11015037,11015042,11015045,11015050,11015053,11015058,11069389,11069394,11069397,11069402,11069405,11069410,11122467,11122472,11122475,11122480,11122483,11122488,11170309,11170314,11170317,11170322,11170325,11170330,11214203,11214208,11214211,11214216,11214219,11214224,11266883,11266888,11266891,11266896,11266899,11266904,11323067,11323072,11323075,11323080,11323083,11323088,11374741,11374746,11374748,11374754,11374757,11374759,11418522,11418523,11418529,11418533,11418536,11418542,11464520,11464521,11464527,11464531,11464534,11464540,11479162,11513586,11513587,11513593,11513597,11513600,11513606,11556687,11556692,11556694,11556700,11556703,11556705,11573277,11600391,11600396,11600398,11600404,11600407,11600409,11649339,11649344,11649346,11649352,11649355,11649357,11671461,11671466,11671468,11671474,11671477,11671479,11739098,11739103,11739105,11739111,11739114,11739116,11786788,11786793,11786795,11786801,11786804,11786806,11836883,11836884,11836890,11836894,11836897,11836903,11868777,11868778,11868784,11868788,11868791,11868797,11923681,11923682,11923688,11923692,11923695,11923701,11963882,11963887,11963889,11963895,11963898,11963900,12003958,12003963,12003965,12003971,12003974,12003976,12021331,12045307,12045308,12045314,12045318,12045321,12045327,12084357,12084358,12084364,12084368,12084371,12084377,12101109,19876,19877,19883,19887,19890,19896,71563,71568,71570,71576,71579,71581,111603,111608,111610,111616,111619,111621,126189,158167,158172,158174,158180,158183,158185,192463,192468,192470,192476,192479,192481,232568,232569,232575,232579,232582,232588,273139,273144,273146,273152,273155,273157,312241,312246,312248,312254,312257,312259,357145,357150,357152,357158,357161,357163) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: