---

SELECT
    o.id AS operation_id,
    ot.code AS operation_type_code,
    rd.id AS decision_id,
    rdr.id AS register_id,
    rdr.reason AS reason_id,
    (rdr.reason = 665) AS death_fact
FROM back_office.operation o
LEFT JOIN back_office.operation_type ot
    ON ot.id = o.operation_type_id
LEFT JOIN back_office.rops_decisions rd
    ON rd.operation_id = o.id
LEFT JOIN back_office.rops_decisions_register rdr
    ON rdr.id = rd.rops_decisions_register_id
WHERE o.id = 84329816;