YABANCI VE TR IP LOGLARI KARIŞIK

CREATE TABLE IF NOT EXISTS random_visitors (
id INTEGER PRIMARY KEY AUTOINCREMENT,
query_time TEXT,
ip TEXT,
country TEXT,
city TEXT,
region TEXT,
lat REAL,
lon REAL,
timezone TEXT,
isp TEXT,
org TEXT,
mobile INTEGER,
proxy INTEGER,
hosting INTEGER
);
INSERT INTO random_visitors
(query_time, ip, country, city, region, lat, lon, timezone, isp, org, mobile, proxy, hosting)
VALUES ('2026-04-05 22:53:21', '126.23.212.118', 'Japan',
'Minato', 'Tokyo',
35.6552, 139.761, 'Asia/Tokyo',
'SoftBank Corp.', 'SOFTBANK Corp',
0, 0, 0);
INSERT INTO random_visitors
(query_time, ip, country, city, region, lat, lon, timezone, isp, org, mobile, proxy, hosting)
VALUES ('2026-04-05 22:53:21', '36.61.1.64', 'China',
'Hefei', 'Anhui',
31.8616, 117.286, 'Asia/Shanghai',
'Chinanet', 'Chinanet AH',
0, 0, 0);
INSERT INTO random_visitors
(query_time, ip, country, city, region, lat, lon, timezone, isp, org, mobile, proxy, hosting)
VALUES ('2026-04-05 22:53:21', '198.193.197.85', 'United States',
'Richardson', 'Texas',
32.9844, -96.7035, 'America/Chicago',
'MCI/SAE', 'MCI/SAE',
0, 0, 0);
INSERT INTO random_visitors
(query_time, ip, country, city, region, lat, lon, timezone, isp, org, mobile, proxy, hosting)
VALUES ('2026-04-05 22:53:21', '158.60.40.11', 'China',
'Beijing', 'Beijing',
39.9042, 116.407, 'Asia/Shanghai',
'AIPO', 'AIPO Cloud (Guizhou) Technology Co., Ltd.',
0, 0, 0);
INSERT INTO random_visitors
(query_time, ip, country, city, region, lat, lon, timezone, isp, org, mobile, proxy, hosting)
VALUES ('2026-04-05 22:53:21', '106.85.155.123', 'China',
'Chongqing', 'Chongqing',
29.5689, 106.5577, 'Asia/Shanghai',
'Chinanet', 'Chinanet CQ',
0, 0, 0);
INSERT INTO random_visitors
(query_time, ip, country, city, region, lat, lon, timezone, isp, org, mobile, proxy, hosting)
VALUES ('2026-04-05 22:53:21', '188.94.110.247', 'United Kingdom',
'Manor Park', 'England',
51.5539, 0.0487, 'Europe/London',
'Anschutz Sports Holdings Limited', 'Anschutz Sports Holdings Limited',
0, 0, 0);



DEVAMI VE HEPSİ İÇİN : https://dosya.co/z5ne3t7jbudd/random-ips-log.sql.html