select dotlrn_member_rels_approved.rel_id, dotlrn_member_rels_approved.role, dotlrn_member_rels_approved.user_id, registered_users.first_names, registered_users.last_name, registered_users.first_names || ' '|| registered_users.last_name as full_name, registered_users.email from registered_users, dotlrn_member_rels_approved where dotlrn_member_rels_approved.community_id = :random_comm_id and dotlrn_member_rels_approved.user_id = registered_users.user_id and dotlrn_member_rels_approved.user_id = :random_user_id