---

SELECT 
    sh.id,
    sh.scheme_id,
    sh.contract_id,
    ps.brief
FROM back_office.posted_register_details prd
JOIN back_office.eps_transaction_source ets
    ON ets.operation_id = prd.operation_id
JOIN ourpension.sharer sh
    ON sh.id = prd.sharer_id
LEFT JOIN prod_line.pens_scheme ps 
    ON ps.id = sh.scheme_id
LIMIT 10