Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 15 | 3 | 2 | 2 | 229 | 111 | 0 | 12 | 6.93 | 1011 |
Национальная сборная | 3 | 3 | 0 | 0 | 12 | 7 | 0 | 7 | 7.17 | 157 |
Отборочный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Финальный турнир | 3 | 3 | 0 | 0 | 12 | 7 | 0 | 7 | 7.17 | 157 |
Молодежная сборная | 12 | 0 | 2 | 2 | 217 | 104 | 0 | 5 | 6.88 | 854 |
Отборочный турнир | 8 | 0 | 1 | 1 | 169 | 86 | 0 | 5 | 7.00 | 699 |
Финальный турнир | 4 | 0 | 1 | 1 | 48 | 18 | 0 | 0 | 6.62 | 155 |
ТОВЫ сборных | 20 | 6 | 1 | 2 | 369 | 110 | 0 | 14 | 6.80 | 1290 |
Всего за сборные | 35 | 9 | 3 | 4 | 598 | 221 | 0 | 26 | 6.86 | 2301 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 74941 WHERE `RP`.`player` = 74941 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (246878,246883,246888,250352,10441236,10441237,10441243,10442085,10442246,10443321,10513283,10513288,10513290,10514087,10514362,10514499,10569198,10569203,10569208,10570035,10570141,10570554,10982943,10982948,10982950,11186636,11186641,11186646,11229603,11229608,11229610,11230827,11231871,11232730,11339751,11339756,11339758,11340351,11340452,11341832,11392933,11392938,11392940,11394292,11434153,11434158,11434161,11435328,11481176,11481177,11481183,11481631,11481768,11481866,11531551,11531556,11531559,11574741,11574746,11574748,11618473,11618478,11618480,11853430,11853435,11853437,11854425,11940878,11940883,11940885,11942511,11942650,11942744,11980440,11980445,11980447,12061916,12061921,12061923,12101927,12101928,12101934,210912,210917,210922,212520,248117,248122,248124,249068,288825,288830,288833,289785,290021,290577,333241,333246,333249,333569,334619,334995,372771,372776,372779,373742,374295,374530) ) 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` = 74941 WHERE `RP`.`player` = 74941 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (246878,246883,246888,250352,10441236,10441237,10441243,10442085,10442246,10443321,10513283,10513288,10513290,10514087,10514362,10514499,10569198,10569203,10569208,10570035,10570141,10570554,10982943,10982948,10982950,11186636,11186641,11186646,11229603,11229608,11229610,11230827,11231871,11232730,11339751,11339756,11339758,11340351,11340452,11341832,11392933,11392938,11392940,11394292,11434153,11434158,11434161,11435328,11481176,11481177,11481183,11481631,11481768,11481866,11531551,11531556,11531559,11574741,11574746,11574748,11618473,11618478,11618480,11853430,11853435,11853437,11854425,11940878,11940883,11940885,11942511,11942650,11942744,11980440,11980445,11980447,12061916,12061921,12061923,12101927,12101928,12101934,210912,210917,210922,212520,248117,248122,248124,249068,288825,288830,288833,289785,290021,290577,333241,333246,333249,333569,334619,334995,372771,372776,372779,373742,374295,374530) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: