Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 27 | 0 | 0 | 94 | 570 | 32 | 193 | 0 | 6.57 | 712 |
Национальная сборная | 17 | 0 | 0 | 63 | 411 | 7 | 133 | 0 | 7.09 | 712 |
Отборочный турнир | 17 | 0 | 0 | 63 | 411 | 7 | 133 | 0 | 7.09 | 712 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 10 | 0 | 0 | 31 | 159 | 25 | 60 | 0 | 5.70 | 0 |
Отборочный турнир | 5 | 0 | 0 | 9 | 79 | 14 | 20 | 0 | 5.50 | 0 |
Финальный турнир | 5 | 0 | 0 | 22 | 80 | 11 | 40 | 0 | 5.90 | 0 |
ТОВЫ сборных | 31 | 0 | 0 | 107 | 602 | 18 | 180 | 0 | 7.13 | 1458 |
Всего за сборные | 58 | 0 | 0 | 201 | 1172 | 50 | 373 | 0 | 6.87 | 2170 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 33948 WHERE `RP`.`player` = 33948 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (246928,246929,246935,250360,10370733,10370738,10370741,10371756,10372470,10372533,10513355,10513360,10513362,10569114,10569119,10569124,10570037,10570148,10570549,10691396,10691397,10691403,10692379,10692489,10693170,10758455,10758460,10758462,10826244,10826245,10826251,11085736,11085741,11085746,11140287,11140292,11140294,11141168,11141808,11141973,11286093,11286098,11286100,11286599,11667158,11667159,11667165,11757850,11757856,11757849,11758753,11758861,11758947,12021481,12021486,12021491,12022001,86444,86449,86454,87287,248166,248167,248173,249069,249216,249769) ) 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` = 33948 WHERE `RP`.`player` = 33948 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (246928,246929,246935,250360,10370733,10370738,10370741,10371756,10372470,10372533,10513355,10513360,10513362,10569114,10569119,10569124,10570037,10570148,10570549,10691396,10691397,10691403,10692379,10692489,10693170,10758455,10758460,10758462,10826244,10826245,10826251,11085736,11085741,11085746,11140287,11140292,11140294,11141168,11141808,11141973,11286093,11286098,11286100,11286599,11667158,11667159,11667165,11757850,11757856,11757849,11758753,11758861,11758947,12021481,12021486,12021491,12022001,86444,86449,86454,87287,248166,248167,248173,249069,249216,249769) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: