Start Processing : 2025-06-14 11:57:04<BR>0 rows affectedINSERT IGNORE INTO db_pardot_combined (_activityID, _prospectID, _email, _type, _campaignCode,_trimCode, _datetime) SELECT _id, _prospectID, _email, 'clicks', _code,_code, STR_TO_DATE(_clickedAt, '%d-%m-%y %H:%i')  FROM db_pardot_click WHERE  _code IS NOT NULL AND _email NOT LIKE '%2x.marketing%' AND _email NOT LIKE '%test%' AND _email NOT LIKE '%daysmart%'AND STR_TO_DATE(_clickedAt, '%d-%m-%y %H:%i') IS NOT NULL AND LENGTH(_code) < 20;<BR>[10] 4.15 seconds -> 0 rows affected<BR>INSERT IGNORE INTO db_pardot_combined (_activityID, _prospectID, _email, _type, _campaignCode,_trimCode, _datetime) SELECT _id, _prospectID, _email, 'clicks', _code,_code, STR_TO_DATE(_clickedAt, '%b %e,%Y %h:%i %p')  FROM db_pardot_click WHERE  _code IS NOT NULL AND _email NOT LIKE '%2x.marketing%' AND _email NOT LIKE '%test%' AND _email NOT LIKE '%daysmart%' AND STR_TO_DATE(_clickedAt, '%b %e,%Y %h:%i %p') IS NOT NULL<BR>[20] 0.02 seconds -> 0 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>