---

SELECT
    o.id AS operation_id,
    ot.code AS operation_type_code,
    o.effective_date,
    o.approved,
    o.deleted,
    o.ops_payment_register_id,
    t.id AS transaction_id,
    dat.mnemonics AS debit_account_type,
    cat.mnemonics AS credit_account_type,
    t.value
FROM back_office.operation o
LEFT JOIN back_office.operation_type ot
    ON ot.id = o.operation_type_id
LEFT JOIN back_office.transaction t
    ON t.operation_id = o.id
LEFT JOIN back_office.account da
    ON da.id = t.debit_account_id
LEFT JOIN back_office.account_type dat
    ON dat.id = da.account_type_id
LEFT JOIN back_office.account ca
    ON ca.id = t.credit_account_id
LEFT JOIN back_office.account_type cat
    ON cat.id = ca.account_type_id
WHERE o.ops_payment_register_id = 1089138
ORDER BY o.effective_date, o.id, t.id;