Skip to content

Instantly share code, notes, and snippets.

@wenbert

wenbert/expired_in_123signup_and_not_in_cfai_list.sql

Created December 2, 2011 11:34
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save wenbert/1422934 to your computer and use it in GitHub Desktop.
Save wenbert/1422934 to your computer and use it in GitHub Desktop.
Download ZIP
4. All those in the 123signup list who are listed as EXPIRED but are NOT listed in the CFAI list>>> Leave them EXPIRED in 123signup. But be ready to upgrade them when they are upgraded in CFAI
Raw
expired_in_123signup_and_not_in_cfai_list.sql
SELECT
onetwothree.`name`,
onetwothree.`email`, onetwothree.`exp_date`, onetwothree.`days_due`
FROM from_123 onetwothree
LEFT JOIN from_cfai cfai
ON cfai.email = onetwothree.email
WHERE
onetwothree.days_due > 0
AND
cfai.first_name IS NULL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment