Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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 = 'cca743c6-90fd-b935-8967-3b4f58b80210'
- 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
- 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 = '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 phone;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement