SELECT user.userid, user.username /* , etc */ FROM session LEFT JOIN user USING (userid) WHERE session.location = '/memberlist.php%'