Production history report

SELECT 
pi.number, pi.barcode, pi.TIME_FINISH, pi.quantity, pi.QUANTITY_FINISH, 

pi.actual_duration_time, 
pi.time_production, 
pi.production_efficiency, 

CAST(pi.actual_duration_time / 86400 AS VARCHAR(10)) + ' days, ' +
CAST((pi.actual_duration_time % 86400) / 3600 AS VARCHAR(10)) + ' hours, ' +
CAST((pi.actual_duration_time % 3600) / 60 AS VARCHAR(10)) + ' minutes, ' +
CAST(pi.actual_duration_time % 60 AS VARCHAR(10)) + ' seconds' 

AS actual_duration_time_formatted,

CAST(pi.time_production / 86400 AS VARCHAR(10)) + ' days, ' +
CAST((pi.time_production % 86400) / 3600 AS VARCHAR(10)) + ' hours, ' +
CAST((pi.time_production % 3600) / 60 AS VARCHAR(10)) + ' minutes, ' +
CAST(pi.time_production % 60 AS VARCHAR(10)) + ' seconds' 

AS time_production_formatted,

s.TITLE status_title, sh.CODE shift_code, sh.TITLE shift_title, m.CODE material_code, m.TITLE material_title, pl.CODE production_line
  FROM PRODUCTION_ITEM pi
  JOIN MATERIAL m ON m.ID = pi.ID_MATERIAL
  JOIN PRODUCTION_LINE pl on pl.ID = pi.ID_WORKSPACE
  JOIN STATUS s on s.ID = pi.id_status
  JOIN declaration_history dh ON dh.id_production_item = pi.id
  JOIN SHIFT sh on sh.ID = dh.id_shift
  where TIME_FINISH > '2024-06-01 00:00:00.0000000'
  order by pi.TIME_FINISH desc