Start Processing : 2025-06-14 12:34:16<BR>0 rows affectedUPDATE db_all_opportunity SET _createdDT = STR_TO_DATE(_createdDate, '%m/%d/%Y')<BR>[1] 0.05 seconds -> 0 rows affected<BR>UPDATE db_all_opportunity SET _closeDT = STR_TO_DATE(_closeDate, '%m/%d/%Y')<BR>[5] 0.06 seconds -> 0 rows affected<BR>UPDATE db_all_opportunity SET _lastStageChangeDT = STR_TO_DATE(_lastStageChangeDate, '%m/%d/%Y') WHERE LENGTH(_lastStageChangeDate)>0<BR>[10] 0.04 seconds -> 0 rows affected<BR>UPDATE db_all_opportunity SET _changeRevenue = IF(_lastNetAnnualizedDealRevenue != _netAnnualizedDealRevenue, 1, 0)<BR>[13] 0.06 seconds -> 0 rows affected<BR>INSERT IGNORE INTO db_opportunity_value_change (_opportunityID, _stage, _closeDate, _before, _after)
SELECT _opportunityID, _stage, _closeDT, _lastNetAnnualizedDealRevenue, _netAnnualizedDealRevenue 
FROM db_all_opportunity
WHERE _changeRevenue = 1 AND _createdDT < DATE_SUB(_lastUpdate, INTERVAL 1 DAY)<BR>[30] 0.01 seconds -> 0 rows affected<BR>UPDATE db_all_opportunity SET _lastNetAnnualizedDealRevenue = _netAnnualizedDealRevenue<BR>[50] 0.04 seconds -> 0 rows affected<BR>UPDATE db_all_opportunity SET _lastUpdate = CURDATE()<BR>[100] 0.03 seconds -> 0 rows affected<BR>UPDATE db_all_opportunity a, (SELECT MAX(_batchID) _batchID FROM db_all_opportunity) b SET a._deleted = 1 WHERE a._batchID != b._batchID<BR>[110] 0.07 seconds -> 0 rows affected<BR>