How do I add employee ID & Computer Name (Custom field) and email address to the below query?

How do I add employee ID & Computer Name (Custom field) and email address to the below query (Next to user name) and sort all data by the request statuses "AD to enable account" and "AD to disable account"

SELECT aau.FIRST_NAME 'User', wo.TITLE "Ticket Title", std.STATUSNAME 'Ticket Status', ti.FIRST_NAME 'Ticket Assigned To',longtodate(wo.CREATEDTIME) 'Ticket Created Time',longtodate(wo.COMPLETEDTIME) 'Ticket Closed Time',TaskDetails.TITLE 'Task Title', longtodate(TaskDetails.CREATEDDATE) 'Task Created Date',TaskDetailsCreater.FIRST_NAME 'Task Created By',StatusDefinition.STATUSNAME 'Task Status',TaskDetailsOwner.FIRST_NAME 'Task Owner',longtodate(TaskDetails.SCHEDULEDSTARTTIME) 'Task Schedule Start Time',longtodate(TaskDetails.SCHEDULEDENDTIME) 'Task Schedule End Time',longtodate(TaskDetails.ACTUALSTARTTIME) 'Task Actual Start Time',longtodate(TaskDetails.ACTUALENDTIME) 'Task Actual End Time',TaskDetails.COMMENTS 'Comments' FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID LEFT JOIN SubCategoryDefinition scd ON wos.SUBCATEGORYID=scd.SUBCATEGORYID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN WorkOrderToTaskDetails ON wo.WORKORDERID=WorkOrderToTaskDetails.WORKORDERID LEFT JOIN TaskDetails ON WorkOrderToTaskDetails.TASKID=TaskDetails.TASKID LEFT JOIN StatusDefinition ON TaskDetails.STATUSID=StatusDefinition.STATUSID LEFT JOIN AaaUser TaskDetailsCreater ON TaskDetails.CREATEDBY=TaskDetailsCreater.USER_ID LEFT JOIN AaaUser TaskDetailsOwner ON TaskDetails.OWNERID=TaskDetailsOwner.USER_ID