SELECT raid_id,location,FROM_UNIXTIME(start_time),  signup_id as signed_up  as start_time 
FROM phpraid_raids 
    LEFT OUTER JOIN (select * from phpraid_signups rs where rs.user_id = $userid ) 
    ON phpraid_raids.raid_id = rs.raid_id
WHERE DATE_SUB(CURDATE(), INTERVAL 0 DAY) <= FROM_UNIXTIME(invite_time)
ORDER BY raid_id ASC limit 5