select ad.Org_name"Account",sdo.name "Site", qd.queuename "Group", au.first_name "Technician" from queue_technician qt

left join aaauser au on au.user_id=qt.technicianid

left join queuedefinition qd on qt.queueid=qd.queueid

left join sdorganization sdo on sdo.org_id=qd.siteid

left join accountsitemapping asm on asm.siteid=qd.siteid

left join accountdefinition ad on ad.org_id=asm.accountid

order by 1,2