---

select
    t.id as transaction_id,
    t.value,
    da.id as debit_account_id,
    dat.mnemonics as debit_type,
    da.owner_sharer_id as debit_sharer_id,
    ca.id as credit_account_id,
    cat.mnemonics as credit_type,
    ca.owner_sharer_id as credit_sharer_id
from back_office.transaction t
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 t.operation_id = 72694034
order by t.id;