---

SELECT
    c.id AS contract_id,
    c.number AS contract_number,
    c.individual_id AS investor_id,
    s.id AS sharer_id,
    s.individual_id AS participant_id,
    CASE
        WHEN c.individual_id IS NOT NULL
         AND s.individual_id IS NOT NULL
         AND c.individual_id <> s.individual_id
        THEN TRUE
        ELSE FALSE
    END AS third_person
FROM ourpension.contract c
JOIN ourpension.sharer s
    ON s.contract_id = c.id
WHERE c.individual_id IS NOT NULL
  AND s.individual_id IS NOT NULL
  AND c.individual_id <> s.individual_id
ORDER BY c.id DESC
LIMIT 20;