|
SELECT m.*, r.* FROM members m LEFT OUTER JOIN member_roles r INNER JOIN role_types rt ON rt.role_type_id = r.role_type_id ON m.memberid = r.memberid WHERE m.active = 1 AND (r.end_date > now() OR r.end_date is null) AND m.memberid = '1' ORDER BY rt.board_level
|