仅获取最大值为5个表的行

I have this query:

我有这个问题:

SELECT work_orders.id,work_orders.create_datetime,work_orders.location,
       work_orders.description,user_accounts.function as function,
       user_accounts.name as username,work_order_states.name as state,
       work_orders_history.state_id,max(work_order_states.id)
FROM `work_orders`
LEFT JOIN work_orders_history 
    on work_orders.id = work_orders_history.work_order_id
LEFT JOIN user_accounts 
    on work_orders.create_user_id = user_accounts.id
LEFT JOIN work_order_type 
    on work_orders_history.type_id = work_order_type.id
LEFT JOIN work_order_states 
    on work_orders_history.state_id = work_order_states.id
SELECT work_orde