Thanks

SELECT aau.FIRST_NAME AS "Requester", aau.FIRST_NAME AS "Requester", wo.WORKORDERID AS "Request ID", longtodate(wo.CREATEDTIME) AS "Created Time", scd.NAME AS "Subcategory", wo.TITLE AS "Subject", ti.FIRST_NAME AS "Technician", wotodesc.FULLDESCRIPTION AS "Description", longtodate(wos.LAST_TECH_UPDATE) AS "Last Update Time", wos.ISOVERDUE AS "Overdue Status" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrderToDescription wotodesc ON wo.WORKORDERID=wotodesc.WORKORDERID 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 SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE  (((sdu.ISVIPUSER = true) AND (((std.STATUSNAME::TEXT != 'Closed'::TEXT) AND (std.STATUSNAME::TEXT != 'Resolved'::TEXT)) OR (std.STATUSNAME::TEXT IS NULL))) AND ((cd.CATEGORYNAME != 'Project') OR (cd.CATEGORYNAME IS NULL)))  AND wo.ISPARENT='1'  ORDER BY 1 NULLS FIRST , 4 NULLS FIRST