select 
  max(pth.id) max_id,
    pth_all 
from 
  portal.support_ticket_history pth 
where 
  ticket_id = 209485
group by ticket_id

left join 
  portal.support.ticket_history pth_all on pth_all.id = max_id

SELECT 
    *
FROM
    portal.support_ticket_history pth
        JOIN
    (SELECT 
        MAX(pth.id) max_id
    FROM
        portal.support_ticket_history pth
    WHERE
        ticket_id = 209485
    GROUP BY ticket_id) pth_new ON pth_new.max_id = pth.id