SELECT DISTINCT cb.phone
FROM bonus_account ba
INNER JOIN client_buyer cb
ON ba.id = cb.bonus_account_id
INNER JOIN purchase p
ON p.bonus_account_id = ba.id
WHERE
  p.organization_id = :organization_id
  AND p.is_purchase = TRUE
  AND p.status = 2 /* STATUS_APPROVED */
  AND TO_CHAR(p.DATE, 'YYYY-MM') = :date
  AND ba.organization_id = :organization_id
  AND ba.registration_sale_point_id = :registration_sale_point_id
  AND cb.organization_id = :organization_id
  AND NOT cb.deleted

EXCEPT (
    SELECT DISTINCT cb.phone
    FROM bonus_account ba
    INNER JOIN client_buyer cb
    ON ba.id = cb.bonus_account_id
    INNER JOIN purchase p
    ON p.bonus_account_id = ba.id
    WHERE
      p.organization_id = :organization_id
      AND p.sale_point_id = :registration_sale_point_id
      AND p.is_purchase = TRUE
      AND p.status = 2 /* STATUS_APPROVED */
      AND TO_CHAR(p.DATE, 'YYYY-MM') = :date
      AND ba.organization_id = :organization_id
      AND ba.registration_sale_point_id = :registration_sale_point_id
      AND cb.organization_id = :organization_id
      AND NOT cb.deleted
) ORDER BY phone;