Help with a MySQL query

I could use some help with a MySQL query from the SD+ Support crew. I would like to...

Add a "Request ID" column as the first column in this report
Change it from "Requests Completed Last Week" to "Surveys Completed Last Week"

Below is the query as it stands today. Please reply with any an updated query including the changes I've described above.

SELECT MAX(wo.TITLE) "Subject",MAX(aau.FIRST_NAME) "Requester", DATE_FORMAT(FROM_UNIXTIME(MAX(wo.CREATEDTIME)/1000),'%d-%M-%Y %k:%i')"Created Time",DATE_FORMAT(FROM_UNIXTIME(MAX(wo.COMPLETEDTIME)/1000),'%d-%M-%Y %k:%i') "Completed Time",MAX(ti.FIRST_NAME) "Technician",sum(sadt.RATING) "Rating",spre.comments"Comments" FROM SurveyPerRequest spr INNER JOIN SurveyPerRequestExt spre ON spr.SURVEYID=spre.SURVEYID LEFT JOIN SurveyDetails sdt ON spre.SURVEYID=sdt.SURVEYID LEFT JOIN SurveyAnswers sadt ON sdt.SURANSID=sadt.SURANSID LEFT JOIN WorkOrder wo ON spr.WORKORDERID=wo.WORKORDERID LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID where wo.COMPLETEDTIME>=<from_lastweek> and wo.COMPLETEDTIME<= <to_lastweek> group by wo.WORKORDERID

Your assistance is greatly appreciated!

Thanks-
Marc