Pending Approval report for specific approver and request status

How can I edit this query found on here under another post to only include request status of Waiting on Approval and approver name equal to a specific user?

Thanks for your help.

Build in use 12.0 Build 12000

SELECT wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",dpt.DEPTNAME "Department",wo.TITLE "Subject",ti.FIRST_NAME "Technician",

std.STATUSNAME "Request Status",

longtodate(wo.CREATEDTIME) "Created Time",

asd.stagename "Stage name",

LONGTODATE(ApprovalStage.SENT_DATE) "Approval Sent date",

LONGTODATE(ApprovalDetails.ACTION_DATE) "Approved Date",

ApprovalStatusDefinition.STATUSNAME "Approval Status",

ApprovalDetails.EMAIL "Approver Email" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID=dpt.DEPTID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID

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

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

left join approvalstagedefinition asd on asd.STAGEID=ApprovalDetails.STAGEID WHERE (wo.ISPARENT='1') and ApprovalStatusDefinition.STATUSNAME like '%pending%'