---

LEFT JOIN ourpension.entity contract_entity
    ON contract_entity.id = c.entity_id

LEFT JOIN ourpension.holding ha
    ON ha.id = contract_entity.holding_id