Start Processing : 2025-06-14 15:15:38<BR>0 rows affectedINSERT
	IGNORE
INTO
	db_mailchimp_combined (_activityID, _prospectID, _email, _type, _campaignCode, _logo)
SELECT
	_id, _prospectID, _emailAddress, 'softBounce', _code, _logo
FROM
	db_mailchimp_bounce
WHERE
	_emailAddress NOT LIKE '%2x.marketing%'
	AND _emailAddress NOT LIKE '%test%' 
	AND _bounceType = 'soft'
	AND _id > (
	SELECT
		COALESCE(MAX(_maxID), 0)
	FROM
		lookup_daily_maxID
	WHERE
		_type = 'softBounce'
		AND _date < DATE_FORMAT(NOW(), '%Y-%m-%d') );<BR>[1] 0 seconds -> -1 rows affected<BR>INSERT
	IGNORE
INTO db_mailchimp_combined (_activityID, _prospectID, _email, _type, _campaignCode, _logo)
SELECT
	_id, _prospectID, _emailAddress, 'bounce', _code, _logo
FROM
	db_mailchimp_bounce
WHERE
	_emailAddress NOT LIKE '%2x.marketing%'
	AND _emailAddress NOT LIKE '%test%' 
	AND _id > (
	SELECT
		COALESCE(MAX(_maxID), 0)
	FROM
		lookup_daily_maxID
	WHERE
		_type = 'bounce'
		AND _date < DATE_FORMAT(NOW(), '%Y-%m-%d') );<BR>[4] 0 seconds -> -1 rows affected<BR>INSERT
	IGNORE
INTO
	db_mailchimp_combined (_activityID, _prospectID, _email, _type, _campaignCode, _logo)
SELECT
	_id, _prospectID, _emailAddress, 'hardBounce', _code, _l
FROM
	db_mailchimp_bounce
WHERE
	_emailAddress NOT LIKE '%2x.marketing%'
	AND _emailAddress NOT LIKE '%test%' 
	AND _bounceType = 'hard'
	AND _id > (
	SELECT
		COALESCE(MAX(_maxID), 0)
	FROM
		lookup_daily_maxID
	WHERE
		_type = 'hardBounce'
		AND _date < DATE_FORMAT(NOW(), '%Y-%m-%d') );<BR>[8] 0 seconds -> -1 rows affected<BR>