Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 17 | 9 | 1 | 3 | 173 | 51 | 1 | 41 | 6.74 | 1453 |
Национальная сборная | 7 | 6 | 1 | 0 | 91 | 30 | 0 | 13 | 7.14 | 550 |
Отборочный турнир | 7 | 6 | 1 | 0 | 91 | 30 | 0 | 13 | 7.14 | 550 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 10 | 3 | 0 | 3 | 82 | 21 | 1 | 28 | 6.45 | 903 |
Отборочный турнир | 10 | 3 | 0 | 3 | 82 | 21 | 1 | 28 | 6.45 | 903 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
ТОВЫ сборных | 18 | 14 | 1 | 4 | 114 | 74 | 1 | 44 | 6.94 | 1002 |
Всего за сборные | 35 | 23 | 2 | 7 | 287 | 125 | 2 | 85 | 6.84 | 2455 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 56989 WHERE `RP`.`player` = 56989 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125238,126341,128190,129006,130037,204171,206077,209452,209606,209693,280777,280782,280785,280790,280793,280798,338159,338164,338167,338172,338175,338180,10398212,10398218,10398221,10398226,10398229,10398231,10479054,10479060,10479063,10479068,10479071,10479073,10542230,10542233,10542236,10542239,10542246,10542249,10604654,10604657,10604660,10604663,10604670,10604673,10637411,10662927,10662929,10662936,10662939,10662942,10662948,10726484,10726490,10726493,10726498,10726501,10726503,10757391,10796798,10796804,10796807,10796812,10796815,10796817,10876507,10876512,10876515,10876520,10876523,10876528,10920023,10920028,10920031,10920036,10920039,10920044,10964241,10964246,10964249,10964254,10964257,10964262,11014703,11014708,11014710,11014716,11014719,11014721,11069653,11069658,11069661,11069666,11069669,11069674,11121965,11121970,11121972,11121978,11121981,11121983,11139738,11170623,11170628,11170630,11170636,11170639,11170641,11213774,11213775,11213781,11213785,11213788,11213794,11266597,11266602,11266604,11266610,11266613,11266615,11323309,11323314,11323316,11323322,11323325,11323327,11375029,11375034,11375036,11375042,11375045,11375047,11418666,11418667,11418673,11418677,11418680,11418686,11464662,11464667,11464672,11464673,11464680,11464683,11513824,11513829,11513834,11513835,11513842,11513845,11530202,11556880,11556881,11556887,11556891,11556894,11556900,11600679,11600684,11600686,11600692,11600695,11600697,11649506,11649511,11649516,11649517,11649524,11649527,11671558,11671559,11671565,11671569,11671572,11671578,11739312,11739317,11739320,11739325,11739328,11739333,11786956,11786961,11786963,11786969,11786972,11786974,11805217,11837266,11837271,11837273,11837279,11837282,11837284,11869017,11869018,11869024,11869028,11869031,11869037,11923969,11923970,11923976,11923980,11923983,11923989,11964025,11964030,11964035,11964036,11964043,11964046,12004197,12004202,12004207,12004208,12004215,12004218,12045569,12045574,12045579,12045580,12045587,12045590,12061186,12084813,12084814,12084820,12084824,12084827,12084833,20306,20311,20316,20317,20324,20327,71610,71615,71620,71621,71628,71631,111915,111920,111922,111928,111931,111933,158504,158505,158511,158515,158518,158524,192872,192873,192879,192883,192886,192892,232375,232380,232382,232388,232391,232393,273379,273384,273386,273392,273395,273397,312671,312676,312679,312684,312687,312692,331812,357383,357388,357391,357396,357399,357404) ) 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` = 56989 WHERE `RP`.`player` = 56989 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125238,126341,128190,129006,130037,204171,206077,209452,209606,209693,280777,280782,280785,280790,280793,280798,338159,338164,338167,338172,338175,338180,10398212,10398218,10398221,10398226,10398229,10398231,10479054,10479060,10479063,10479068,10479071,10479073,10542230,10542233,10542236,10542239,10542246,10542249,10604654,10604657,10604660,10604663,10604670,10604673,10637411,10662927,10662929,10662936,10662939,10662942,10662948,10726484,10726490,10726493,10726498,10726501,10726503,10757391,10796798,10796804,10796807,10796812,10796815,10796817,10876507,10876512,10876515,10876520,10876523,10876528,10920023,10920028,10920031,10920036,10920039,10920044,10964241,10964246,10964249,10964254,10964257,10964262,11014703,11014708,11014710,11014716,11014719,11014721,11069653,11069658,11069661,11069666,11069669,11069674,11121965,11121970,11121972,11121978,11121981,11121983,11139738,11170623,11170628,11170630,11170636,11170639,11170641,11213774,11213775,11213781,11213785,11213788,11213794,11266597,11266602,11266604,11266610,11266613,11266615,11323309,11323314,11323316,11323322,11323325,11323327,11375029,11375034,11375036,11375042,11375045,11375047,11418666,11418667,11418673,11418677,11418680,11418686,11464662,11464667,11464672,11464673,11464680,11464683,11513824,11513829,11513834,11513835,11513842,11513845,11530202,11556880,11556881,11556887,11556891,11556894,11556900,11600679,11600684,11600686,11600692,11600695,11600697,11649506,11649511,11649516,11649517,11649524,11649527,11671558,11671559,11671565,11671569,11671572,11671578,11739312,11739317,11739320,11739325,11739328,11739333,11786956,11786961,11786963,11786969,11786972,11786974,11805217,11837266,11837271,11837273,11837279,11837282,11837284,11869017,11869018,11869024,11869028,11869031,11869037,11923969,11923970,11923976,11923980,11923983,11923989,11964025,11964030,11964035,11964036,11964043,11964046,12004197,12004202,12004207,12004208,12004215,12004218,12045569,12045574,12045579,12045580,12045587,12045590,12061186,12084813,12084814,12084820,12084824,12084827,12084833,20306,20311,20316,20317,20324,20327,71610,71615,71620,71621,71628,71631,111915,111920,111922,111928,111931,111933,158504,158505,158511,158515,158518,158524,192872,192873,192879,192883,192886,192892,232375,232380,232382,232388,232391,232393,273379,273384,273386,273392,273395,273397,312671,312676,312679,312684,312687,312692,331812,357383,357388,357391,357396,357399,357404) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: