Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 18 | 0 | 0 | 151 | 425 | 6 | 61 | 4 | 7.08 | 1662 |
Национальная сборная | 8 | 0 | 0 | 70 | 225 | 4 | 39 | 2 | 7.25 | 741 |
Отборочный турнир | 7 | 0 | 0 | 48 | 197 | 3 | 33 | 2 | 7.07 | 648 |
Финальный турнир | 1 | 0 | 0 | 22 | 28 | 1 | 6 | 0 | 8.50 | 93 |
Молодежная сборная | 10 | 0 | 0 | 81 | 200 | 2 | 22 | 2 | 6.95 | 921 |
Отборочный турнир | 6 | 0 | 0 | 53 | 123 | 1 | 13 | 2 | 7.25 | 552 |
Финальный турнир | 4 | 0 | 0 | 28 | 77 | 1 | 9 | 0 | 6.50 | 369 |
ТОВЫ сборных | 21 | 1 | 0 | 115 | 372 | 5 | 63 | 3 | 6.83 | 1407 |
Всего за сборные | 39 | 1 | 0 | 266 | 797 | 11 | 124 | 7 | 6.95 | 3069 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 66532 WHERE `RP`.`player` = 66532 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (10639526,10639527,10639533,10691430,10691435,10691440,10826194,10826199,10826204,10893735,10893740,10893742,10893999,10937983,10937988,10937990,11085749,11085754,11085756,11087191,11140252,11140253,11140259,11339752,11339753,11339759,11392969,11392974,11392976,11394288,11394687,11394851,11574703,11574708,11574711,11575586,11618483,11618488,11618491,11619490,11896689,11896690,11896696,11896912,11896984,11897051,11940877,11940882,11940887,11980415,11980420,11980425,12061926,12061931,12061934,12101915,12101916,12101922,12102551,12103519,12103699,48073,48078,48081,86433,86438,86440,126995,127000,127002,173624,173629,173634,210902,210903,210909,212519,212674,212761,248151,248156,248159) ) 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` = 66532 WHERE `RP`.`player` = 66532 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (10639526,10639527,10639533,10691430,10691435,10691440,10826194,10826199,10826204,10893735,10893740,10893742,10893999,10937983,10937988,10937990,11085749,11085754,11085756,11087191,11140252,11140253,11140259,11339752,11339753,11339759,11392969,11392974,11392976,11394288,11394687,11394851,11574703,11574708,11574711,11575586,11618483,11618488,11618491,11619490,11896689,11896690,11896696,11896912,11896984,11897051,11940877,11940882,11940887,11980415,11980420,11980425,12061926,12061931,12061934,12101915,12101916,12101922,12102551,12103519,12103699,48073,48078,48081,86433,86438,86440,126995,127000,127002,173624,173629,173634,210902,210903,210909,212519,212674,212761,248151,248156,248159) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: