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 = 'cca743c6-90fd-b935-8967-3b4f58b80210'
  AND p.sale_point_id <> '637dd9b0-b6ca-feb9-0eb1-0903d2de3b62'
  AND p.is_purchase = TRUE
  AND p.status = 2 /* STATUS_APPROVED */
  AND to_char(p.date, 'YYYY-MM') = '2017-12'

  AND ba.organization_id = 'cca743c6-90fd-b935-8967-3b4f58b80210'
  AND ba.registration_sale_point_id = '637dd9b0-b6ca-feb9-0eb1-0903d2de3b62'

  AND cb.organization_id = 'cca743c6-90fd-b935-8967-3b4f58b80210'
  AND NOT cb.deleted
ORDER BY cb.phone;