SELECT distinct wo.WORKORDERID "Request ID",wo.TITLE "Subject",scd.NAME "Sub Category",ti.FIRST_NAME "Technician",longtodate(wo.COMPLETEDTIME) "Completed Time",au2.first_name "Responded By",longtodate(woh.operationtime)"Responded time" FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID 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 workorderhistory woh on wo.workorderid=woh.workorderid left join workorderhistorydiff wohd on woh.historyid=wohd.historyid left join aaauser au2 on woh.operationownerid=au2.user_id  

WHERE  wot.THD_WOID=wot.WORKORDERID and wohd.columnname like 'RESPONDEDTIME'

and (to_timestamp(wo.createdtime/1000) between date '2013-01-01' and date '2013-12-31')