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