SELECT wo.WORKORDERID AS "Request ID", lvd.LEVELNAME AS "Level", pd.PRIORITYNAME AS "Priority", longtodate(wo.CREATEDTIME) AS "Created Time", longtodate(wo.RESPONDEDTIME) AS "Responded Date", longtodate(ct.TS_STARTTIME) AS "Time Spent Starttime", wo.TIMESPENTONREQ AS "Time Elapsed", longtodate(wo.COMPLETEDTIME) AS "Completed Time", rctd.FIRST_NAME AS "Time Spent Technician", longtodate(wo.RESOLVEDTIME) AS "Resolved Time", aau.FIRST_NAME AS "Requester", std.STATUSNAME AS "Request Status" FROM WorkOrder wo LEFT JOIN WorkOrderAccountMapping wam ON wo.WORKORDERID=wam.WORKORDERID LEFT JOIN PortalAccounts port_acc ON wam.ACCOUNTID=port_acc.ACCOUNTID LEFT JOIN AccountDefinition ad ON port_acc.ACCOUNTID=ad.ORG_ID LEFT JOIN WorkOrderToCharge wotoc ON wo.WORKORDERID=wotoc.WORKORDERID LEFT JOIN ChargesTable ct ON wotoc.CHARGEID=ct.CHARGEID LEFT JOIN SDUser rcti ON ct.TECHNICIANID=rcti.USERID LEFT JOIN AaaUser rctd ON rcti.USERID=rctd.USER_ID LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID LEFT JOIN LevelDefinition lvd ON wos.LEVELID=lvd.LEVELID LEFT JOIN OperationalHoursDef ohd ON wo.SITEID = ohd.SITEID LEFT JOIN SDOrganization sdo ON wo.SITEID = sdo.ORG_ID WHERE  ( ( ( EXTRACT( HOUR FROM TO_TIMESTAMP(wo.CREATEDTIME / 1000) ) >= EXTRACT( HOUR FROM CAST(ohd.starttime AS TIME) ) ) AND ( (wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL) ) ) AND ( ( EXTRACT( HOUR FROM TO_TIMESTAMP(wo.CREATEDTIME / 1000) ) <= EXTRACT( HOUR FROM CAST(ohd.ENDTIME AS TIME) ) ) AND ( ( (wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL) ) AND (wo.CREATEDTIME != -1) ) ) ) AND wo.ISPARENT = '1' AND ad.ORG_NAME = 'ACCOUNTNAME' AND sdo.NAME = 'SITENAME'