SELECT STRAIGHT_JOIN mo.timestamp, member.username, member.city, member.state, mds.date_of_birth, media.media_id, media.media_server, media.directory_index, media.path FROM member_online mo INNER JOIN member USING( member_id ) INNER JOIN member_dating_search mds USING (member_id) LEFT JOIN media ON media.media_id = member.media_id AND media.approved='yes' ORDER BY mo.timestamp DESC LIMIT $more