INSERT IGNORE INTO abm_account_domain (_companyName, _domain, _segment1) SELECT _companyName, RIGHT(_email, LENGTH(_email)- POSITION('@' IN _email)), _industry FROM w_routables  WHERE _email NOT LIKE '%2x.marketing%' AND _email NOT LIKE '%3si%' AND _email NOT LIKE '%gmail%' AND _email NOT LIKE '%outlook%' AND _email NOT LIKE '%hotmail%' AND _companyName NOT LIKE '%atlas%' AND _companyName NOT LIKE '%2X Marketing%' AND LENGTH(_companyName)>0  GROUP BY _companyName, RIGHT(_email, LENGTH(_email)- POSITION('@' IN _email)),_industry<BR>UPDATE abm_account_domain a INNER JOIN (SELECT _companyName, MAX(REPLACE(REPLACE(_revenueRange,'$',''),',','')) '_mx' FROM w_routables GROUP BY _companyName) o SET a._segment2 = 'N/A' WHERE a._companyName = o._companyName AND o._mx >= 0 AND o._mx < 1<BR>UPDATE abm_account_domain a INNER JOIN (SELECT _companyName, MAX(REPLACE(REPLACE(_revenueRange,'$',''),',','')) '_mx' FROM w_routables GROUP BY _companyName) o SET a._segment2 = 'Below 5M' WHERE a._companyName = o._companyName AND o._mx >= 1 AND o._mx < 5000000<BR>UPDATE abm_account_domain a INNER JOIN (SELECT _companyName, MAX(REPLACE(REPLACE(_revenueRange,'$',''),',','')) '_mx' FROM w_routables GROUP BY _companyName) o SET a._segment2 = '5 - 10M' WHERE a._companyName = o._companyName AND o._mx >= 5000000 AND o._mx < 10000000<BR>UPDATE abm_account_domain a INNER JOIN (SELECT _companyName, MAX(REPLACE(REPLACE(_revenueRange,'$',''),',','')) '_mx' FROM w_routables GROUP BY _companyName) o SET a._segment2 = '10 - 25M' WHERE a._companyName = o._companyName AND o._mx >= 10000000 AND o._mx < 25000000<BR>UPDATE abm_account_domain a INNER JOIN (SELECT _companyName, MAX(REPLACE(REPLACE(_revenueRange,'$',''),',','')) '_mx' FROM w_routables GROUP BY _companyName) o SET a._segment2 = '25 - 100M' WHERE a._companyName = o._companyName AND o._mx >= 25000000 AND o._mx < 100000000<BR>UPDATE abm_account_domain a INNER JOIN (SELECT _companyName, MAX(REPLACE(REPLACE(_revenueRange,'$',''),',','')) '_mx' FROM w_routables GROUP BY _companyName) o SET a._segment2 = '100M - 1B' WHERE a._companyName = o._companyName AND o._mx >= 100000000 AND o._mx < 1000000000<BR>UPDATE abm_account_domain a INNER JOIN (SELECT _companyName, MAX(REPLACE(REPLACE(_revenueRange,'$',''),',','')) '_mx' FROM w_routables GROUP BY _companyName) o SET a._segment2 = 'Above 1B' WHERE a._companyName = o._companyName AND o._mx >= 1000000000 AND o._mx < 9999999999999<BR>INSERT IGNORE INTO abm_accounts (_companyName, _segment1, _segment2, _dateAdded) SELECT _companyName, _segment1, _segment2, NOW() FROM abm_account_domain GROUP BY _companyName, _segment1, _segment2<BR>