Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Сэйвы | Оц | Мин | Официальные матчи сборных | 1 | 0 | 0 | 2 | 7 | 0 | 0 | 1 | 7.00 | 0 |
Национальная сборная | 1 | 0 | 0 | 2 | 7 | 0 | 0 | 1 | 7.00 | 0 |
Отборочный турнир | 1 | 0 | 0 | 2 | 7 | 0 | 0 | 1 | 7.00 | 0 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Отборочный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
ТОВЫ сборных | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Всего за сборные | 1 | 0 | 0 | 2 | 7 | 0 | 0 | 1 | 7.00 | 0 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Сэйвы | Оц | Мин |
(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(140) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 3441 WHERE `RP`.`player` = 3441 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125175,126365,128126,129033,130276,204104,206101,209388,209631,209718,280587,280589,280596,280599,280602,280608,338592,338598,338601,338606,338609,338611,10398480,10398486,10398489,10398494,10398497,10398499,10440287,10479438,10479444,10479447,10479452,10479455,10479457,10542036,10542042,10542045,10542050,10542053,10542055,10567357,10604700,10604706,10604709,10604714,10604717,10604719,10637427,10663046,10663052,10663055,10663060,10663063,10663065,10726149,10726151,10726158,10726161,10726164,10726170,10797087,10797089,10797096,10797099,10797102,10797108,10876652,10876658,10876661,10876666,10876669,10876671,10892856,10919664,10919670,10919673,10919678,10919681,10919683,10936984,10964676,10964682,10964685,10964690,10964693,10964695,11014991,11014996,11014998,11015004,11015007,11015009,11069224,11069225,11069231,11069235,11069238,11069244,11122252,11122257,11122262,11122263,11122270,11122273,11170286,11170291,11170296,11170297,11170304,11170307,11214156,11214161,11214166,11214167,11214174,11214177,11266931,11266936,11266939,11266944,11266947,11266952,11284029,11322971,11322976,11322979,11322984,11322987,11322992,11374595,11374600,11374603,11374608,11374611,11374616,11418327,11418332,11418335,11418340,11418343,11418348,11464493,11464498,11464501,11464506,11464509,11464514,11479155,11513487,11513492,11513495,11513500,11513503,11513508,11556757,11556762,11556765,11556770,11556773,11556778,11600511,11600516,11600518,11600524,11600527,11600529,11616917,11649195,11649200,11649202,11649208,11649211,11649213,11671342,11671343,11671349,11671353,11671356,11671362,11711126,11738979,11738980,11738986,11738990,11738993,11738999,11756957,11786813,11786814,11786820,11786824,11786827,11786833,11805207,11836762,11836767,11836769,11836775,11836778,11836780,11868608,11868613,11868615,11868621,11868624,11868626,11895842,11923752,11923757,11923759,11923765,11923768,11923770,11963931,11963932,11963938,11963942,11963945,11963951,12004055,12004056,12004062,12004066,12004069,12004075,12045258,12045263,12045265,12045271,12045274,12045276,12084498,12084503,12084506,12084511,12084514,12084519,19873,19878,19881,19886,19889,19894,71513,71518,71521,71526,71529,71534,85602,111457,111462,111465,111470,111473,111478,158237,158242,158245,158250,158253,158258,192557,192562,192565,192570,192573,192578,232661,232666,232669,232674,232677,232682,272969,272974,272977,272982,272985,272990,288002,312215,312220,312223,312228,312231,312236,357025,357030,357032,357038,357041,357043) ) 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(140) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 3441 WHERE `RP`.`player` = 3441 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125175,126365,128126,129033,130276,204104,206101,209388,209631,209718,280587,280589,280596,280599,280602,280608,338592,338598,338601,338606,338609,338611,10398480,10398486,10398489,10398494,10398497,10398499,10440287,10479438,10479444,10479447,10479452,10479455,10479457,10542036,10542042,10542045,10542050,10542053,10542055,10567357,10604700,10604706,10604709,10604714,10604717,10604719,10637427,10663046,10663052,10663055,10663060,10663063,10663065,10726149,10726151,10726158,10726161,10726164,10726170,10797087,10797089,10797096,10797099,10797102,10797108,10876652,10876658,10876661,10876666,10876669,10876671,10892856,10919664,10919670,10919673,10919678,10919681,10919683,10936984,10964676,10964682,10964685,10964690,10964693,10964695,11014991,11014996,11014998,11015004,11015007,11015009,11069224,11069225,11069231,11069235,11069238,11069244,11122252,11122257,11122262,11122263,11122270,11122273,11170286,11170291,11170296,11170297,11170304,11170307,11214156,11214161,11214166,11214167,11214174,11214177,11266931,11266936,11266939,11266944,11266947,11266952,11284029,11322971,11322976,11322979,11322984,11322987,11322992,11374595,11374600,11374603,11374608,11374611,11374616,11418327,11418332,11418335,11418340,11418343,11418348,11464493,11464498,11464501,11464506,11464509,11464514,11479155,11513487,11513492,11513495,11513500,11513503,11513508,11556757,11556762,11556765,11556770,11556773,11556778,11600511,11600516,11600518,11600524,11600527,11600529,11616917,11649195,11649200,11649202,11649208,11649211,11649213,11671342,11671343,11671349,11671353,11671356,11671362,11711126,11738979,11738980,11738986,11738990,11738993,11738999,11756957,11786813,11786814,11786820,11786824,11786827,11786833,11805207,11836762,11836767,11836769,11836775,11836778,11836780,11868608,11868613,11868615,11868621,11868624,11868626,11895842,11923752,11923757,11923759,11923765,11923768,11923770,11963931,11963932,11963938,11963942,11963945,11963951,12004055,12004056,12004062,12004066,12004069,12004075,12045258,12045263,12045265,12045271,12045274,12045276,12084498,12084503,12084506,12084511,12084514,12084519,19873,19878,19881,19886,19889,19894,71513,71518,71521,71526,71529,71534,85602,111457,111462,111465,111470,111473,111478,158237,158242,158245,158250,158253,158258,192557,192562,192565,192570,192573,192578,232661,232666,232669,232674,232677,232682,272969,272974,272977,272982,272985,272990,288002,312215,312220,312223,312228,312231,312236,357025,357030,357032,357038,357041,357043) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: