Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Сэйвы | Оц | Мин | Официальные матчи сборных | 30 | 0 | 0 | 4 | 152 | 0 | 0 | 168 | 7.75 | 2788 |
Национальная сборная | 18 | 0 | 0 | 3 | 82 | 0 | 0 | 95 | 7.94 | 1663 |
Отборочный турнир | 17 | 0 | 0 | 3 | 80 | 0 | 0 | 92 | 7.97 | 1570 |
Финальный турнир | 1 | 0 | 0 | 0 | 2 | 0 | 0 | 3 | 7.50 | 93 |
Молодежная сборная | 12 | 0 | 0 | 1 | 70 | 0 | 0 | 73 | 7.46 | 1125 |
Отборочный турнир | 9 | 0 | 0 | 0 | 55 | 0 | 0 | 60 | 7.67 | 821 |
Финальный турнир | 3 | 0 | 0 | 1 | 15 | 0 | 0 | 13 | 6.83 | 304 |
ТОВЫ сборных | 27 | 0 | 0 | 1 | 145 | 0 | 0 | 113 | 7.44 | 2406 |
Всего за сборные | 57 | 0 | 0 | 5 | 297 | 0 | 0 | 281 | 7.61 | 5194 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Сэйвы | Оц | Мин |
(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` = 48097 WHERE `RP`.`player` = 48097 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (246889,246894,246897,250353,250961,251092,10370769,10370774,10370777,10371771,10441269,10441274,10441277,10442091,10442243,10443328,10639511,10639516,10639519,10640815,10691429,10691434,10691437,10826183,10826188,10826190,10826533,10826636,10827306,10982918,10982923,10982928,11038329,11038334,11038336,11038759,11038880,11038978,11140249,11140254,11140257,11141180,11141800,11141972,11186599,11186604,11186607,11188237,11188364,11188467,11286151,11286156,11286159,11286592,11339773,11339778,11339781,11392931,11392936,11392939,11394285,11481174,11481179,11481184,11805255,11805256,11805262,11806995,11896651,11896656,11896661,11896913,11940841,11940846,11940851,11942508,11980439,11980444,11980449,11981353,12021420,12021425,12021428,12061914,12061919,12061922,12062552,12062941,12063053,12101890,12101895,12101897,12102553,12103518,12103697,86407,86412,86415,127007,127012,127014,173647,173652,173655,210925,210930,210932,248129,248134,248136,288827,288832,288834,333243,333248,333250,372785,372790,372792) ) 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` = 48097 WHERE `RP`.`player` = 48097 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (246889,246894,246897,250353,250961,251092,10370769,10370774,10370777,10371771,10441269,10441274,10441277,10442091,10442243,10443328,10639511,10639516,10639519,10640815,10691429,10691434,10691437,10826183,10826188,10826190,10826533,10826636,10827306,10982918,10982923,10982928,11038329,11038334,11038336,11038759,11038880,11038978,11140249,11140254,11140257,11141180,11141800,11141972,11186599,11186604,11186607,11188237,11188364,11188467,11286151,11286156,11286159,11286592,11339773,11339778,11339781,11392931,11392936,11392939,11394285,11481174,11481179,11481184,11805255,11805256,11805262,11806995,11896651,11896656,11896661,11896913,11940841,11940846,11940851,11942508,11980439,11980444,11980449,11981353,12021420,12021425,12021428,12061914,12061919,12061922,12062552,12062941,12063053,12101890,12101895,12101897,12102553,12103518,12103697,86407,86412,86415,127007,127012,127014,173647,173652,173655,210925,210930,210932,248129,248134,248136,288827,288832,288834,333243,333248,333250,372785,372790,372792) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: