Start Processing : 2024-09-20 02:27:24<BR>0 rows affectedUPDATE db_opportunity SET _ARR = _MRR WHERE LENGTH(_MRR)>0<BR>[1] 0.64 seconds -> 0 rows affected<BR>UPDATE db_opportunity SET _createTS = STR_TO_DATE(_createdDate, '%m/%d/%Y') , _closeTS= STR_TO_DATE(_closeDate, '%m/%d/%Y')<BR>[3] 0.05 seconds -> 0 rows affected<BR>UPDATE db_opportunity SET _createDT = UNIX_TIMESTAMP(_createTS), _closeDT = UNIX_TIMESTAMP(_closeTS)<BR>[5] 0.08 seconds -> 0 rows affected<BR>UPDATE db_opportunity SET _fiscalPeriod = CONCAT(YEAR(_closeTS),'-','Q',QUARTER(_closeTS))<BR>[10] 0.06 seconds -> 0 rows affected<BR>UPDATE db_opportunity SET _weighted = _ARR * _probability/100, _isActive = 0<BR>[15] 0.08 seconds -> 447 rows affected<BR>UPDATE db_opportunity d INNER JOIN (SELECT _accountID, MIN(_closeDT) '_dt' FROM db_opportunity WHERE _probability = 100 GROUP BY _accountID ) o SET d._firstDeal = 1 WHERE d._accountID = o._accountID AND d._closeDT = o._dt<BR>[20] 0.12 seconds -> 0 rows affected<BR>UPDATE db_opportunity d INNER JOIN (SELECT _accountID, MIN(_closeDT) '_dt' FROM db_opportunity WHERE _probability = 100 GROUP BY _accountID ) o SET d._firstDeal = 0 WHERE d._accountID = o._accountID AND d._closeDT > o._dt<BR>[30] 0.12 seconds -> 0 rows affected<BR>UPDATE db_opportunity o, db_account a SET o._accountIndustry = a._industry, o._accountSubIndustry = a._subIndustry, o._accountDomain = REPLACE(REPLACE(REPLACE(a._website,'www.',''),'https://','http://'),'http://','') WHERE o._accountID = a._accountID<BR>[40] 0.81 seconds -> 0 rows affected<BR>UPDATE db_opportunity SET _isActive = 1 WHERE _stage NOT IN ('01 - Preparation','01 - Qualification','Closed Won','Closed Lost','Rejected - No Opportunity','Closed Duplicate')<BR>[50] 0.19 seconds -> 447 rows affected<BR>UPDATE db_opportunity SET _bucket = 'Sales' WHERE _primaryCampaignSource LIKE '%Sales%' OR LENGTH(_primaryCampaignSource)=0 OR _primaryCampaignSource LIKE '%BDR%'<BR>[60] 0.06 seconds -> 0 rows affected<BR>UPDATE db_opportunity SET _bucket = 'Marketing' WHERE _primaryCampaignSource = 'Sales Email Inbound'<BR>[70] 0.02 seconds -> 0 rows affected<BR>UPDATE db_opportunity SET _marketingCategory = 'Website' WHERE _bucket = 'Marketing' AND _primaryCampaignSource IN ('Drift','SEO','SEM','Direct','Sales Email Inbound','Marketing Referral','Sponsored Content','Email Marketing')<BR>[80] 0.02 seconds -> 0 rows affected<BR>UPDATE db_activity a INNER JOIN (SELECT _opportunityID, _stage, _opportunityName, _primaryCampaignSource,_ARR FROM db_opportunity) o SET a._stage = o._stage, _sfdcName = _opportunityName, _sfdcType = 'Opportunity',_campaignSource = o._primaryCampaignSource, a._ARR = o._ARR WHERE a._sfdcName IS NULL AND a._sfdcID = o._opportunityID<BR>[140] 0.7 seconds -> 0 rows affected<BR>