最终版 : order by - tcl.service_class DESC ,mu.id DESC,mu.key_projects DESC
:事故现场sql(简化)
SELECT
tcl.service_class,
mu.key_projects
FROM
`t_park_maintenance_unit_app` mu
left join t_work_order_assignee_app woa on mu.default_assignee_id = woa.id
left join t_park tp on mu.park_id=tp.id
left join t_contractors tc on tp.engineer_user_id = tc.user_id
left join t_client tcl on mu.new_customer_id=tcl.id and tcl.del_flag=0
WHERE
mu.del_flag = 0 and mu.park_id != ''
order by - tcl.service_class DESC ,mu.id DESC,mu.key_projects DESC