SELECT `G`.`id`, `G`.`day`, `G`.`team_h`, `G`.`team_a`, 0 as `goals_h`, 0 as `goals_a`, `RS`.`type`, `RS`.`game`, `RS`.`minute`, `RS`.`comment`, `RS`.`player`, `RP`.`roster`, `R`.`team` FROM `p_games_arch` `G` LEFT JOIN `p_report_short` `RS` ON `RS`.`game` = `G`.`id` AND `RS`.`type` = 0 AND (`RS`.`minute` BETWEEN 0 AND 180) LEFT JOIN `p_roster_pl_arch` `RP` ON `RP`.`player` = `RS`.`player` AND `RP`.`game` = `RS`.`game` LEFT JOIN `p_rosters_arch` `R` ON `R`.`id` = `RP`.`roster` WHERE `G`.`tournament` = 24 AND `G`.`played`=1 AND (`G`.`day` BETWEEN 0 AND 0) === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: