Start Processing : 2025-06-14 14:57:47<BR>0 rows affectedhttps://api.airtable.com/v0/appkhaMrOdpRqwM06/tblk9BGCdEtEGTiZu?view=viwfeQvuimasJE89c&filterByFormula={Ticker}%3C1440<BR>https://api.airtable.com/v0/appkhaMrOdpRqwM06/tblDRclw6tr5TP8Aw?view=viwklMuqTaQl9DrjJ&filterByFormula={Ticker}%3C1440<BR>https://api.airtable.com/v0/appkhaMrOdpRqwM06/tblSywxsM0daX8hzO?view=viwxvGkOctqiM0rxn&filterByFormula={Ticker}%3C1440<BR><BR>[1] 2.47 seconds -> 0 rows affected<BR>INSERT 
	IGNORE 
INTO db_mailchimp_combined 
	(_activityID, _prospectID, _email, _type, _campaignCode, _logo) 
SELECT _id, _prospectID, _emailAddress, 'sends', _code, _logo
	FROM db_mailchimp_sent
	WHERE _emailAddress NOT LIKE '%2x.marketing%' 
	AND _emailAddress NOT LIKE '%test%' 	
	AND _id > 
	( SELECT COALESCE(MAX(_maxID), 0) 
	FROM lookup_daily_maxID WHERE _type = 'sends' AND _date < DATE_FORMAT(NOW(),'%Y-%m-%d')  )<BR>[5] 2.51 seconds -> -1 rows affected<BR>UPDATE db_mailchimp_combined c, w_routables r 
SET c._routablesID =  r._token 
WHERE c._email = r._email<BR>[7] 0.33 seconds -> 0 rows affected<BR>UPDATE db_mailchimp_combined dhc, db_airtable_email dae SET dhc.`_emailID` = dae.`_id` WHERE dhc.`_campaignCode` = dae.`_pardotID` AND dhc.`_emailID` = 0;<BR>[10] 0 seconds -> 0 rows affected<BR>UPDATE  db_mailchimp_combined  dhc, db_airtable_email dae SET dhc.`_utm_campaign` = dae .`_code` WHERE dhc.`_campaignCode` = dae.`_pardotID` AND dhc.`_utm_campaign` = 0;<BR>[13] 0 seconds -> -1 rows affected<BR>UPDATE  db_mailchimp_combined dhc, db_airtable_email dae SET dhc.`_datetime` = dae .`_liveDate` WHERE dhc.`_campaignCode` = dae.`_pardotID` AND dhc.`_datetime` = 0;<BR>[15] 0.01 seconds -> 0 rows affected<BR>INSERT INTO 
lookup_daily_maxID (_date, _type, _maxID) 
SELECT DATE_FORMAT(NOW(),'%Y-%m-%d'),_type, MAX(_activityID) 
FROM db_mailchimp_combined 
WHERE _activityID > 0 
GROUP BY _type
ON DUPLICATE KEY UPDATE _maxID = VALUES(_maxID)<BR>[100] 0.04 seconds -> 5 rows affected<BR>INSERT INTO map_download_sunfig (_prospectID, _downloadID, _datetime, _download_url, _url_param, _persona, _seniority,_download_title,_email,_utm_campaign, _utm_medium,_utm_source,_logo) 
SELECT _prospectNativeID, _id, _timestamp, _download_url,_url_param, _persona, _seniority, _download_title,_email, _utm_campaign, _utm_medium,_utm_source, 'Sunfig'
FROM w_lead_downloads_sunfig
WHERE _email NOT LIKE '%2x.marketing%' 
AND _email NOT LIKE '%test%' 
AND _email NOT LIKE '%terrasmart%' 
AND _utm_source = 'email' 
AND LENGTH(_url_param)>0 
ON DUPLICATE KEY UPDATE _prospectID = VALUES(_prospectID), _datetime = VALUES(_datetime), _download_url = VALUES(_download_url), _url_param = VALUES(_url_param), _persona = VALUES(_persona), _seniority = VALUES(_seniority), _download_title = VALUES(_download_title), _email = VALUES(_email),_utm_medium = VALUES(_utm_medium),_utm_campaign = VALUES(_utm_campaign),_utm_source = VALUES(_utm_source)<BR>[110] 0.02 seconds -> 100 rows affected<BR>UPDATE map_download_sunfig m, w_routables r SET m._persona = r._function, m._prospectID = r._token, m._seniority = r._seniority WHERE m._email = r._email<BR>[120] 0.1 seconds -> 50 rows affected<BR>UPDATE map_download_sunfig m, db_airtable_email e SET m._emailID = e._id WHERE m._utm_campaign = e._code<BR>[125] 0 seconds -> 0 rows affected<BR>UPDATE map_download_sunfig SET _trimCode = REPLACE(REPLACE(REPLACE(REPLACE(_utm_campaign,'-',''),'_',''),'(',''),')','')<BR>[130] 0 seconds -> 0 rows affected<BR>