Advertisement
Guest User

Untitled

a guest
Jan 16th, 2018
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT DISTINCT cb.phone
  2. FROM bonus_account ba
  3. INNER JOIN client_buyer cb
  4. ON ba.id = cb.bonus_account_id
  5. INNER JOIN purchase p
  6. ON p.bonus_account_id = ba.id
  7. WHERE
  8.   p.organization_id = 'cca743c6-90fd-b935-8967-3b4f58b80210'
  9.   AND p.is_purchase = TRUE
  10.   AND p.status = 2 /* STATUS_APPROVED */
  11.   AND to_char(p.date, 'YYYY-MM') = '2017-12'
  12.   AND ba.organization_id = 'cca743c6-90fd-b935-8967-3b4f58b80210'
  13.   AND ba.registration_sale_point_id = '637dd9b0-b6ca-feb9-0eb1-0903d2de3b62'
  14.   AND cb.organization_id = 'cca743c6-90fd-b935-8967-3b4f58b80210'
  15.   AND NOT cb.deleted
  16.  
  17. EXCEPT (
  18.     SELECT DISTINCT cb.phone
  19.     FROM bonus_account ba
  20.     INNER JOIN client_buyer cb
  21.     ON ba.id = cb.bonus_account_id
  22.     INNER JOIN purchase p
  23.     ON p.bonus_account_id = ba.id
  24.     WHERE
  25.       p.organization_id = 'cca743c6-90fd-b935-8967-3b4f58b80210'
  26.       AND p.sale_point_id = '637dd9b0-b6ca-feb9-0eb1-0903d2de3b62'
  27.       AND p.is_purchase = TRUE
  28.       AND p.status = 2 /* STATUS_APPROVED */
  29.       AND to_char(p.date, 'YYYY-MM') = '2017-12'
  30.       AND ba.organization_id = 'cca743c6-90fd-b935-8967-3b4f58b80210'
  31.       AND ba.registration_sale_point_id = '637dd9b0-b6ca-feb9-0eb1-0903d2de3b62'
  32.       AND cb.organization_id = 'cca743c6-90fd-b935-8967-3b4f58b80210'
  33.       AND NOT cb.deleted
  34. ) ORDER BY phone;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement