Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 22 | 0 | 0 | 67 | 313 | 6 | 89 | 0 | 7.07 | 1018 |
Национальная сборная | 13 | 0 | 0 | 51 | 226 | 0 | 55 | 0 | 7.12 | 1018 |
Отборочный турнир | 7 | 0 | 0 | 29 | 129 | 0 | 30 | 0 | 7.00 | 485 |
Финальный турнир | 6 | 0 | 0 | 22 | 97 | 0 | 25 | 0 | 7.25 | 533 |
Молодежная сборная | 9 | 0 | 0 | 16 | 87 | 6 | 34 | 0 | 7.00 | 0 |
Отборочный турнир | 4 | 0 | 0 | 5 | 23 | 2 | 8 | 0 | 6.75 | 0 |
Финальный турнир | 5 | 0 | 0 | 11 | 64 | 4 | 26 | 0 | 7.20 | 0 |
ТОВЫ сборных | 19 | 0 | 0 | 64 | 307 | 5 | 75 | 0 | 7.26 | 728 |
Всего за сборные | 41 | 0 | 0 | 131 | 620 | 11 | 164 | 0 | 7.16 | 1746 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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, 207) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 3361 WHERE `RP`.`player` = 3361 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125182,126373,128132,129039,130285,130656,204113,206109,209394,209637,210916,209723,280634,280640,280643,280648,280651,280653,338473,338475,338482,338485,338488,338494,10370807,10370812,10370814,10398431,10398436,10398439,10398444,10398447,10398452,10479343,10479345,10479352,10479355,10479358,10479364,10513308,10513309,10513315,10542109,10542111,10542118,10542121,10542124,10542130,10569185,10569190,10569193,10570031,10570143,10570547,10604915,10604920,10604923,10604928,10604931,10604936,10663045,10663050,10663053,10663058,10663061,10663066,10690368,10726363,10726368,10726371,10726376,10726379,10726384,10796967,10796969,10796976,10796979,10796982,10796988,10876605,10876607,10876614,10876617,10876620,10876626,10892853,10919760,10919766,10919769,10919774,10919777,10919779,10964652,10964658,10964661,10964666,10964669,10964671,10981484,10982906,10982911,10982916,11014967,11014972,11014974,11014980,11014983,11014985,11069317,11069322,11069325,11069330,11069333,11069338,11085785,11085790,11085792,11087197,11087483,11087618,11122299,11122304,11122307,11122312,11122315,11122320,11139730,11140238,11140243,11140248,11141179,11170261,11170266,11170269,11170274,11170277,11170282,11214086,11214087,11214093,11214097,11214100,11214106,11266742,11266743,11266749,11266753,11266756,11266762,11323046,11323047,11323053,11323057,11323060,11323066,11374764,11374769,11374774,11374775,11374782,11374785,11418424,11418429,11418434,11418435,11418442,11418445,11464374,11464379,11464384,11464385,11464392,11464395,11513704,11513709,11513714,11513715,11513722,11513725,11556734,11556739,11556744,11556745,11556752,11556755,11600270,11600275,11600280,11600281,11600288,11600291,11649218,11649223,11649228,11649229,11649236,11649239,11671244,11671249,11671254,11671255,11671262,11671265,11738977,11738982,11738987,11738988,11738995,11738998,11786643,11786648,11786653,11786654,11786661,11786664,11836929,11836934,11836939,11836940,11836947,11836950,11868679,11868684,11868689,11868690,11868697,11868700,11923799,11923804,11923809,11923810,11923817,11923820,11963929,11963934,11963939,11963940,11963947,11963950,11980404,11980409,11980411,12004102,12004107,12004109,12004115,12004118,12004120,12021330,12021421,12021426,12021431,12021987,12045186,12045191,12045193,12045199,12045202,12045204,12084381,12084382,12084388,12084392,12084395,12084401,20042,20047,20052,20053,20060,20063,71418,71423,71428,71429,71436,71439,86434,86435,86441,87276,111483,111488,111490,111496,111499,111501,158263,158268,158270,158276,158279,158281,172813,192703,192708,192710,192716,192719,192721,210926,210927,210933,212524,232567,232572,232574,232580,232583,232585,248141,248146,248148,249063,249221,249763,273209,273214,273217,273222,273225,273230,288801,288806,288809,289783,312359,312364,312367,312372,312375,312380,331802,357095,357100,357103,357108,357111,357116) ) 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, 207) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 3361 WHERE `RP`.`player` = 3361 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125182,126373,128132,129039,130285,130656,204113,206109,209394,209637,210916,209723,280634,280640,280643,280648,280651,280653,338473,338475,338482,338485,338488,338494,10370807,10370812,10370814,10398431,10398436,10398439,10398444,10398447,10398452,10479343,10479345,10479352,10479355,10479358,10479364,10513308,10513309,10513315,10542109,10542111,10542118,10542121,10542124,10542130,10569185,10569190,10569193,10570031,10570143,10570547,10604915,10604920,10604923,10604928,10604931,10604936,10663045,10663050,10663053,10663058,10663061,10663066,10690368,10726363,10726368,10726371,10726376,10726379,10726384,10796967,10796969,10796976,10796979,10796982,10796988,10876605,10876607,10876614,10876617,10876620,10876626,10892853,10919760,10919766,10919769,10919774,10919777,10919779,10964652,10964658,10964661,10964666,10964669,10964671,10981484,10982906,10982911,10982916,11014967,11014972,11014974,11014980,11014983,11014985,11069317,11069322,11069325,11069330,11069333,11069338,11085785,11085790,11085792,11087197,11087483,11087618,11122299,11122304,11122307,11122312,11122315,11122320,11139730,11140238,11140243,11140248,11141179,11170261,11170266,11170269,11170274,11170277,11170282,11214086,11214087,11214093,11214097,11214100,11214106,11266742,11266743,11266749,11266753,11266756,11266762,11323046,11323047,11323053,11323057,11323060,11323066,11374764,11374769,11374774,11374775,11374782,11374785,11418424,11418429,11418434,11418435,11418442,11418445,11464374,11464379,11464384,11464385,11464392,11464395,11513704,11513709,11513714,11513715,11513722,11513725,11556734,11556739,11556744,11556745,11556752,11556755,11600270,11600275,11600280,11600281,11600288,11600291,11649218,11649223,11649228,11649229,11649236,11649239,11671244,11671249,11671254,11671255,11671262,11671265,11738977,11738982,11738987,11738988,11738995,11738998,11786643,11786648,11786653,11786654,11786661,11786664,11836929,11836934,11836939,11836940,11836947,11836950,11868679,11868684,11868689,11868690,11868697,11868700,11923799,11923804,11923809,11923810,11923817,11923820,11963929,11963934,11963939,11963940,11963947,11963950,11980404,11980409,11980411,12004102,12004107,12004109,12004115,12004118,12004120,12021330,12021421,12021426,12021431,12021987,12045186,12045191,12045193,12045199,12045202,12045204,12084381,12084382,12084388,12084392,12084395,12084401,20042,20047,20052,20053,20060,20063,71418,71423,71428,71429,71436,71439,86434,86435,86441,87276,111483,111488,111490,111496,111499,111501,158263,158268,158270,158276,158279,158281,172813,192703,192708,192710,192716,192719,192721,210926,210927,210933,212524,232567,232572,232574,232580,232583,232585,248141,248146,248148,249063,249221,249763,273209,273214,273217,273222,273225,273230,288801,288806,288809,289783,312359,312364,312367,312372,312375,312380,331802,357095,357100,357103,357108,357111,357116) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: