---

SELECT
    c.id,
    c.number,
    c.periodicity_payment_id,
    p.name AS periodicity_payment
FROM ourpension.contract c
LEFT JOIN ourpension.periodicity p
    ON p.id = c.periodicity_payment_id
WHERE c.id = 13670550;