Return a default value if single row is not found
One way to do it SELECT IFNULL(MIN(`file`), ‘default.webm’) `file` FROM `show`, `schedule` WHERE `channel` = 1 AND `start_time` <= UNIX_TIMESTAMP() AND `start_time` > UNIX_TIMESTAMP()-1800 AND `show`.`id` = `schedule`.`file` ORDER BY `start_time` DESC LIMIT 1 Since you return only one row, you can use an aggregate function, in that case MIN(), that ensures that you’ll get … Read more