Start Processing : 2026-10-25 06:48:13<BR>0 rows affectedUPDATE IGNORE db_pardot_open SET _code= '2020_07_14_EB_01_W2_CSuite' WHERE _code= '2020_07_14_EB_01_W2_CSuites'<BR>[1] 0.01 seconds -> 0 rows affected<BR>INSERT IGNORE INTO db_pardot_combined (_activityID, _prospectID, _email, _type, _campaignCode, _datetime) SELECT _id, _prospectID, _email, 'opens', _code, STR_TO_DATE(_openedAt, '%m/%e/%Y %H:%i')  FROM db_pardot_open WHERE  _email NOT LIKE '%2x.marketing%' AND _email NOT LIKE '%test%' AND _email NOT LIKE '%phoenix%' AND  STR_TO_DATE(_openedAt, '%m/%e/%Y %H:%i') IS NOT NULL AND _id > ( SELECT COALESCE(MAX(_maxID), 0) FROM lookup_daily_maxID WHERE _type = 'opens' AND _date < DATE_FORMAT(NOW(),'%Y-%m-%d')   )<BR>[3] 0.02 seconds -> 0 rows affected<BR>INSERT IGNORE INTO db_pardot_combined (_activityID, _prospectID, _email, _type, _campaignCode, _datetime) SELECT _id, _prospectID, _email, 'opens', _code, STR_TO_DATE(_openedAt, '%b %e,%Y %h:%i %p')  FROM db_pardot_open WHERE  _email NOT LIKE '%2x.marketing%' AND _email NOT LIKE '%test%' AND _email NOT LIKE '%phoenix%' AND STR_TO_DATE(_openedAt, '%b %e,%Y %h:%i %p') IS NOT NULL AND _id > ( SELECT COALESCE(MAX(_maxID), 0) FROM lookup_daily_maxID WHERE _type = 'opens' AND _date < DATE_FORMAT(NOW(),'%Y-%m-%d')  )<BR>[5] 0 seconds -> 0 rows affected<BR>UPDATE db_pardot_combined SET _trimCode = REPLACE(_campaignCode,'-','')<BR>[20] 5.17 seconds -> 0 rows affected<BR>UPDATE db_pardot_combined SET _trimCode = REPLACE(_trimCode ,'(','')<BR>[22] 2.29 seconds -> 0 rows affected<BR>UPDATE db_pardot_combined SET _trimCode = REPLACE(_trimCode ,')','')<BR>[25] 0.01 seconds -> -1 rows affected<BR>UPDATE db_pardot_combined SET _trimCode = REPLACE(_trimCode ,'_','')<BR>[30] 0.01 seconds -> -1 rows affected<BR>UPDATE db_pardot_combined c, db_airtable_email e SET c._emailID = e._id WHERE c._trimCode = e._trimCode<BR>[40] 0.01 seconds -> -1 rows affected<BR>