SSELECT wof.UDF_CHAR2 "Reporting Category",wo.WORKORDERID "Request ID",cd.CATEGORYNAME "Category",scd.NAME "Sub Category",icd.NAME "Category Item",wof.UDF_CHAR3 "Customer Email",wod.FULLDESCRIPTION "Description",rrs.RESOLUTION "Resolution",pd.PRIORITYNAME "Priority",lvd.LEVELNAME "Level",sla.SLANAME "SLA" FROM WorkOrder wo LEFT JOIN SLADefinition sla ON wo.SLAID=sla.SLAID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID LEFT JOIN SubCategoryDefinition scd ON wos.SUBCATEGORYID=scd.SUBCATEGORYID LEFT JOIN ItemDefinition icd ON wos.ITEMID=icd.ITEMID LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID LEFT JOIN LevelDefinition lvd ON wos.LEVELID=lvd.LEVELID LEFT JOIN RequestResolver rrr ON wo.WORKORDERID=rrr.REQUESTID LEFT JOIN RequestResolution rrs ON rrr.REQUESTID=rrs.REQUESTID LEFT JOIN WorkOrder_Fields wof ON wo.WORKORDERID=wof.WORKORDERID LEFT JOIN WORKORDERTODESCRIPTION wod on wo.workorderid=wod.workorderid WHERE wo.respondedtime >= DATETOLONG('2015-04-17 00:00:00') and wo.respondedtime <= DATETOLONG('2015-04-17 23:59:59') AND wo.RESPONDEDTIME IS NOT NULL AND  wo.DEPARTMENTID = 1 AND wo.RESPONDEDTIME != 0  AND wo.ISPARENT='1' ORDER BY 1, 3, 5, 6