Start Processing : 2024-09-20 02:45:29<BR>0 rows affectedUPDATE db_opportunity
SET
_closeTS = STR_TO_DATE(_closeDate, '%c/%e/%Y');<BR>[1] 1.35 seconds -> 0 rows affected<BR>INSERT IGNORE INTO db_opportunity_temp
SELECT _id, _rowNumber, _batchID, _ownerRole, _opportunityOwner, a._accountName, _opportunityName, _stage, _fiscalPeriod, _amount, _probability, _age, _closeDate, _createdDate, _nextStep, _leadSource, _type, _primaryContact, _primaryCampaignSource, _contactTitle
FROM db_opportunity a
INNER JOIN
    (SELECT _accountName, MAX(_closeTS) AS _MAXcloseTS
    FROM db_opportunity
    GROUP BY _accountName) b 
ON a._accountName = b._accountName
AND a._closeTS = b._MAXcloseTS;<BR>[2] 8.05 seconds -> 0 rows affected<BR>