Start Processing : 2025-03-15 02:40:55<BR>0 rows affectedUPDATE db_contact SET _domain = RIGHT(_email,LENGTH(_email)-POSITION('@' IN _email)) WHERE LENGTH(_email)>0<BR>[1] 0.64 seconds -> 0 rows affected<BR>UPDATE db_account a, db_contact c SET c._website = a._website, c._industry = a._industry WHERE a._accountID = c._accountID<BR>[10] 0.98 seconds -> 0 rows affected<BR>UPDATE db_account a, db_contact c SET a._domain = c._domain WHERE a._accountID = c._accountID AND c._domain NOT IN ('gmail.com','yahoo.com','comcast.net','aol.com','hotmail.com','icloud.com')<BR>[20] 0.38 seconds -> 0 rows affected<BR>UPDATE db_contact c, db_opportunity_contact o SET c._opportunityID = o._opportunityID WHERE c._contactID = o._contactID<BR>[30] 0.2 seconds -> 0 rows affected<BR>UPDATE db_contact SET _createTS = STR_TO_DATE(_createdDate, '%m/%d/%Y')  WHERE LENGTH(_createdDate)>0<BR>[40] 0.23 seconds -> 0 rows affected<BR>UPDATE db_contact SET _tampull = '0' WHERE _tampull NOT LIKE '%PULL%'<BR>[50] 0.12 seconds -> 0 rows affected<BR>UPDATE db_contact SET _tampull = '1' WHERE _tampull LIKE '%PULL%'<BR>[51] 0.09 seconds -> 0 rows affected<BR>update db_contact set _tamExist ='Yes' where _tampull = '1'<BR>[60] 0.09 seconds -> 0 rows affected<BR>update db_contact set _tamExist ='No' where _tampull = '0'<BR>[61] 0.09 seconds -> 0 rows affected<BR>UPDATE db_opportunity o, view_tam_exist v SET o._tamexist ='Yes' WHERE v._tamExist>0 AND v._opportunityID <> '' AND o._opportunityID = v._opportunityID<BR>[62] 0.01 seconds -> -1 rows affected<BR>