select wo.WORKORDERID 'Request Id', wo.TITLE 'Subject', au.FIRST_NAME 'Requester', au1.FIRST_NAME 'Technician', dateadd(s,wo.CREATEDTIME/1000,'01-01-1970') 'Created date/time', dateadd(s,wos.ASSIGNEDTIME/1000,'01-01-1970') 'Assigned Time', (wos.ASSIGNEDTIME - wo.CREATEDTIME)/3600000 'Time taken to assign (mins)' from WorkOrder wo left join WorkOrderStates wos on wo.WORKORDERID=wos.WORKORDERID left join WorkOrder_Threaded wot on wo.WORKORDERID=wot.WORKORDERID left join SdUser sd on wo.REQUESTERID=sd.USERID left join AaaUser au on sd.USERID=au.USER_ID left join SdUser sd1 on wos.OWNERID=sd1.USERID left join AaaUser au1 on sd1.USERID=au1.USER_ID where wot.WORKORDERID=wot.THD_WOID