Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 13 | 5 | 0 | 0 | 108 | 36 | 0 | 24 | 6.62 | 987 |
Национальная сборная | 3 | 2 | 0 | 0 | 13 | 3 | 0 | 4 | 6.00 | 204 |
Отборочный турнир | 3 | 2 | 0 | 0 | 13 | 3 | 0 | 4 | 6.00 | 204 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 10 | 3 | 0 | 0 | 95 | 33 | 0 | 20 | 6.80 | 783 |
Отборочный турнир | 8 | 2 | 0 | 0 | 72 | 28 | 0 | 17 | 6.81 | 671 |
Финальный турнир | 2 | 1 | 0 | 0 | 23 | 5 | 0 | 3 | 6.75 | 112 |
ТОВЫ сборных | 10 | 5 | 2 | 3 | 98 | 29 | 0 | 20 | 7.30 | 661 |
Всего за сборные | 23 | 10 | 2 | 3 | 206 | 65 | 0 | 44 | 6.91 | 1648 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 73697 WHERE `RP`.`player` = 73697 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125206,126397,128156,129063,130311,130668,204137,206133,209418,209661,210928,209749,280609,280614,280617,280622,280625,280630,338353,338355,338362,338365,338368,338374,10370808,10370809,10370815,10371774,10398409,10398411,10398418,10398421,10398424,10398430,10440286,10479270,10479276,10479279,10479284,10479287,10479289,10512417,10542157,10542159,10542166,10542169,10542172,10542178,10604894,10604897,10604900,10604903,10604910,10604913,10663071,10663073,10663080,10663083,10663086,10663092,10726150,10726153,10726156,10726159,10726166,10726169,10758419,10758424,10758426,10797038,10797044,10797047,10797052,10797055,10797057,10876724,10876730,10876733,10876738,10876741,10876743,10919689,10919691,10919698,10919701,10919704,10919710,10964605,10964607,10964614,10964617,10964620,10964626,11015136,11015137,11015143,11015147,11015150,11015156,11069366,11069371,11069376,11069377,11069384,11069387,11084872,11122398,11122399,11122405,11122409,11122412,11122418,11170262,11170267,11170272,11170273,11170280,11170283,11214012,11214017,11214022,11214023,11214030,11214033,11229568,11229569,11229575,11266740,11266745,11266750,11266751,11266758,11266761,11323190,11323191,11323197,11323201,11323204,11323210,11337863,11374718,11374719,11374725,11374729,11374732,11374738,11391962,11392932,11392937,11392942,11418281,11418286,11418288,11418294,11418297,11418299,11464351,11464356,11464358,11464364,11464367,11464369,11513730,11513731,11513737,11513741,11513744,11513750,11556664,11556665,11556671,11556675,11556678,11556684,11600416,11600417,11600423,11600427,11600430,11600436,11649338,11649343,11649348,11649349,11649356,11649359,11671270,11671271,11671277,11671281,11671284,11671290,11738953,11738958,11738963,11738964,11738971,11738974,11756952,11786595,11786600,11786605,11786606,11786613,11786616,11836833,11836838,11836843,11836844,11836851,11836854,11868727,11868732,11868737,11868738,11868745,11868748,11923703,11923708,11923713,11923714,11923721,11923724,11963905,11963910,11963915,11963916,11963923,11963926,12004005,12004010,12004015,12004016,12004023,12004026,12021329,12021433,12021438,12021443,12021991,12045139,12045140,12045146,12045150,12045153,12045159,12061905,12061906,12061912,12062555,12084500,12084505,12084507,12084513,12084516,12084518,19971,19976,19978,19984,19987,19989,48076,48077,48083,71444,71445,71451,71455,71458,71464,111554,111559,111564,111565,111572,111575,126197,158216,158217,158223,158227,158230,158236,173649,173654,173656,174566,192487,192492,192494,192500,192503,192505,232591,232596,232598,232604,232607,232609,273212,273213,273219,273223,273226,273232,312290,312291,312297,312301,312304,312310,331796,333254,333259,333264,357050,357051,357057,357061,357064,357070) ) 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` = 73697 WHERE `RP`.`player` = 73697 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125206,126397,128156,129063,130311,130668,204137,206133,209418,209661,210928,209749,280609,280614,280617,280622,280625,280630,338353,338355,338362,338365,338368,338374,10370808,10370809,10370815,10371774,10398409,10398411,10398418,10398421,10398424,10398430,10440286,10479270,10479276,10479279,10479284,10479287,10479289,10512417,10542157,10542159,10542166,10542169,10542172,10542178,10604894,10604897,10604900,10604903,10604910,10604913,10663071,10663073,10663080,10663083,10663086,10663092,10726150,10726153,10726156,10726159,10726166,10726169,10758419,10758424,10758426,10797038,10797044,10797047,10797052,10797055,10797057,10876724,10876730,10876733,10876738,10876741,10876743,10919689,10919691,10919698,10919701,10919704,10919710,10964605,10964607,10964614,10964617,10964620,10964626,11015136,11015137,11015143,11015147,11015150,11015156,11069366,11069371,11069376,11069377,11069384,11069387,11084872,11122398,11122399,11122405,11122409,11122412,11122418,11170262,11170267,11170272,11170273,11170280,11170283,11214012,11214017,11214022,11214023,11214030,11214033,11229568,11229569,11229575,11266740,11266745,11266750,11266751,11266758,11266761,11323190,11323191,11323197,11323201,11323204,11323210,11337863,11374718,11374719,11374725,11374729,11374732,11374738,11391962,11392932,11392937,11392942,11418281,11418286,11418288,11418294,11418297,11418299,11464351,11464356,11464358,11464364,11464367,11464369,11513730,11513731,11513737,11513741,11513744,11513750,11556664,11556665,11556671,11556675,11556678,11556684,11600416,11600417,11600423,11600427,11600430,11600436,11649338,11649343,11649348,11649349,11649356,11649359,11671270,11671271,11671277,11671281,11671284,11671290,11738953,11738958,11738963,11738964,11738971,11738974,11756952,11786595,11786600,11786605,11786606,11786613,11786616,11836833,11836838,11836843,11836844,11836851,11836854,11868727,11868732,11868737,11868738,11868745,11868748,11923703,11923708,11923713,11923714,11923721,11923724,11963905,11963910,11963915,11963916,11963923,11963926,12004005,12004010,12004015,12004016,12004023,12004026,12021329,12021433,12021438,12021443,12021991,12045139,12045140,12045146,12045150,12045153,12045159,12061905,12061906,12061912,12062555,12084500,12084505,12084507,12084513,12084516,12084518,19971,19976,19978,19984,19987,19989,48076,48077,48083,71444,71445,71451,71455,71458,71464,111554,111559,111564,111565,111572,111575,126197,158216,158217,158223,158227,158230,158236,173649,173654,173656,174566,192487,192492,192494,192500,192503,192505,232591,232596,232598,232604,232607,232609,273212,273213,273219,273223,273226,273232,312290,312291,312297,312301,312304,312310,331796,333254,333259,333264,357050,357051,357057,357061,357064,357070) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: