10.000 Adet TR VE YABANCI LOG KARIŞIK

CREATE TABLE IF NOT EXISTS random_visitors_deep (
id INTEGER PRIMARY KEY AUTOINCREMENT,
query_time TEXT,
ip TEXT,
country TEXT,
country_code TEXT,
continent TEXT,
continent_code TEXT,
region TEXT,
city TEXT,
zip TEXT,
lat REAL,
lon REAL,
timezone TEXT,
offset INTEGER,
currency TEXT,
isp TEXT,
asn TEXT,
asname TEXT,
reverse_dns TEXT,
mobile INTEGER,
proxy INTEGER,
hosting INTEGER
);
INSERT INTO random_visitors_deep
(query_time, ip, country, country_code, continent, continent_code, region, city, zip, lat, lon, timezone,
offset, currency, isp, asn, asname, reverse_dns, mobile, proxy, hosting)
VALUES ('2026-04-05 23:40:12', '118.147.156.5', 'China',
'CN', 'Asia', 'AS',
'Fujian', 'Xiamen',
'361000', 24.4795, 118.089,
'Asia/Shanghai', 28800, 'CNY',
'CNC Group CHINA169 Fujian Province network', '',
'', 'Unknown',
0, 0, 0);
INSERT INTO random_visitors_deep
(query_time, ip, country, country_code, continent, continent_code, region, city, zip, lat, lon, timezone,
offset, currency, isp, asn, asname, reverse_dns, mobile, proxy, hosting)
VALUES ('2026-04-05 23:40:12', '192.71.222.191', 'Sweden',
'SE', 'Europe', 'EU',
'Stockholm County', 'Stockholm',
'100 04', 59.3327, 18.0656,
'Europe/Stockholm', 7200, 'SEK',
'Binero AB', 'AS35041 Binero AB',
'NET-BINERO-STHLM1', 'Unknown',
0, 0, 1);
INSERT INTO random_visitors_deep
(query_time, ip, country, country_code, continent, continent_code, region, city, zip, lat, lon, timezone,
offset, currency, isp, asn, asname, reverse_dns, mobile, proxy, hosting)
VALUES ('2026-04-05 23:40:12', '55.238.193.20', 'United States',
'US', 'North America', 'NA',
'Ohio', 'Columbus',
'43218', 39.9819, -82.9048,
'America/New_York', -14400, 'USD',
'DoD Network Information Center', 'AS721 United States Department of Defense (DoD)',
'DNIC-ASBLK-00721-00726', 'Unknown',
0, 0, 0);
INSERT INTO random_visitors_deep
(query_time, ip, country, country_code, continent, continent_code, region, city, zip, lat, lon, timezone,
offset, currency, isp, asn, asname, reverse_dns, mobile, proxy, hosting)
VALUES ('2026-04-05 23:40:12', '136.251.179.127', 'United States',
'US', 'North America', 'NA',
'Texas', 'Houston',
'77042', 29.7335, -95.5564,
'America/Chicago', -18000, 'USD',
'Schlumberger Limited', 'AS72 Schlumberger Limited',
'SCHLUMBERGER-AS', 'Unknown',
0, 0, 0);
INSERT INTO random_visitors_deep
(query_time, ip, country, country_code, continent, continent_code, region, city, zip, lat, lon, timezone,
offset, currency, isp, asn, asname, reverse_dns, mobile, proxy, hosting)
VALUES ('2026-04-05 23:40:12', '191.222.85.42', 'Brazil',
'BR', 'South America', 'SA',
'São Paulo', 'São Paulo',
'01000-000', -23.5558, -46.6396,
'America/Cuiaba', -14400, 'BRL',
'V tal', 'AS8167 V tal',
'V tal', 'Unknown',
0, 0, 0);


Devamı : https://dosya.co/gdd2najoass4/random-ips-log.sql.html