SELECT icd.NAME "Item",wo.WORKORDERID "Request ID",ti.FIRST_NAME "Technician",icd.NAME "Item",wo.TITLE "Subject",std.STATUSNAME "Request Status",longtodate(wo.CREATEDTIME) "Created Time",longtodate(wo.COMPLETEDTIME) "Completed Time" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN ItemDefinition icd ON wos.ITEMID=icd.ITEMID 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  (((((ti.FIRST_NAME = N'Chris Munoz' COLLATE SQL_Latin1_General_CP1_CI_AS) OR (ti.FIRST_NAME = N'David Gmiter' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (ti.FIRST_NAME = N'Roger Castillo' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (ti.FIRST_NAME = N'Tiffany Kennedy' COLLATE SQL_Latin1_General_CP1_CI_AS)) AND (((longtodate(wo.CREATEDTIME) >= datetolong('1294639200000') AND ((longtodate(wo.CREATEDTIME) != 0) AND (longtodate(wo.CREATEDTIME) IS NOT NULL))) AND ((longtodate(wo.CREATEDTIME) <= datetolong('1295243999000') AND (((longtodate(wo.CREATEDTIME) != 0) AND (longtodate(wo.CREATEDTIME) IS NOT NULL)) AND (longtodate(wo.CREATEDTIME) != -1)))))  AND wo.ISPARENT=1 AND wo.IS_CATALOG_TEMPLATE=1  ORDER BY 1