SELECT BINARY qd.QUEUENAME "Group",wo.WORKORDERID "Request ID",BINARY mdd.MODENAME "Request Mode",BINARY aau.FIRST_NAME "Requester",BINARY dpt.DEPTNAME "Department",DATE_FORMAT(FROM_UNIXTIME(wo.CREATEDTIME/1000) ,'%d-%m-%Y %k:%i') "Created Time",BINARY wo.TITLE "Title" FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN ModeDefinition mdd ON wo.MODEID=mdd.MODEID LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID=dpt.DEPTID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID = woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID = qd.QUEUEID LEFT JOIN StatusDefinition sd ON wos.STATUSID = sd.STATUSID where (wo.CREATEDTIME >= (UNIX_TIMESTAMP(DATE('2006-07-24 00:00:00')) * 1000) and wo.CREATEDTIME <= (UNIX_TIMESTAMP(DATE_ADD('2006-11-23 00:00:00')) * 1000) AND (wot.THD_WOID = wot.WORKORDERID)) and sd.STATUSNAME IN ('Closed') order by 1