---

SELECT
    o.id AS operation_id,
    o.ops_assignee_decision_id AS direct_decision_id,
    o.ops_assignee_decision_id_1c AS decision_link_1c,
    d.id AS matched_decision_id,
    d.number AS decision_number
FROM back_office.operation o
LEFT JOIN back_office.ops_assignee_decision d
    ON d.ops_assignee_decision_id =
       o.ops_assignee_decision_id_1c
WHERE o.id IN (
    79490301,
    79531249,
    79536678,
    79811972,
    79852424
)
ORDER BY o.id;