(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` = 21339 WHERE `RP`.`player` = 21339 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (246880,246881,246887,303513,303518,303521,303660,304766,305237,10370805,10370810,10370813,10569162,10569167,10569172,10570029,10570144,10570553,10691431,10691436,10691438,10692386,10758417,10758422,10758425,10760382,10760874,10761815,10826205,10826210,10826213,10826538,10826638,10827305,10937981,10937986,10937989,10939492,10982905,10982910,10982913,10983330,10984025,10985560,11038351,11038356,11038359,11038761,11038879,11038974,11085771,11085776,11085779,11087193,11186611,11186616,11186619,11188238,11229565,11229570,11229573,11286177,11286182,11286184,11481186,11481191,11481196,11481632,11667110,11667111,11667117,11667363,11711976,11711981,11711983,11713167,12021445,12021450,12021455,12021989,12022384,12022498,248118,248119,248125) ) 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` = 21339 WHERE `RP`.`player` = 21339 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (246880,246881,246887,303513,303518,303521,303660,304766,305237,10370805,10370810,10370813,10569162,10569167,10569172,10570029,10570144,10570553,10691431,10691436,10691438,10692386,10758417,10758422,10758425,10760382,10760874,10761815,10826205,10826210,10826213,10826538,10826638,10827305,10937981,10937986,10937989,10939492,10982905,10982910,10982913,10983330,10984025,10985560,11038351,11038356,11038359,11038761,11038879,11038974,11085771,11085776,11085779,11087193,11186611,11186616,11186619,11188238,11229565,11229570,11229573,11286177,11286182,11286184,11481186,11481191,11481196,11481632,11667110,11667111,11667117,11667363,11711976,11711981,11711983,11713167,12021445,12021450,12021455,12021989,12022384,12022498,248118,248119,248125) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: