---

SELECT
    c.id,
    c.number,
    c.service_type,
    c.client_type,
    c.date AS contract_date,
    c.create_date
FROM ourpension.contract c
WHERE c.service_type = 'NPO'
  AND c.client_type = 0
  AND c.create_date IS NOT NULL
ORDER BY c.id DESC
LIMIT 20;