Help with this Report Query
I am trying to generate a custom query report that groups Requests by Template ID and Status. I am new to MySQL, so any help is appreciated. Below is my attempt.
SELECT rtl.templatename "Template Name",std.STATUSNAME "Request Status",wo.WORKORDERID "Request ID",mdd.MODENAME "Request Mode",dpt.DEPTNAME "Department",ti.FIRST_NAME "Technician",sinfo.WORKSTATIONNAME "Workstation",std.STATUSNAME "Request Status",longtodate(wo.CREATEDTIME) "Created Time",wo.TITLE "Subject" FROM requesttemplate_list rtl left join workorder wo on rtl.templateid=wo.templateid LEFT JOIN on WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN ModeDefinition mdd ON wo.MODEID=mdd.MODEID LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID=dpt.DEPTID LEFT JOIN SystemInfo sinfo ON wo.WORKSTATIONID=sinfo.WORKSTATIONID 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 LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE (wot.THD_WOID=wot.WORKORDERID) ORDER BY 1
SELECT rtl.templatename "Template Name",std.STATUSNAME "Request Status",wo.WORKORDERID "Request ID",mdd.MODENAME "Request Mode",dpt.DEPTNAME "Department",ti.FIRST_NAME "Technician",sinfo.WORKSTATIONNAME "Workstation",std.STATUSNAME "Request Status",longtodate(wo.CREATEDTIME) "Created Time",wo.TITLE "Subject" FROM requesttemplate_list rtl left join workorder wo on rtl.templateid=wo.templateid LEFT JOIN on WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN ModeDefinition mdd ON wo.MODEID=mdd.MODEID LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID=dpt.DEPTID LEFT JOIN SystemInfo sinfo ON wo.WORKSTATIONID=sinfo.WORKSTATIONID 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 LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE (wot.THD_WOID=wot.WORKORDERID) ORDER BY 1