Custom Report

Hello again.. I want to take a custom report that I have and add "resolution date" to it, to show when a ticket was marked as resolved. I have searched and found a couple of reports that did that, but wasn't exactly as we wanted.. This is the query that the UI came up with, and I would like to add Resolved Date as a column.

SELECT aau.FIRST_NAME "Requester",wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",wo.TITLE "Subject",cri.FIRST_NAME "Created By",std.STATUSNAME "Request Status",wo.COMPLETEDTIME "Completed Time" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN SDUser crd ON wo.CREATEDBYID=crd.USERID LEFT JOIN AaaUser cri ON crd.USERID=cri.USER_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE ((((std.STATUSNAME = 'Closed') OR (std.STATUSNAME = 'Resolved')) AND (((wo.CREATEDTIME >= 1357027200000) AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL))) AND ((wo.CREATEDTIME <= 1359705599000) AND (((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL)) AND (wo.CREATEDTIME != -1))))) AND (wo.SITEID IN (6,2))) AND wo.ISPARENT=1 ORDER BY 1