SELECT wo.WORKORDERID AS "Request ID",

wo.TITLE AS "Subject",

wo.DESCRIPTION As "DESCRIPTION",

aau.FIRST_NAME AS "Requester",

dpt1.DEPTNAME AS " Requester Department",

srep.First_Name As "Suprep",  

qd.QUEUENAME AS "Group",

longtodate(wo.CREATEDTIME) as "Created Time" ,

ApprovalDetails.EMAIL AS "Approver Email",

longtodate(ApprovalDetails.ACTION_DATE) AS "Date Of Approval",

ApprovalDetails.COMMENTS AS "Approval COMMENTS",

longtodate(wo.RESOLVEDTIME) as "Resolved/Closed Time",

ApprovalStatusDefinition.STATUSNAME AS "Approval Status" 

FROM WorkOrder wo

LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID

LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID

LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID

Left Join AAAUser srep ON wos.OwnerID=srep.User_ID

LEFT JOIN SDUser req ON wo.requesterid=req.userid

LEFT JOIN AaaUser requ ON req.userid=requ.user_id

LEFT JOIN UserDepartment UD1 on req.USERID=ud1.userid

LEFT JOIN DepartmentDefinition dpt1 ON ud1.DEPTID=dpt1.DEPTID

LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID

 LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID

 LEFT JOIN AccountSiteMapping asm ON wo.SITEID=asm.SITEID

LEFT JOIN AccountDefinition ad ON asm.ACCOUNTID=ad.ORG_ID

 left JOIN ApprovalStageMapping ON wo.WORKORDERID=ApprovalStageMapping.WORKORDERID

LEFT JOIN ApprovalDetails ON ApprovalStageMapping.APPROVAL_STAGEID=ApprovalDetails.APPROVAL_STAGEID

LEFT JOIN ApprovalStage ON ApprovalDetails.APPROVAL_STAGEID=ApprovalStage.APPROVAL_STAGEID

LEFT JOIN  approvalstatusdefinition ON ApprovalDetails.STATUSID=ApprovalStatusDefinition.STATUSID

 WHERE ApprovalDetails.ISDELETED!=1 and ad.ORG_NAME = 'My Org Inc';