SELECT distinct(roles.user_id), users.username,users.first_name,users.middle_name,users.last_name FROM users,roles WHERE users.user_id=roles.user_id AND (roles.role_id=64 OR roles.role_id=128) AND roles.sched_conf_id=47 ORDER BY first_name,middle_name,last_name
