Start Processing : 2025-03-17 17:40:22
0 rows affectedUPDATE db_abm_leads SET _dateTS= STR_TO_DATE(_dateReceived, '%m/%d/%Y')
[10] 0.01 seconds -> 0 rows affected
UPDATE db_abm_leads i, db_account a SET i._segment1 = a._industry WHERE i._accountID = a._accountID
[20] 2.66 seconds -> 0 rows affected
UPDATE db_abm_leads i, db_account a SET i._segment2 = 'Target 850' WHERE i._accountID = a._accountID AND a._isTarget = '1'
[30] 1.89 seconds -> 0 rows affected
UPDATE db_abm_leads i INNER JOIN (SELECT _accountID FROM db_account_segments WHERE _segment = 'Unpenetrated Accounts') a SET i._segment3 = 'Unpenetrated' WHERE i._accountID = a._accountID
[40] 1.24 seconds -> 0 rows affected
UPDATE db_abm_leads i INNER JOIN (SELECT _accountID FROM db_account_segments WHERE _segment = 'Top 100 SBA') a SET i._segment4 = 'Top 100 SBA' WHERE i._accountID = a._accountID
[50] 0.08 seconds -> 0 rows affected
UPDATE db_abm_leads SET _ww = WEEK(_dateTS,3), _yy = YEAR(_dateTS), _quarter = QUARTER(_dateTS)
[60] 0 seconds -> 0 rows affected