Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 30 | 13 | 1 | 6 | 240 | 121 | 2 | 45 | 6.75 | 2155 |
Национальная сборная | 16 | 5 | 1 | 2 | 121 | 54 | 2 | 18 | 6.59 | 1008 |
Отборочный турнир | 14 | 5 | 1 | 2 | 111 | 51 | 2 | 17 | 6.75 | 916 |
Финальный турнир | 2 | 0 | 0 | 0 | 10 | 3 | 0 | 1 | 5.50 | 92 |
Молодежная сборная | 14 | 8 | 0 | 4 | 119 | 67 | 0 | 27 | 6.93 | 1147 |
Отборочный турнир | 8 | 3 | 0 | 3 | 65 | 38 | 0 | 15 | 6.69 | 657 |
Финальный турнир | 6 | 5 | 0 | 1 | 54 | 29 | 0 | 12 | 7.25 | 490 |
ТОВЫ сборных | 52 | 38 | 3 | 7 | 568 | 161 | 0 | 95 | 7.21 | 3945 |
Всего за сборные | 82 | 51 | 4 | 13 | 808 | 282 | 2 | 140 | 7.04 | 6100 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 61132 WHERE `RP`.`player` = 61132 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (246901,246906,246909,303539,303544,303546,10370784,10370785,10370791,10441247,10441252,10441254,10639489,10639494,10639496,10691443,10691448,10691450,10692387,10692493,10693168,10893711,10893716,10893718,10893997,10894522,10895368,10937993,10937998,10938001,10939489,10940486,10941588,10982929,10982934,10982937,10983328,11392944,11392949,11392954,11394289,11434155,11434160,11434162,11757801,11757802,11757808,12061941,12061942,12061948,12062554,12062940,12063055,12101914,12101919,12101921,127030,127035,127040,173648,173653,173658,248154,248155,248161,249067,249209,249766,372773,372778,372780) ) 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` = 61132 WHERE `RP`.`player` = 61132 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (246901,246906,246909,303539,303544,303546,10370784,10370785,10370791,10441247,10441252,10441254,10639489,10639494,10639496,10691443,10691448,10691450,10692387,10692493,10693168,10893711,10893716,10893718,10893997,10894522,10895368,10937993,10937998,10938001,10939489,10940486,10941588,10982929,10982934,10982937,10983328,11392944,11392949,11392954,11394289,11434155,11434160,11434162,11757801,11757802,11757808,12061941,12061942,12061948,12062554,12062940,12063055,12101914,12101919,12101921,127030,127035,127040,173648,173653,173658,248154,248155,248161,249067,249209,249766,372773,372778,372780) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: