Start Processing : 2025-03-15 01:35:34<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 '%geoforce%' 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.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, '%b %e,%Y %h:%i %p')  FROM db_pardot_open WHERE  _email NOT LIKE '%2x.marketing%' AND _email NOT LIKE '%geoforce%' 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] 3.5 seconds -> -1 rows affected<BR>UPDATE db_pardot_combined SET _trimCode = REPLACE(_trimCode ,'(','')<BR>[22] 0.15 seconds -> -1 rows affected<BR>UPDATE db_pardot_combined SET _trimCode = REPLACE(_trimCode ,')','')<BR>[25] 1.54 seconds -> -1 rows affected<BR>UPDATE db_pardot_combined SET _trimCode = REPLACE(_trimCode ,'_','')<BR>[30] 2.89 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 seconds -> 0 rows affected<BR>