ips.sql

select ip_addr, request_dt, os_guess
from p0f inner join os_guess_d
	on p0f.os_guess_id =  os_guess_d.os_guess_id
where ip_addr in (
	'103.95.197.62', '107.180.120.45', '107.180.120.64', '107.180.120.67',
	'112.78.2.202', '113.212.162.149', '118.123.16.54', '119.59.120.3',
	'121.127.254.2', '122.114.43.148', '132.148.104.129', '148.72.232.52',
	'149.202.83.87', '151.1.184.134', '158.69.8.115', '160.153.147.139',
	'162.241.216.242', '162.241.218.136', '162.241.226.121', '168.167.251.215',
	'173.201.196.110', '173.201.196.148', '176.31.236.164', '178.210.90.90',
	'178.210.90.90', '182.50.130.35', '182.50.135.55', '182.50.151.55',
	'184.168.152.99', '184.168.200.228', '184.168.27.12', '184.168.27.140',
	'184.168.46.128', '185.26.122.29', '188.187.190.59', '192.185.83.194',
	'194.54.82.78', '195.74.38.66', '198.71.238.11', '198.71.238.17',
	'198.71.238.6', '198.71.238.9', '198.71.239.45', '198.71.239.47',
	'198.71.239.9', '207.148.119.51', '207.246.249.205', '209.175.164.195',
	'210.61.49.127', '212.174.107.137', '212.63.109.204', '213.142.130.42',
	'34.197.246.236', '42.98.72.36', '45.40.166.153', '50.62.176.242',
	'50.62.177.187', '50.62.208.38', '50.63.194.158', '50.87.144.119',
	'50.87.144.56', '62.210.185.4', '66.147.240.198', '78.24.221.82',
	'79.170.40.55', '81.91.86.129', '82.209.199.218', '85.128.142.46',
	'85.128.142.58', '91.200.60.68', '95.58.31.174'
)
;