SELECT raid_id,location,FROM_UNIXTIME(start_time) AS start_time, IFNULL(phpraids_signup.char_id, 0) AS signed_up FROM phpraid_raids LEFT JOIN phpraid_signups ON (phpraid_raids.raid_id = phpraid_signups.raid_id AND char_id = '11') WHERE DATE_SUB(CURDATE(), INTERVAL 0 DAY) <= FROM_UNIXTIME(start_time) ORDER BY raid_id ASC LIMIT 5