CE This Week Migration

imports.sql

#prior to running these, grab all held emails from delivra and import as suppressions to phplist.

#Server 2 - All active subscribers from MYB
SELECT
phplist_user_user.id,
TRIM(LOWER(phplist_user_user.email)) as 'email',
'1' as 'Business'
FROM phplist_listuser
LEFT JOIN phplist_user_user ON phplist_listuser.userid = phplist_user_user.id
where `listid` = 3
AND (
phplist_user_user.blacklisted = 0
AND phplist_user_user.confirmed = 1
)

#Server 2 - All active subscribers from TT
SELECT
phplist.phplist_user_user.id,
TRIM(LOWER(phplist_user_user.email)) as 'email',
phplist_user_user.uniqid,
'1' as 'Business'
FROM phplist.phplist_listuser
LEFT JOIN phplist.phplist_user_user ON phplist.phplist_listuser.userid = phplist.phplist_user_user.id
where `listid` = 4
AND (
phplist_user_user.blacklisted = 0
AND phplist_user_user.confirmed = 1
)

#Server 2 - All active subscribers from RM
SELECT
phplist.phplist_user_user.id,
TRIM(LOWER(phplist_user_user.email)) as 'email',
phplist_user_user.uniqid,
'1' as 'Business'
FROM phplist.phplist_listuser
LEFT JOIN phplist.phplist_user_user ON phplist.phplist_listuser.userid = phplist.phplist_user_user.id
where `listid` = 5
AND (
phplist_user_user.blacklisted = 0
AND phplist_user_user.confirmed = 1
)

#Server 2 - All folks who signed up for Workforce Development
SELECT
phplist.phplist_user_user.id,
TRIM(LOWER(phplist_user_user.email)) as 'email',
phplist_user_user.uniqid,
'1' as 'Business'
FROM phplist.phplist_listuser
LEFT JOIN phplist.phplist_user_user ON phplist.phplist_listuser.userid = phplist.phplist_user_user.id
where `listid` = 30
AND (
phplist_user_user.blacklisted = 0
AND phplist_user_user.confirmed = 1
)