| Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | | Официальные матчи сборных | 26 | 1 | 3 | 46 | 312 | 67 | 82 | 8 | 6.62 | 0 |
| Национальная сборная | 21 | 1 | 3 | 35 | 225 | 55 | 61 | 7 | 6.76 | 0 |
| Отборочный турнир | 17 | 0 | 2 | 30 | 183 | 40 | 49 | 3 | 6.68 | 0 |
| Финальный турнир | 4 | 1 | 1 | 5 | 42 | 15 | 12 | 4 | 7.12 | 0 |
| Молодежная сборная | 5 | 0 | 0 | 11 | 87 | 12 | 21 | 1 | 6.00 | 0 |
| Отборочный турнир | 5 | 0 | 0 | 11 | 87 | 12 | 21 | 1 | 6.00 | 0 |
| Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
| ТОВЫ сборных | 19 | 0 | 1 | 29 | 258 | 42 | 78 | 3 | 6.47 | 0 |
| Всего за сборные | 45 | 1 | 4 | 75 | 570 | 109 | 160 | 11 | 6.56 | 0 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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(207) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 1014 WHERE `RP`.`player` = 1014 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (303515,303520,303522,303663,304764,305238,10370782,10370787,10370792,10371772,10372466,10372529,10513306,10513311,10513316,10826195,10826200,10826202,10826537,10893736,10893737,10893743,10893996,10938005,10938010,10938013,10939487,10940487,10941593,10982942,10982947,10982952,10983329,11038315,11038320,11038323,11038762,11140261,11140266,11140269,11141178,11141801,11141977,11186623,11186628,11186631,11188239,11229577,11229582,11229585,11230822,11434168,11434169,11434175,11574716,11574721,11574726,11575580,11618450,11618451,11618457,11619494,11667085,11667090,11667092,86422,86423,86429,87278,333256,333257,333263,333570) ) 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(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` = 1014 WHERE `RP`.`player` = 1014 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (303515,303520,303522,303663,304764,305238,10370782,10370787,10370792,10371772,10372466,10372529,10513306,10513311,10513316,10826195,10826200,10826202,10826537,10893736,10893737,10893743,10893996,10938005,10938010,10938013,10939487,10940487,10941593,10982942,10982947,10982952,10983329,11038315,11038320,11038323,11038762,11140261,11140266,11140269,11141178,11141801,11141977,11186623,11186628,11186631,11188239,11229577,11229582,11229585,11230822,11434168,11434169,11434175,11574716,11574721,11574726,11575580,11618450,11618451,11618457,11619494,11667085,11667090,11667092,86422,86423,86429,87278,333256,333257,333263,333570) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}:
ГЛАВНАЯ
