Start Processing : 2024-09-20 02:42:34<BR>0 rows affectedUPDATE db_sharpspring_campaign_open SET _campaignName = _emailTitle WHERE _toCombined = 0<BR>[10] 2.85 seconds -> 0 rows affected<BR>UPDATE db_sharpspring_campaign_open SET _campaignName = '2020-09-22_3SI-CH-01_pharmacy_manager_W1' WHERE _emailTitle = '2020-09-22_3SI-CH-01_pharmacy_manager_W1 - 1'<BR>[20] 0.79 seconds -> 0 rows affected<BR>INSERT IGNORE INTO db_sharpspring_campaign_combined (_activityID, _campaignName, _email, _type, _dateEvent)
SELECT _id, _campaignName, _email, 'Open', STR_TO_DATE(_mostRecentOpenDate,'%m/%d/%Y %H:%i') FROM db_sharpspring_campaign_open
		 WHERE _campaignName IN (SELECT _code FROM db_airtable_email) AND _toCombined = 0<BR>[30] 0.69 seconds -> 0 rows affected<BR>UPDATE db_sharpspring_campaign_open a, (SELECT DISTINCT _batchID FROM db_sharpspring_campaign_open ORDER BY 1 DESC LIMIT 30) b
SET a._toCombined = 1
WHERE a._batchID = b._batchID AND _campaignName IN (SELECT _code FROM db_airtable_email)<BR>[35] 2.25 seconds -> 0 rows affected<BR>