---

SELECT 
    et.id,
    io.contract_id,
    ish.strategy_id,
    s.name as strategy_name,
    t.value,
    t.period_date
FROM back_office.eps_transaction et
JOIN back_office.eps_transaction_source ets ON ets.id = et.eps_transaction_source_id
JOIN back_office.incoming_order io ON io.id = ets.incoming_order_id
JOIN ourpension.invest_strategy_history ish 
    ON ish.contract_id = io.contract_id
    AND t.period_date BETWEEN ish.begin_date AND COALESCE(ish.end_date, 'infinity')
JOIN prod_line.hb_invest_strategy s ON s.id = ish.strategy_id
JOIN back_office.transaction t ON t.operation_id = ets.operation_id
LIMIT 10