---

-- Шаг 1: есть ли sharer_id в posted_register_details для наших операций?
SELECT 
    prd.sharer_id,
    prd.contract_id,
    COUNT(*)
FROM back_office.posted_register_details prd
JOIN back_office.eps_transaction_source ets
    ON ets.operation_id = prd.operation_id
GROUP BY prd.sharer_id, prd.contract_id
LIMIT 10



-- Шаг 2: найти sharer через contract_id
SELECT 
    sh.id,
    sh.scheme_id,
    sh.contract_id,
    ps.brief
FROM ourpension.sharer sh
JOIN prod_line.pens_scheme ps ON ps.id = sh.scheme_id
WHERE sh.contract_id IN (13548566, 13558626, 13562984, 13574528)
LIMIT 10