Start Processing : 2024-09-20 02:43:37<BR>0 rows affectedINSERT
	INTO
	map_download (_prospectID,
	_downloadID,
	_datetime,
	_download_title,
	_email,
	_utm_campaign)
SELECT
	_contactID,
	_id,
	STR_TO_DATE(_recentConversionDate,
	'%Y-%m-%e %H:%i:%s'),
	_recentConversion,
	_email,
	_contentDownloaded
FROM
	db_hubspot_campaign_mql
WHERE
	_email NOT LIKE '%2x.marketing%' AND _email NOT LIKE '%test%' AND _email NOT LIKE '%digitalhands%'
	AND _leadSource LIKE '%2X ABM%' 
ON
	DUPLICATE KEY
UPDATE
	_prospectID =
VALUES(_prospectID),
_datetime =
VALUES(_datetime),
_download_url =
VALUES(_download_url),
_email =
VALUES(_email),
_utm_campaign =
VALUES(_utm_campaign),
_utm_source =
VALUES(_utm_source)<BR>[10] 0.01 seconds -> 0 rows affected<BR>UPDATE map_download m, w_routables r 
SET m._persona = r._function, m._seniority = r._seniority 
WHERE m._email = r._email<BR>[20] 0.19 seconds -> 0 rows affected<BR>UPDATE map_download m, db_airtable_email e SET m._emailID = e._id WHERE m._utm_campaign = e._code<BR>[30] 0.03 seconds -> 99 rows affected<BR>UPDATE w_lead_downloads d, map_download m 
SET m._utm_source = d._utm_source
WHERE d._datasource = 'Hubspot-MQL-2021' AND d._email = m._email<BR>[40] 0.04 seconds -> 0 rows affected<BR>