(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` = 47853 WHERE `RP`.`player` = 47853 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (246902,246907,246912,250357,303526,303531,303536,303664,10569199,10569204,10569206,11140262,11140267,11140272,11141181,11286140,11286145,11286150,11286598,11434132,11434133,11434139,11435332,11531554,11531555,11531561,11667074,11667075,11667081,11757775,11757780,11757785,11758740,11758859,11758944,12021423,12021424,12021430,288828,288829,288835,289788) ) 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` = 47853 WHERE `RP`.`player` = 47853 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (246902,246907,246912,250357,303526,303531,303536,303664,10569199,10569204,10569206,11140262,11140267,11140272,11141181,11286140,11286145,11286150,11286598,11434132,11434133,11434139,11435332,11531554,11531555,11531561,11667074,11667075,11667081,11757775,11757780,11757785,11758740,11758859,11758944,12021423,12021424,12021430,288828,288829,288835,289788) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: