SELECT CONCAT (UP.hcc_last_name,CONCAT (', ',CONCAT (UP.hcc_first_name,CONCAT (' [', CONCAT (u.user_alias, ']'))))), u.user_id FROM bv_user_profile UP, bv_user u, bv_ep_qual_value qv, bv_ep_uprof_qval uq, bv_category c, (SELECT u2.user_id FROM bv_user u2, bv_ep_uprof_qval uq2, bv_ep_qual_value qv2, bv_category c2 WHERE u2.user_id = uq2.user_id AND uq2.qvid = qv2.OID AND qv2.status = 1 AND qv2.deleted = 0 AND qv2.friendly_name ='Alice - Atlas CH' AND qv2.store_id = 107 AND uq2.qid = c2.OID AND c2.NAME = 'ATLAS LQA Districts' AND c2.store_id = 107 ) dis WHERE u.user_id = UP.user_id AND u.user_state = 0 AND u.user_id = dis.user_id AND u.user_id = uq.user_id AND uq.qvid = qv.OID AND qv.store_id = 107 AND qv.status = 1 AND qv.deleted = 0 AND qv.friendly_name = 'Grading Manager' AND uq.qid = c.OID AND c.store_id = 107 AND c.status = 1 AND c.deleted = 0 AND c.NAME = 'ATLAS LQA User Role' ORDER BY 1 ASC