Start Processing : 2025-05-12 23:30:10<BR>0 rows affectedUPDATE dashboard_email_performance_ss a, (SELECT _campaignName, MAX(_dateEvent) FROM db_sharpspring_campaign_combined GROUP BY 1 ORDER BY 2 DESC LIMIT 100) b
SET _downloads = 0 WHERE a._title = b._campaignName<BR>[10] 2.86 seconds -> 128 rows affected<BR>INSERT INTO dashboard_email_performance_ss ( _title, _persona, _seniority, _downloads) 
	SELECT * FROM
		(SELECT _utm_campaign _title, IF(_persona NOT IN ('0','Finance','Health Professionals','Operations'),'Others',_persona) _persona, _seniority, COUNT(DISTINCT(_email)) _downloads FROM w_lead_downloads a, (SELECT _campaignName, MAX(_dateEvent) FROM db_sharpspring_campaign_combined group BY 1 ORDER BY 2 DESC LIMIT 100) q 
WHERE (_utm_medium = 'email' OR _utm_source = 'Email')
		AND _routable_status NOT IN ('unqualified','require enrichment')
		AND _email NOT REGEXP '2x|test|3si'
                AND a._utm_campaign IN (q._campaignName) 
GROUP BY 1,2,3) a
		ON DUPLICATE KEY UPDATE _downloads = a._downloads<BR>[20] 2.05 seconds -> 256 rows affected<BR>