Start Processing : 2025-03-15 10:46:04
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.33 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] 2.33 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.34 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.1 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