Start Processing : 2025-06-14 14:38:17
0 rows affectedINSERT
IGNORE
INTO db_mailchimp_combined (_activityID, _prospectID, _email, _type, _campaignCode, _logo)
SELECT _id, _prospectID, _emailAddress, 'opens', _code, _logo
FROM db_mailchimp_open
WHERE
_emailAddress NOT LIKE '%2x.marketing%'
AND _emailAddress NOT LIKE '%test%'
AND _id >
( SELECT COALESCE(MAX(_maxID), 0)
FROM lookup_daily_maxID
WHERE _type = 'opens' AND _date < DATE_FORMAT(NOW(),'%Y-%m-%d') )
[1] 0.01 seconds -> -1 rows affected