Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 32 | 0 | 0 | 173 | 588 | 11 | 88 | 1 | 7.02 | 2251 |
Национальная сборная | 26 | 0 | 0 | 160 | 488 | 7 | 71 | 1 | 7.17 | 1766 |
Отборочный турнир | 20 | 0 | 0 | 127 | 386 | 5 | 55 | 1 | 7.12 | 1335 |
Финальный турнир | 6 | 0 | 0 | 33 | 102 | 2 | 16 | 0 | 7.33 | 431 |
Молодежная сборная | 6 | 0 | 0 | 13 | 100 | 4 | 17 | 0 | 6.33 | 485 |
Отборочный турнир | 6 | 0 | 0 | 13 | 100 | 4 | 17 | 0 | 6.33 | 485 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
ТОВЫ сборных | 41 | 0 | 3 | 182 | 801 | 16 | 116 | 5 | 6.98 | 2613 |
Всего за сборные | 73 | 0 | 3 | 355 | 1389 | 27 | 204 | 6 | 6.99 | 4864 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 48905 WHERE `RP`.`player` = 48905 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (303502,303507,303512,303666,10370781,10370786,10370789,10441272,10441273,10441279,10569174,10569179,10569184,10570030,10826184,10826185,10826191,10826540,10826637,10827311,10893734,10893739,10893744,11229591,11229596,11229598,11230823,11231877,11232729,11339763,11339768,11339770,11340352,11392955,11392960,11392963,11394287,11434141,11434146,11434149,11481198,11481203,11481208,11531527,11531532,11531535,11531950,11711939,11711944,11711949,11805265,11805270,11805275,11853431,11853432,11853438,12021422,12021427,12021429,12021990,12022383,12022501,12061938,12061943,12061946,12062551,12062942,12063052,12101900,12101905,12101908,12102547,48109,48114,48117,48355,48813,49096,86398,86399,86405,87273,126993,126998,127001,128620,128767,128856,173623,173628,173631,210937,210942,210944,212525,212671,212760,248115,248120,248123,249061,249222,249765) ) 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` = 48905 WHERE `RP`.`player` = 48905 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (303502,303507,303512,303666,10370781,10370786,10370789,10441272,10441273,10441279,10569174,10569179,10569184,10570030,10826184,10826185,10826191,10826540,10826637,10827311,10893734,10893739,10893744,11229591,11229596,11229598,11230823,11231877,11232729,11339763,11339768,11339770,11340352,11392955,11392960,11392963,11394287,11434141,11434146,11434149,11481198,11481203,11481208,11531527,11531532,11531535,11531950,11711939,11711944,11711949,11805265,11805270,11805275,11853431,11853432,11853438,12021422,12021427,12021429,12021990,12022383,12022501,12061938,12061943,12061946,12062551,12062942,12063052,12101900,12101905,12101908,12102547,48109,48114,48117,48355,48813,49096,86398,86399,86405,87273,126993,126998,127001,128620,128767,128856,173623,173628,173631,210937,210942,210944,212525,212671,212760,248115,248120,248123,249061,249222,249765) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: