Start Processing : 2024-09-20 02:30:50
0 rows affectedINSERT
IGNORE
INTO db_mailchimp_combined (_activityID, _prospectID, _email, _type, _campaignCode, _logo)
SELECT
_id, _prospectID, _emailAddress, 'unsubscribes', _code, _logo
FROM
db_mailchimp_unsubscribed
WHERE
_emailAddress NOT LIKE '%2x.marketing%'
AND _emailAddress NOT LIKE '%test%'
AND _id > (
SELECT
COALESCE(MAX(_maxID), 0)
FROM
lookup_daily_maxID
WHERE
_type = 'unsubscribes'
AND _date < DATE_FORMAT(NOW(), '%Y-%m-%d') );
[9] 0.01 seconds -> -1 rows affected