27.242.10.231 is Taiwan (Province of China), aborting
INSERT IGNORE INTO webtrack_ipcompany (_ipDecimal,_ipAddr,_CID,_name,_website,_street,_city,_regionShort,_region,_postal,_countryShort,_country,_phone,_employees,_revenue,_category,_sicCode,_sicGroup,_category2,_naicsCode,_latitude,_longitude,_stockSymbol,_facebook,_twitter,_linkedIn,_linkedInID,_confidence,_isISP) VALUES (2551668320,'152.23.94.96',0,'University of North Carolina at Chapel Hill','www.unc.edu','','Chapel Hill','','North Carolina','','US','United States','','','','','','','','','','','','','','',0,0,1)
UPDATE webtrack_segment SET _processed = 1,_creditUsed = 0, _isISP = '0', _companyName = '', _country = 'India' ,_website = '', _industry = '', _revenue = '' WHERE _ipAddr = '14.98.19.205' AND _processed = 0
INSERT IGNORE INTO webtrack_ipcompany (_ipDecimal,_ipAddr,_CID,_name,_website,_street,_city,_regionShort,_region,_postal,_countryShort,_country,_phone,_employees,_revenue,_category,_sicCode,_sicGroup,_category2,_naicsCode,_latitude,_longitude,_stockSymbol,_facebook,_twitter,_linkedIn,_linkedInID,_confidence,_isISP) VALUES (1662061701,'99.17.12.133',0,'AT&T Corp.','','','Houston','','Texas','','US','United States','','','','','','','','','','','','','','',0,0,1)
121.7.128.87 is Singapore, aborting
INSERT IGNORE INTO webtrack_ipcompany (_ipDecimal,_ipAddr,_CID,_name,_website,_street,_city,_regionShort,_region,_postal,_countryShort,_country,_phone,_employees,_revenue,_category,_sicCode,_sicGroup,_category2,_naicsCode,_latitude,_longitude,_stockSymbol,_facebook,_twitter,_linkedIn,_linkedInID,_confidence,_isISP) VALUES (1241391889,'73.254.35.17',0,'Comcast Cable Communications, LLC','','','Redmond','','Washington','','US','United States','','','','','','','','','','','','','','',0,0,1)
UPDATE webtrack_segment SET _processed = 1,_creditUsed = 0, _isISP = '0', _companyName = '', _country = 'United States' ,_website = '', _industry = '', _revenue = '' WHERE _ipAddr = '205.169.39.127' AND _processed = 0
147.161.149.91 is Belgium, aborting
UPDATE webtrack_segment SET _processed = 1,_creditUsed = 0, _isISP = '1', _companyName = 'Zscaler, Inc', _country = 'United States' ,_website = 'zscaler.com', _industry = 'Prepackaged Software', _revenue = '$1,000,000,000+' WHERE _ipAddr = '165.225.17.12' AND _processed = 0
INSERT IGNORE INTO webtrack_ipcompany (_ipDecimal,_ipAddr,_CID,_name,_website,_street,_city,_regionShort,_region,_postal,_countryShort,_country,_phone,_employees,_revenue,_category,_sicCode,_sicGroup,_category2,_naicsCode,_latitude,_longitude,_stockSymbol,_facebook,_twitter,_linkedIn,_linkedInID,_confidence,_isISP) VALUES (1677542189,'99.253.67.45',0,'Rogers Communications','','','Brantford','','Ontario','','CA','Canada','','','','','','','','','','','','','','',0,0,1)
UPDATE webtrack_segment SET _processed = 1,_creditUsed = 0, _isISP = '0', _companyName = '', _country = 'India' ,_website = '', _industry = '', _revenue = '' WHERE _ipAddr = '136.226.253.3' AND _processed = 0
119.82.105.106 is India, aborting
193.54.23.132 is France, aborting
UPDATE webtrack_segment SET _processed = 1,_creditUsed = 0, _isISP = '1', _companyName = 'Comcast Corporation', _country = 'United States' ,_website = 'xfinity.com', _industry = 'Communications', _revenue = '$1,000,000,000+' WHERE _ipAddr = '73.175.116.210' AND _processed = 0
UPDATE webtrack_segment SET _processed = 1,_creditUsed = 0, _isISP = '0', _companyName = 'InterContinental Hotels Group, PLC', _country = 'United Kingdom' ,_website = 'ihg.com', _industry = 'Hotels, Rooming Houses, Camps, and Other Lodging Places', _revenue = '$1,000,000,000+' WHERE _ipAddr = '172.254.141.133' AND _processed = 0
INSERT IGNORE INTO webtrack_ipcompany (_ipDecimal,_ipAddr,_CID,_name,_website,_street,_city,_regionShort,_region,_postal,_countryShort,_country,_phone,_employees,_revenue,_category,_sicCode,_sicGroup,_category2,_naicsCode,_latitude,_longitude,_stockSymbol,_facebook,_twitter,_linkedIn,_linkedInID,_confidence,_isISP) VALUES (1235569913,'73.165.76.249',0,'Comcast Cable Communications, LLC','','','Philadelphia','','Pennsylvania','','US','United States','','','','','','','','','','','','','','',0,0,1)
INSERT IGNORE INTO webtrack_ipcompany (_ipDecimal,_ipAddr,_CID,_name,_website,_street,_city,_regionShort,_region,_postal,_countryShort,_country,_phone,_employees,_revenue,_category,_sicCode,_sicGroup,_category2,_naicsCode,_latitude,_longitude,_stockSymbol,_facebook,_twitter,_linkedIn,_linkedInID,_confidence,_isISP) VALUES (1614559490,'96.60.57.2',0,'TDS Telecom','','','Farragut','','Tennessee','','US','United States','','','','','','','','','','','','','','',0,0,1)
UPDATE webtrack_segment SET _processed = 1,_creditUsed = 0, _isISP = '1', _companyName = 'Whitesky Communications, LLC', _country = 'United States' ,_website = 'whitesky.us', _industry = 'Communications', _revenue = '$10,000,000 to $50,000,000' WHERE _ipAddr = '52.124.42.52' AND _processed = 0
UPDATE webtrack_segment SET _processed = 1,_creditUsed = 0, _isISP = '0', _companyName = 'Duke University', _country = 'United States' ,_website = 'duke.edu', _industry = 'Colleges, Universities, and Professional Schools', _revenue = '$1,000,000,000+' WHERE _ipAddr = '152.3.43.52' AND _processed = 0
UPDATE webtrack_segment SET _processed = 1,_creditUsed = 0, _isISP = '0', _companyName = '', _country = 'United States' ,_website = '', _industry = '', _revenue = '' WHERE _ipAddr = '66.249.83.134' AND _processed = 0