Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 12 | 0 | 0 | 85 | 131 | 1 | 20 | 2 | 6.79 | 1071 |
Национальная сборная | 3 | 0 | 0 | 12 | 17 | 0 | 6 | 2 | 7.00 | 276 |
Отборочный турнир | 3 | 0 | 0 | 12 | 17 | 0 | 6 | 2 | 7.00 | 276 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 9 | 0 | 0 | 73 | 114 | 1 | 14 | 0 | 6.72 | 795 |
Отборочный турнир | 5 | 0 | 0 | 45 | 67 | 1 | 9 | 0 | 6.80 | 425 |
Финальный турнир | 4 | 0 | 0 | 28 | 47 | 0 | 5 | 0 | 6.62 | 370 |
ТОВЫ сборных | 15 | 0 | 0 | 122 | 243 | 4 | 36 | 2 | 7.10 | 1376 |
Всего за сборные | 27 | 0 | 0 | 207 | 374 | 5 | 56 | 4 | 6.96 | 2447 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 73586 WHERE `RP`.`player` = 73586 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125236,126337,128186,129005,130036,204169,206073,209448,209603,209694,280971,280973,280980,280983,280986,280992,338186,338189,338192,338195,338202,338205,10369062,10398310,10398313,10398316,10398319,10398326,10398329,10440271,10479056,10479059,10479062,10479065,10479072,10479075,10542277,10542279,10542286,10542289,10542292,10542298,10604534,10604537,10604540,10604543,10604550,10604553,10662760,10662763,10662766,10662769,10662776,10662779,10726486,10726489,10726492,10726495,10726502,10726505,10796728,10796731,10796734,10796737,10796744,10796747,10876366,10876369,10876372,10876375,10876382,10876385,10919954,10919957,10919960,10919963,10919970,10919973,10964268,10964271,10964274,10964277,10964284,10964287,10981500,11014776,11014777,11014783,11014787,11014790,11014796,11069486,11069491,11069496,11069497,11069504,11069507,11122108,11122113,11122118,11122119,11122126,11122129,11170478,11170483,11170488,11170489,11170496,11170499,11213724,11213729,11213734,11213735,11213742,11213745,11266620,11266625,11266630,11266631,11266638,11266641,11323212,11323217,11323222,11323223,11323230,11323233,11337858,11374788,11374793,11374798,11374799,11374806,11374809,11418784,11418789,11418794,11418795,11418802,11418805,11433522,11464808,11464809,11464815,11464819,11464822,11464828,11513920,11513925,11513930,11513931,11513938,11513941,11556974,11556979,11556984,11556985,11556992,11556995,11600582,11600587,11600592,11600593,11600600,11600603,11649410,11649415,11649420,11649421,11649428,11649431,11671700,11671705,11671710,11671711,11671718,11671721,11711134,11739218,11739223,11739225,11739231,11739234,11739236,11786860,11786865,11786867,11786873,11786876,11786878,11837267,11837268,11837274,11837278,11837281,11837287,11868968,11868973,11868975,11868981,11868984,11868986,11895853,11924086,11924091,11924094,11924099,11924102,11924107,11964048,11964053,11964056,11964061,11964064,11964069,12004343,12004344,12004350,12004354,12004357,12004363,12045571,12045572,12045578,12045582,12045585,12045591,12084788,12084793,12084795,12084801,12084804,12084806,20257,20262,20265,20270,20273,20278,71729,71734,71737,71742,71745,71750,111891,111896,111898,111904,111907,111909,158598,158603,158608,158609,158616,158619,192846,192851,192856,192857,192864,192867,232398,232403,232408,232409,232416,232419,247353,273380,273381,273387,273391,273394,273400,312648,312653,312658,312659,312666,312669,357336,357341,357346,357347,357354,357357) ) 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` = 73586 WHERE `RP`.`player` = 73586 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125236,126337,128186,129005,130036,204169,206073,209448,209603,209694,280971,280973,280980,280983,280986,280992,338186,338189,338192,338195,338202,338205,10369062,10398310,10398313,10398316,10398319,10398326,10398329,10440271,10479056,10479059,10479062,10479065,10479072,10479075,10542277,10542279,10542286,10542289,10542292,10542298,10604534,10604537,10604540,10604543,10604550,10604553,10662760,10662763,10662766,10662769,10662776,10662779,10726486,10726489,10726492,10726495,10726502,10726505,10796728,10796731,10796734,10796737,10796744,10796747,10876366,10876369,10876372,10876375,10876382,10876385,10919954,10919957,10919960,10919963,10919970,10919973,10964268,10964271,10964274,10964277,10964284,10964287,10981500,11014776,11014777,11014783,11014787,11014790,11014796,11069486,11069491,11069496,11069497,11069504,11069507,11122108,11122113,11122118,11122119,11122126,11122129,11170478,11170483,11170488,11170489,11170496,11170499,11213724,11213729,11213734,11213735,11213742,11213745,11266620,11266625,11266630,11266631,11266638,11266641,11323212,11323217,11323222,11323223,11323230,11323233,11337858,11374788,11374793,11374798,11374799,11374806,11374809,11418784,11418789,11418794,11418795,11418802,11418805,11433522,11464808,11464809,11464815,11464819,11464822,11464828,11513920,11513925,11513930,11513931,11513938,11513941,11556974,11556979,11556984,11556985,11556992,11556995,11600582,11600587,11600592,11600593,11600600,11600603,11649410,11649415,11649420,11649421,11649428,11649431,11671700,11671705,11671710,11671711,11671718,11671721,11711134,11739218,11739223,11739225,11739231,11739234,11739236,11786860,11786865,11786867,11786873,11786876,11786878,11837267,11837268,11837274,11837278,11837281,11837287,11868968,11868973,11868975,11868981,11868984,11868986,11895853,11924086,11924091,11924094,11924099,11924102,11924107,11964048,11964053,11964056,11964061,11964064,11964069,12004343,12004344,12004350,12004354,12004357,12004363,12045571,12045572,12045578,12045582,12045585,12045591,12084788,12084793,12084795,12084801,12084804,12084806,20257,20262,20265,20270,20273,20278,71729,71734,71737,71742,71745,71750,111891,111896,111898,111904,111907,111909,158598,158603,158608,158609,158616,158619,192846,192851,192856,192857,192864,192867,232398,232403,232408,232409,232416,232419,247353,273380,273381,273387,273391,273394,273400,312648,312653,312658,312659,312666,312669,357336,357341,357346,357347,357354,357357) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: