Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 52 | 1 | 1 | 449 | 668 | 6 | 76 | 4 | 7.40 | 4737 |
Национальная сборная | 37 | 0 | 1 | 355 | 498 | 4 | 51 | 0 | 7.53 | 3420 |
Отборочный турнир | 21 | 0 | 1 | 220 | 305 | 3 | 24 | 0 | 7.74 | 1936 |
Финальный турнир | 16 | 0 | 0 | 135 | 193 | 1 | 27 | 0 | 7.25 | 1484 |
Молодежная сборная | 15 | 1 | 0 | 94 | 170 | 2 | 25 | 4 | 7.10 | 1317 |
Отборочный турнир | 10 | 1 | 0 | 63 | 116 | 2 | 15 | 4 | 7.20 | 855 |
Финальный турнир | 5 | 0 | 0 | 31 | 54 | 0 | 10 | 0 | 6.90 | 462 |
ТОВЫ сборных | 28 | 2 | 0 | 224 | 325 | 3 | 44 | 7 | 7.27 | 2465 |
Всего за сборные | 80 | 3 | 1 | 673 | 993 | 9 | 120 | 11 | 7.36 | 7202 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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(208) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 76467 WHERE `RP`.`player` = 76467 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (246939,246944,246946,250361,303552,303553,303559,303667,304770,305251,10370745,10370750,10370753,10371757,10372469,10372531,10569149,10569154,10569157,10893782,10893787,10893792,10893991,10937934,10937939,10937944,10982968,10982969,10982975,11085713,11085718,11085720,11087182,11087490,11087613,11140275,11140280,11140282,11141174,11186683,11186688,11186691,11188248,11229613,11229618,11229621,11230829,11231882,11232727,11339811,11339816,11339818,11340357,11340457,11341833,11481248,11481249,11481255,11531602,11531603,11531609,11667157,11667162,11667164,11667371,11668033,11668172,11712022,11712027,11712030,11713180,11805314,11805319,11805321,11853453,11853458,11853463,11854407,11854678,11855213,11896722,11896727,11896730,11940924,11940929,11940932,11942506,11942652,11942747,12101949,12101954,12101959,12102559,48050,48055,48060,127079,127084,127086,128627,210971,210976,210979,288885,288890,288893,289794,290027,290583,333301,333306,333309,333581,334621,335002,372819,372824,372827,373752) ) 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(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` = 76467 WHERE `RP`.`player` = 76467 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (246939,246944,246946,250361,303552,303553,303559,303667,304770,305251,10370745,10370750,10370753,10371757,10372469,10372531,10569149,10569154,10569157,10893782,10893787,10893792,10893991,10937934,10937939,10937944,10982968,10982969,10982975,11085713,11085718,11085720,11087182,11087490,11087613,11140275,11140280,11140282,11141174,11186683,11186688,11186691,11188248,11229613,11229618,11229621,11230829,11231882,11232727,11339811,11339816,11339818,11340357,11340457,11341833,11481248,11481249,11481255,11531602,11531603,11531609,11667157,11667162,11667164,11667371,11668033,11668172,11712022,11712027,11712030,11713180,11805314,11805319,11805321,11853453,11853458,11853463,11854407,11854678,11855213,11896722,11896727,11896730,11940924,11940929,11940932,11942506,11942652,11942747,12101949,12101954,12101959,12102559,48050,48055,48060,127079,127084,127086,128627,210971,210976,210979,288885,288890,288893,289794,290027,290583,333301,333306,333309,333581,334621,335002,372819,372824,372827,373752) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: