SELECT
    tr.meta_id, tr.tr_id AS mrch_pay,
    REF.tr_id AS mrch_ref,
    cpg_ref.tr_id AS cref,
    tr_data.payment_payee_pid
FROM dmr_transaction.transaction_meta AS tr
JOIN dmr_transaction.transaction_meta AS REF
    ON REF.parent_id = tr.tr_id
    AND REF.TYPE = 'refund'
LEFT JOIN dmr_transaction.transaction_meta AS cpg_ref
    ON  cpg_ref.parent_id = REF.tr_id
    AND cpg_ref.TYPE = 'chain'
LEFT JOIN dmr_transaction.transaction AS tr_data
    ON cpg_ref.tr_id = tr_data.transaction_id
WHERE
    tr.TYPE = 'chain'
    -- AND tr.meta_id = '999f499a-0d6e-11e8-a940-35bc221cdbe2'
    -- AND tr_data.payment_payee_pid is null
ORDER BY tr.added_time
;