Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 16 | 2 | 0 | 105 | 205 | 3 | 40 | 2 | 7.25 | 949 |
Национальная сборная | 11 | 2 | 0 | 80 | 133 | 2 | 23 | 2 | 7.36 | 949 |
Отборочный турнир | 8 | 2 | 0 | 65 | 109 | 2 | 16 | 2 | 7.62 | 673 |
Финальный турнир | 3 | 0 | 0 | 15 | 24 | 0 | 7 | 0 | 6.67 | 276 |
Молодежная сборная | 5 | 0 | 0 | 25 | 72 | 1 | 17 | 0 | 7.00 | 0 |
Отборочный турнир | 3 | 0 | 0 | 18 | 37 | 1 | 7 | 0 | 7.17 | 0 |
Финальный турнир | 2 | 0 | 0 | 7 | 35 | 0 | 10 | 0 | 6.75 | 0 |
ТОВЫ сборных | 13 | 1 | 0 | 86 | 167 | 3 | 33 | 3 | 7.54 | 783 |
Всего за сборные | 29 | 3 | 0 | 191 | 372 | 6 | 73 | 5 | 7.38 | 1732 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 41897 WHERE `RP`.`player` = 41897 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125218,126317,128989,130010,204149,206053,209585,209668,246952,246953,246959,250362,250965,251096,280801,280806,280809,280814,280817,280822,303573,303578,303581,338111,338116,338119,338124,338127,338132,10398139,10398144,10398147,10398152,10398155,10398160,10479102,10479108,10479111,10479116,10479119,10479121,10513329,10513334,10513337,10514095,10542251,10542256,10542259,10542264,10542267,10542272,10567342,10604411,10604416,10604419,10604424,10604427,10604432,10637418,10639562,10639563,10639569,10640807,10662853,10662858,10662861,10662866,10662869,10662874,10691381,10691386,10691389,10692375,10692491,10693163,10726435,10726440,10726443,10726448,10726451,10726456,10796725,10796730,10796733,10796738,10796741,10796746,10826268,10826269,10826275,10826547,10826632,10827308,10876411,10876416,10876419,10876424,10876427,10876432,10892866,10893748,10893749,10893755,10919903,10919908,10919911,10919916,10919919,10919924,10964337,10964342,10964345,10964350,10964353,10964358,10981502,10982992,10982993,10982999,10983334,11014701,11014706,11014709,11014714,11014717,11014722,11036244,11069487,11069492,11069494,11069500,11069503,11069505,11085735,11085740,11085743,11122155,11122160,11122163,11122168,11122171,11122176,11140288,11140289,11140295,11141171,11170621,11170626,11170629,11170634,11170637,11170642,11186266,11186648,11186653,11186658,11213963,11213968,11213971,11213976,11213979,11213984,11266525,11266530,11266532,11266538,11266541,11266543,11284035,11323285,11323290,11323292,11323298,11323301,11323303,11374982,11374983,11374989,11374993,11374996,11375002,11391972,11418786,11418787,11418793,11418797,11418800,11418806,11464688,11464689,11464695,11464699,11464702,11464708,11513896,11513901,11513906,11513907,11513914,11513917,11530204,11531576,11531581,11531586,11556998,11557003,11557008,11557009,11557016,11557019,11600558,11600563,11600568,11600569,11600576,11600579,11649626,11649631,11649636,11649637,11649644,11649647,11667134,11667135,11667141,11671725,11671730,11671732,11671738,11671741,11671743,11739145,11739150,11739155,11739156,11739163,11739166,11786979,11786984,11786989,11786990,11786997,11787000,11837217,11837222,11837227,11837228,11837235,11837238,11868919,11868924,11868929,11868930,11868937,11868940,11924183,11924188,11924193,11924194,11924201,11924204,11964241,11964246,11964251,11964252,11964259,11964262,12004173,12004178,12004183,12004184,12004191,12004194,12021482,12021487,12021489,12045618,12045623,12045625,12045631,12045634,12045636,12084811,12084816,12084821,12084822,12084829,12084832,12101963,12101964,12101970,20116,20117,20123,20127,20130,20136,71660,71661,71667,71671,71674,71680,85608,111868,111869,111875,111879,111882,111888,126206,127042,127047,127052,158431,158436,158438,158444,158447,158449,192798,192803,192808,192809,192816,192819,210106,210984,210989,210994,232304,232305,232311,232315,232318,232324,247349,248200,248205,248210,249075,249213,249768,273233,273238,273241,273246,273249,273254,312649,312654,312656,312662,312665,312667,331804,357217,357222,357224,357230,357233,357235,372006,372844,372849,372854) ) 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` = 41897 WHERE `RP`.`player` = 41897 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125218,126317,128989,130010,204149,206053,209585,209668,246952,246953,246959,250362,250965,251096,280801,280806,280809,280814,280817,280822,303573,303578,303581,338111,338116,338119,338124,338127,338132,10398139,10398144,10398147,10398152,10398155,10398160,10479102,10479108,10479111,10479116,10479119,10479121,10513329,10513334,10513337,10514095,10542251,10542256,10542259,10542264,10542267,10542272,10567342,10604411,10604416,10604419,10604424,10604427,10604432,10637418,10639562,10639563,10639569,10640807,10662853,10662858,10662861,10662866,10662869,10662874,10691381,10691386,10691389,10692375,10692491,10693163,10726435,10726440,10726443,10726448,10726451,10726456,10796725,10796730,10796733,10796738,10796741,10796746,10826268,10826269,10826275,10826547,10826632,10827308,10876411,10876416,10876419,10876424,10876427,10876432,10892866,10893748,10893749,10893755,10919903,10919908,10919911,10919916,10919919,10919924,10964337,10964342,10964345,10964350,10964353,10964358,10981502,10982992,10982993,10982999,10983334,11014701,11014706,11014709,11014714,11014717,11014722,11036244,11069487,11069492,11069494,11069500,11069503,11069505,11085735,11085740,11085743,11122155,11122160,11122163,11122168,11122171,11122176,11140288,11140289,11140295,11141171,11170621,11170626,11170629,11170634,11170637,11170642,11186266,11186648,11186653,11186658,11213963,11213968,11213971,11213976,11213979,11213984,11266525,11266530,11266532,11266538,11266541,11266543,11284035,11323285,11323290,11323292,11323298,11323301,11323303,11374982,11374983,11374989,11374993,11374996,11375002,11391972,11418786,11418787,11418793,11418797,11418800,11418806,11464688,11464689,11464695,11464699,11464702,11464708,11513896,11513901,11513906,11513907,11513914,11513917,11530204,11531576,11531581,11531586,11556998,11557003,11557008,11557009,11557016,11557019,11600558,11600563,11600568,11600569,11600576,11600579,11649626,11649631,11649636,11649637,11649644,11649647,11667134,11667135,11667141,11671725,11671730,11671732,11671738,11671741,11671743,11739145,11739150,11739155,11739156,11739163,11739166,11786979,11786984,11786989,11786990,11786997,11787000,11837217,11837222,11837227,11837228,11837235,11837238,11868919,11868924,11868929,11868930,11868937,11868940,11924183,11924188,11924193,11924194,11924201,11924204,11964241,11964246,11964251,11964252,11964259,11964262,12004173,12004178,12004183,12004184,12004191,12004194,12021482,12021487,12021489,12045618,12045623,12045625,12045631,12045634,12045636,12084811,12084816,12084821,12084822,12084829,12084832,12101963,12101964,12101970,20116,20117,20123,20127,20130,20136,71660,71661,71667,71671,71674,71680,85608,111868,111869,111875,111879,111882,111888,126206,127042,127047,127052,158431,158436,158438,158444,158447,158449,192798,192803,192808,192809,192816,192819,210106,210984,210989,210994,232304,232305,232311,232315,232318,232324,247349,248200,248205,248210,249075,249213,249768,273233,273238,273241,273246,273249,273254,312649,312654,312656,312662,312665,312667,331804,357217,357222,357224,357230,357233,357235,372006,372844,372849,372854) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: