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 (2709637605,'161.129.201.229',0,'Sci Remc','','','Indianapolis','','Indiana','','US','United States','','','','','','','','','','','','','','',0,0,1)
UPDATE webtrack_segment SET _processed = 1,_creditUsed = 0, _isISP = '1', _companyName = 'Sci Remc', _country = 'United States' ,_website = '', _industry = '', _revenue = '' WHERE _ipAddr = '161.129.201.229' AND _processed = 0
UPDATE webtrack_segment SET _processed = 1,_creditUsed = 0, _isISP = '1', _companyName = 'Sci Remc', _country = 'United States' ,_website = '', _industry = '', _revenue = '' WHERE _ipAddr = '161.129.201.229' AND _processed = 0
UPDATE webtrack_segment SET _processed = 1,_creditUsed = 0, _isISP = '1', _companyName = 'Sci Remc', _country = 'United States' ,_website = '', _industry = '', _revenue = '' WHERE _ipAddr = '161.129.201.229' AND _processed = 0
60.53.88.233 is Malaysia, aborting
121.123.101.111 is Malaysia, aborting
121.123.101.111 is Malaysia, 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 (1153034674,'68.185.233.178',0,'Charter Communications','','','Slidell','','Louisiana','','US','United States','','','','','','','','','','','','','','',0,0,1)
99.79.54.134 is Canada, aborting
UPDATE webtrack_segment SET _processed = 1,_creditUsed = 0, _isISP = '1', _companyName = 'Net3 Technology, Inc', _country = 'United States' ,_website = 'n3t.com', _industry = 'Telephone Communication, Except Radiotelephone', _revenue = '$10,000,000 to $50,000,000' WHERE _ipAddr = '216.170.118.199' 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 (1532761605,'91.92.22.5',0,'HostRoyale Technologies Pvt Ltd','','','San Jose','','California','','US','United States','','','','','','','','','','','','','','',0,0,1)
UPDATE webtrack_segment SET _processed = 1,_creditUsed = 0, _isISP = '0', _companyName = 'Alphaa AI, Inc', _country = 'United States' ,_website = 'alphaa.ai', _industry = 'Prepackaged Software', _revenue = '$1,000,000 to $5,000,000' WHERE _ipAddr = '216.93.26.236' AND _processed = 0
UPDATE webtrack_segment SET _processed = 1,_creditUsed = 0, _isISP = '1', _companyName = 'Vtel Holdings, Ltd', _country = 'Saudi Arabia' ,_website = 'vtel.jo', _industry = 'Communications', _revenue = '$1,000,000 to $5,000,000' WHERE _ipAddr = '213.188.79.18' 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 (3636615610,'216.194.89.186',0,'HostRoyale Technologies Pvt Ltd','','','Chicago','','Illinois','','US','United States','','','','','','','','','','','','','','',0,0,1)
185.186.77.145 is Serbia, aborting
185.186.77.145 is Serbia, aborting
85.208.149.138 is Serbia, aborting
158.46.157.217 is United Kingdom of Great Britain and Northern Ireland, aborting
UPDATE webtrack_segment SET _processed = 1,_creditUsed = 0, _isISP = '0', _companyName = 'ConXion to Community', _country = 'United States' ,_website = 'conxion.org', _industry = 'Civic, Social, and Fraternal Associations', _revenue = '$1 to $1,000,000' WHERE _ipAddr = '206.204.59.25' AND _processed = 0
UPDATE webtrack_segment SET _processed = 1,_creditUsed = 0, _isISP = '1', _companyName = 'M247 Europe, SRL', _country = 'Romania' ,_website = 'm247.ro', _industry = 'Communication Services, Nec', _revenue = '$1,000,000 to $5,000,000' WHERE _ipAddr = '87.101.92.43' AND _processed = 0