Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 35 | 0 | 0 | 287 | 555 | 4 | 56 | 1 | 7.17 | 3204 |
Национальная сборная | 17 | 0 | 0 | 123 | 252 | 3 | 21 | 1 | 6.94 | 1549 |
Отборочный турнир | 17 | 0 | 0 | 123 | 252 | 3 | 21 | 1 | 6.94 | 1549 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 18 | 0 | 0 | 164 | 303 | 1 | 35 | 0 | 7.39 | 1655 |
Отборочный турнир | 12 | 0 | 0 | 101 | 202 | 1 | 24 | 0 | 7.33 | 1104 |
Финальный турнир | 6 | 0 | 0 | 63 | 101 | 0 | 11 | 0 | 7.50 | 551 |
ТОВЫ сборных | 27 | 0 | 0 | 217 | 416 | 4 | 43 | 0 | 7.15 | 2345 |
Всего за сборные | 62 | 0 | 0 | 504 | 971 | 8 | 99 | 1 | 7.16 | 5549 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 72212 WHERE `RP`.`player` = 72212 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125185,126372,128131,129040,130661,131992,204114,206110,209391,209562,209640,210919,280444,280447,280450,280453,280460,280463,338522,338525,338528,338531,338538,338541,10398386,10398389,10398392,10398395,10398402,10398405,10479368,10479371,10479374,10479377,10479384,10479387,10541942,10541945,10541948,10541951,10541958,10541961,10604822,10604825,10604828,10604831,10604838,10604841,10663096,10663099,10663102,10663105,10663112,10663115,10690370,10726270,10726273,10726276,10726279,10726286,10726289,10758444,10758445,10758451,10797040,10797043,10797046,10797049,10797056,10797059,10876534,10876537,10876540,10876543,10876550,10876553,10919786,10919789,10919792,10919795,10919802,10919805,10936992,10964606,10964609,10964612,10964615,10964622,10964625,10982932,10982933,10982939,11015040,11015041,11015047,11015051,11015054,11015060,11036236,11038328,11038333,11038338,11069343,11069348,11069350,11069356,11069359,11069361,11122325,11122330,11122332,11122338,11122341,11122343,11170384,11170385,11170391,11170395,11170398,11170404,11214158,11214159,11214165,11214169,11214172,11214178,11266790,11266791,11266797,11266801,11266804,11266810,11323164,11323169,11323174,11323175,11323182,11323185,11337866,11339738,11339743,11339748,11340354,11374669,11374674,11374676,11374682,11374685,11374687,11392957,11392962,11392964,11418351,11418356,11418359,11418364,11418367,11418372,11434167,11434172,11434174,11435326,11464301,11464306,11464309,11464314,11464317,11464322,11481187,11481192,11481194,11481629,11513727,11513732,11513735,11513740,11513743,11513748,11530195,11531528,11531533,11531538,11556637,11556642,11556645,11556650,11556653,11556658,11574706,11574707,11574713,11600271,11600276,11600278,11600284,11600287,11600289,11616916,11649267,11649272,11649274,11649280,11649283,11649285,11667097,11667102,11667104,11671389,11671394,11671396,11671402,11671405,11671407,11711125,11711951,11711956,11711961,11738883,11738884,11738890,11738894,11738897,11738903,11757776,11757781,11757783,11758747,11786764,11786769,11786771,11786777,11786780,11786782,11805231,11805232,11805238,11806990,11807251,11807850,11836832,11836837,11836840,11836845,11836848,11836853,11853404,11853409,11853412,11868750,11868755,11868758,11868763,11868766,11868771,11895836,11896687,11896692,11896697,11923776,11923781,11923783,11923789,11923792,11923794,11939998,11963738,11963743,11963745,11963751,11963754,11963756,12004127,12004128,12004134,12004138,12004141,12004147,12045113,12045118,12045123,12045124,12045131,12045134,12061928,12061933,12061935,12062553,12084524,12084529,12084531,12084537,12084540,12084542,19924,19925,19931,19935,19938,19944,71490,71495,71500,71501,71508,71511,111532,111533,111539,111543,111546,111552,158286,158291,158296,158297,158304,158307,192632,192633,192639,192643,192646,192652,232494,232499,232504,232505,232512,232515,273186,273191,273196,273197,273204,273207,312314,312315,312321,312325,312328,312334,357024,357029,357034,357035,357042,357045,372798,372799,372805) ) 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` = 72212 WHERE `RP`.`player` = 72212 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125185,126372,128131,129040,130661,131992,204114,206110,209391,209562,209640,210919,280444,280447,280450,280453,280460,280463,338522,338525,338528,338531,338538,338541,10398386,10398389,10398392,10398395,10398402,10398405,10479368,10479371,10479374,10479377,10479384,10479387,10541942,10541945,10541948,10541951,10541958,10541961,10604822,10604825,10604828,10604831,10604838,10604841,10663096,10663099,10663102,10663105,10663112,10663115,10690370,10726270,10726273,10726276,10726279,10726286,10726289,10758444,10758445,10758451,10797040,10797043,10797046,10797049,10797056,10797059,10876534,10876537,10876540,10876543,10876550,10876553,10919786,10919789,10919792,10919795,10919802,10919805,10936992,10964606,10964609,10964612,10964615,10964622,10964625,10982932,10982933,10982939,11015040,11015041,11015047,11015051,11015054,11015060,11036236,11038328,11038333,11038338,11069343,11069348,11069350,11069356,11069359,11069361,11122325,11122330,11122332,11122338,11122341,11122343,11170384,11170385,11170391,11170395,11170398,11170404,11214158,11214159,11214165,11214169,11214172,11214178,11266790,11266791,11266797,11266801,11266804,11266810,11323164,11323169,11323174,11323175,11323182,11323185,11337866,11339738,11339743,11339748,11340354,11374669,11374674,11374676,11374682,11374685,11374687,11392957,11392962,11392964,11418351,11418356,11418359,11418364,11418367,11418372,11434167,11434172,11434174,11435326,11464301,11464306,11464309,11464314,11464317,11464322,11481187,11481192,11481194,11481629,11513727,11513732,11513735,11513740,11513743,11513748,11530195,11531528,11531533,11531538,11556637,11556642,11556645,11556650,11556653,11556658,11574706,11574707,11574713,11600271,11600276,11600278,11600284,11600287,11600289,11616916,11649267,11649272,11649274,11649280,11649283,11649285,11667097,11667102,11667104,11671389,11671394,11671396,11671402,11671405,11671407,11711125,11711951,11711956,11711961,11738883,11738884,11738890,11738894,11738897,11738903,11757776,11757781,11757783,11758747,11786764,11786769,11786771,11786777,11786780,11786782,11805231,11805232,11805238,11806990,11807251,11807850,11836832,11836837,11836840,11836845,11836848,11836853,11853404,11853409,11853412,11868750,11868755,11868758,11868763,11868766,11868771,11895836,11896687,11896692,11896697,11923776,11923781,11923783,11923789,11923792,11923794,11939998,11963738,11963743,11963745,11963751,11963754,11963756,12004127,12004128,12004134,12004138,12004141,12004147,12045113,12045118,12045123,12045124,12045131,12045134,12061928,12061933,12061935,12062553,12084524,12084529,12084531,12084537,12084540,12084542,19924,19925,19931,19935,19938,19944,71490,71495,71500,71501,71508,71511,111532,111533,111539,111543,111546,111552,158286,158291,158296,158297,158304,158307,192632,192633,192639,192643,192646,192652,232494,232499,232504,232505,232512,232515,273186,273191,273196,273197,273204,273207,312314,312315,312321,312325,312328,312334,357024,357029,357034,357035,357042,357045,372798,372799,372805) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: