select wo.WORKORDERID 'Request Id', au.FIRST_NAME 'Technician Name', pd.PRIORITYNAME 'Priority', date_format(from_unixtime(wo.CREATEDTIME/1000),'%d-%m-%Y %h:%i:%s') 'Created Time', date_format(from_unixtime(wo.COMPLETEDTIME/1000),'%d-%m-%Y %h:%i:%s') 'Completed Time', ROUND((wo.COMPLETEDTIME-wo.CREATEDTIME)/3600000) 'Time Elapsed (Hr)' from WorkOrder wo LEFT JOIN WorkOrderStates wos on wo.WORKORDERID=wos.WORKORDERID LEFT JOIN WorkOrder_Threaded wot on wo.WORKORDERID=wot.WORKORDERID LEFT JOIN AaaUser au on wos.OWNERID=au.USER_ID LEFT JOIN PriorityDefinition pd on wos.PRIORITYID=pd.PRIORITYID LEFT JOIN StatusDefinition sd on wos.STATUSID=sd.STATUSID where sd.STATUSNAME='Closed' and wot.THD_WOID=wot.WORKORDERID