Report - Requests Approval

I am trying to build a report to show all tickets that have approval requests against them specifically i need the users full name.

I got some of this from another form post

So far i have the following however ApprovalDetails.ApprovedBy comes up NULL. Only user identifying info is the email address. Is there another way to link this?

select wo.WORKORDERID 'Request ID', wo.TITLE 'Title', date_format(from_unixtime(wo.CREATEDTIME/1000),'%Y-%m-%d %h:%i:%s') 'Request Date', asd.STATUSNAME 'Approval Status', au1.FIRST_NAME 'Approved by', ad.*
from WorkOrder wo
left join WorkOrderStates wos on wo.WORKORDERID=wos.WORKORDERID
left join WorkOrder_Threaded wot on wo.WORKORDERID=wot.WORKORDERID
left join ApprovalStatusDefinition asd on wos.APPR_STATUSID=asd.STATUSID
left join ApprovalStageMapping asm on wo.WORKORDERID=asm.WORKORDERID
left join ApprovalDetails ad on asm.APPROVAL_STAGEID=ad.APPROVAL_STAGEID
left join SdUser sd on ad.APPROVEDBY=sd.USERID
left join AaaUser au1 on sd.USERID=au1.USER_ID
where asd.statusname is not null