Anonymous

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 = $char_id) where DATE_SUB(CURDATE(), INTERVAL 0 DAY) WHERE DATE_SUB(CURDATE(), INTERVAL 0 DAY) <= FROM_UNIXTIME(invite_time) ORDER BY raid_id ASC LIMIT 5