SELECT wo.WORKORDERID AS "Request ID", wof.UDF_CHAR12 AS "Visitor Name", wof.UDF_CHAR11 AS "ID Number", wof.UDF_CHAR13 AS "Visitor Surname", wof.UDF_CHAR1 AS "From Company", longtodate(wof.UDF_DATE1) AS "Effective From", longtodate(wof.UDF_DATE2) AS "Effective To", std.STATUSNAME AS "Request Status", longtodate(wof.UDF_DATE3) AS "Card Issued Date/Time", wof.UDF_CHAR3 AS "Card Returned", wo.TIMESPENTONREQ AS "Time Elapsed" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN WorkOrder_Fields wof ON wo.WORKORDERID=wof.WORKORDERID WHERE (((wo.CREATEDTIME >= 1483221600000) AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL))) AND ((wo.CREATEDTIME <= 1485899999000) AND (((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL)) AND (wo.CREATEDTIME != -1)))) AND wo.ISPARENT='1'