---

c.entity_id,
c.individual_id AS contract_individual_id,
sh.individual_id AS sharer_individual_id,

EXISTS (
    SELECT 1
    FROM ourpension.sharer sh3
    WHERE sh3.contract_id = c.id
      AND c.individual_id IS NOT NULL
      AND sh3.individual_id IS NOT NULL
      AND sh3.individual_id <> c.individual_id
) AS third_person,

cp.min_annual_income_period,



s."service_type",
s.sharer_individual_id,
s.third_person,
s.strategy_name,