---

SELECT
    io.id AS incoming_order_id,
    io.date AS incoming_order_date,
    io.payment_return,

    ioo.id AS incoming_order_operation_id,
    ioo.operation_id,

    o.operation_date,
    o.approved,
    o.deleted,

    ot.code AS operation_code,

    t.id AS transaction_id,
    t.value AS transaction_value,
    t.credit_account_id,

    a.account_type_id,
    at.mnemonics

FROM back_office.incoming_order io

LEFT JOIN back_office.incoming_order_operation ioo
    ON ioo.incoming_order_id = io.id

LEFT JOIN back_office.operation o
    ON o.id = ioo.operation_id

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 a
    ON a.id = t.credit_account_id

LEFT JOIN back_office.account_type at
    ON at.id = a.account_type_id

WHERE io.individual_id = 11232579
  AND io.contract_id = 13649368

ORDER BY
    o.operation_date,
    o.id,
    t.id;