(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` = 39863 WHERE `RP`.`player` = 39863 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (303504,303505,303511,10370793,10370798,10370801,10371773,10372465,10372535,10441257,10441262,10441265,10513293,10513298,10513301,10639490,10639491,10639497,10640820,10640939,10641034,10826193,10826198,10826201,10893722,10893727,10893732,10893998,11085772,11085777,11085782,11087196,11087484,11087612,11186626,11186627,11186633,11188242,11286175,11286180,11286183,11286594,11286743,11287735,11434143,11434148,11434150,11435324,11435980,11436205,11531517,11531522,11531524,11531949,11532588,11532791,11574739,11574744,11574747,11575582,11618486,11618487,11618493,11667071,11667076,11667079,11711950,11711955,11711958,11713168,11713639,11713757,11757798,11757803,11757806,11758742,11805228,11805233,11805236,11896686,11896691,11896694,11896909,11896986,11897052,11940864,11940869,11940872,11942510,11980402,11980407,11980410,11981350,11981699,11982826,12061903,12061908,12061913,48111,48116,48118,48350,48816,49097,86409,86414,86416,87277,87426,87498,127005,127010,127013,128614,128770,128855,210911,210916,210919,212523,212672,212762,288838,288843,288848,289789,333229,333234,333237) ) 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` = 39863 WHERE `RP`.`player` = 39863 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (303504,303505,303511,10370793,10370798,10370801,10371773,10372465,10372535,10441257,10441262,10441265,10513293,10513298,10513301,10639490,10639491,10639497,10640820,10640939,10641034,10826193,10826198,10826201,10893722,10893727,10893732,10893998,11085772,11085777,11085782,11087196,11087484,11087612,11186626,11186627,11186633,11188242,11286175,11286180,11286183,11286594,11286743,11287735,11434143,11434148,11434150,11435324,11435980,11436205,11531517,11531522,11531524,11531949,11532588,11532791,11574739,11574744,11574747,11575582,11618486,11618487,11618493,11667071,11667076,11667079,11711950,11711955,11711958,11713168,11713639,11713757,11757798,11757803,11757806,11758742,11805228,11805233,11805236,11896686,11896691,11896694,11896909,11896986,11897052,11940864,11940869,11940872,11942510,11980402,11980407,11980410,11981350,11981699,11982826,12061903,12061908,12061913,48111,48116,48118,48350,48816,49097,86409,86414,86416,87277,87426,87498,127005,127010,127013,128614,128770,128855,210911,210916,210919,212523,212672,212762,288838,288843,288848,289789,333229,333234,333237) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: