Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 11 | 0 | 0 | 117 | 158 | 1 | 11 | 1 | 7.64 | 1012 |
Национальная сборная | 4 | 0 | 0 | 53 | 74 | 0 | 7 | 1 | 7.50 | 366 |
Отборочный турнир | 4 | 0 | 0 | 53 | 74 | 0 | 7 | 1 | 7.50 | 366 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 7 | 0 | 0 | 64 | 84 | 1 | 4 | 0 | 7.71 | 646 |
Отборочный турнир | 4 | 0 | 0 | 35 | 43 | 0 | 0 | 0 | 7.75 | 369 |
Финальный турнир | 3 | 0 | 0 | 29 | 41 | 1 | 4 | 0 | 7.67 | 277 |
ТОВЫ сборных | 17 | 0 | 0 | 142 | 227 | 1 | 14 | 2 | 7.12 | 1442 |
Всего за сборные | 28 | 0 | 0 | 259 | 385 | 2 | 25 | 3 | 7.32 | 2454 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 78848 WHERE `RP`.`player` = 78848 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (10758468,10758469,10758475,10826232,10826233,10826239,10826548,11140312,11140313,11140319,11229640,11229641,11229647,11230831,11231881,11232733,11434178,11434183,11434188,11435318,11435981,11436210,11481245,11481250,11481253,11481641,11531563,11531568,11531571,11531964,11532589,11532796,11574751,11574756,11574759,11618533,11618538,11618540,11619503,11667132,11667137,11667142,11712011,11712016,11712021,11713176,11713644,11713761,11805278,11805283,11805285,11806989,11807242,11807849,11853452,11853457,11853460,11980462,11980467,11980470,11981343,11981697,11982824,12021492,12021497,12021500,12022002,12022386,12022503,127068,127069,127075,173697,173702,173704,174574,174671,175365,210962,210963,210969,212512) ) 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` = 78848 WHERE `RP`.`player` = 78848 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (10758468,10758469,10758475,10826232,10826233,10826239,10826548,11140312,11140313,11140319,11229640,11229641,11229647,11230831,11231881,11232733,11434178,11434183,11434188,11435318,11435981,11436210,11481245,11481250,11481253,11481641,11531563,11531568,11531571,11531964,11532589,11532796,11574751,11574756,11574759,11618533,11618538,11618540,11619503,11667132,11667137,11667142,11712011,11712016,11712021,11713176,11713644,11713761,11805278,11805283,11805285,11806989,11807242,11807849,11853452,11853457,11853460,11980462,11980467,11980470,11981343,11981697,11982824,12021492,12021497,12021500,12022002,12022386,12022503,127068,127069,127075,173697,173702,173704,174574,174671,175365,210962,210963,210969,212512) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: