Produciton items - Step by step instruction declaration

SELECT pi.id work_order_id, pi.number work_order_number, pi.quantity work_order_quantity, pi.QUANTITY_FINISH work_order_quantity_finish,
pis.title work_order_status, 
m.code material_code, m.title material_title,
isr.TITLE ins_step_status, inss.title ins_step_title, 
isrh.time_started at time zone 'UTC' at time zone 'US Mountain Standard Time' ins_step_started, 
isrh.time_finished at time zone 'UTC' at time zone 'US Mountain Standard Time' ins_step_finished,
DATEDIFF(second, isrh.time_started, isrh.time_finished) duration_in_sec,
cast(DATEDIFF(second, isrh.time_started, isrh.time_finished) as float) / 60 duration_in_min,
cast(DATEDIFF(second, isrh.time_started, isrh.time_finished) as float) / 3600 duration_in_hour,
isrh.users ins_step_user, isrh.operators ins_step_operators
FROM PRODUCTION_ITEM pi
JOIN material m ON m.id = pi.id_material
JOIN status pis ON pis.id = pi.id_status
LEFT JOIN INSTRUCTION_STEP_RECORD isr ON isr.ID_PRODUCTION_ITEM = pi.id
LEFT JOIN (
    SELECT * FROM ins_step_record_history WHERE id IN(
        SELECT max(id)
        FROM ins_step_record_history 
        group by id_production_item, id_instruction_step_record
    )
) isrh ON isrh.ID_PRODUCTION_ITEM = pi.id and isrh.id_instruction_step_record = isr.id
JOIN status inss ON inss.id = isr.ID_STATUS
WHERE pis.name = 'finished'
order by pi.TIME_FINISH asc