Mise à jour vers wp_ip_fai OK
Insertion vers IP_COMMUNES OK
Insertion vers IP_COMMUNES OK
Update vers IP_COMMUNES OK
Update vers IP_COMMUNES OK
Update vers IP_COMMUNES OK
Update vers wp_ip_pays OK
Insertion vers wp_ip_pays OK
Insertion vers wp_ ip_pays OK
Update vers IP_PAYS_COMMUNS OK
SELECT `Rang0`, `Rang1`, `Rang2`, INet_AToN(Concat(`Rang0`, '.', `Rang1`, '.',`Rang2`, '.1')) AS `IP_NUMBER` ,Concat(`Rang0`, '.', `Rang1`, '.',`Rang2`, '.1') as IP_CONCAT FROM `IP_COMMUNES` WHERE `Ville` = '' ORDER BY `Rang0`, `Rang1`, `Rang2` LIMIT 0, 1000
SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 59768577 BETWEEN `IP_FROM` AND `IP_TO`
SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 66652929 BETWEEN `IP_FROM` AND `IP_TO`
SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 244002049 BETWEEN `IP_FROM` AND `IP_TO`
SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 586213633 BETWEEN `IP_FROM` AND `IP_TO`
SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 586299137 BETWEEN `IP_FROM` AND `IP_TO`
SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 786755585 BETWEEN `IP_FROM` AND `IP_TO`
SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 1475867905 BETWEEN `IP_FROM` AND `IP_TO`
SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 1541975553 BETWEEN `IP_FROM` AND `IP_TO`
SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 1732648193 BETWEEN `IP_FROM` AND `IP_TO`
SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 1806353409 BETWEEN `IP_FROM` AND `IP_TO`
SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 1925841409 BETWEEN `IP_FROM` AND `IP_TO`
SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 3165023489 BETWEEN `IP_FROM` AND `IP_TO`
SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 3416434177 BETWEEN `IP_FROM` AND `IP_TO`
SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 3579564801 BETWEEN `IP_FROM` AND `IP_TO`
UPDATE wp_ip_fai SET FOURNISSEUR='Amazon Technologies Inc.' ,Ville ='Seattle' , Pays = 'US' WHERE Rang0 = 3 and Rang1 = 249 and Rang2 = 11 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Amazon Technologies Inc.' ,Ville ='Seattle' , Pays = 'US' WHERE Rang0 = 3 and Rang1 = 143 and Rang2 = 255 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Amazon Data Services Ireland Limited' ,Ville ='Dublin' , Pays = 'IE' WHERE Rang0 = 34 and Rang1 = 240 and Rang2 = 233 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Amazon Data Services Ireland Limited' ,Ville ='Dublin' , Pays = 'IE' WHERE Rang0 = 203 and Rang1 = 162 and Rang2 = 166 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Amazon Data Services Ireland Limited' ,Ville ='Dublin' , Pays = 'IE' WHERE Rang0 = 188 and Rang1 = 166 and Rang2 = 109 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='SK Broadband Co Ltd' ,Ville ='Seoul' , Pays = 'KR' WHERE Rang0 = 114 and Rang1 = 202 and Rang2 = 2 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Prime Multitask Pvt. Ltd.' ,Ville ='Ahmedabad' , Pays = 'IN' WHERE Rang0 = 103 and Rang1 = 70 and Rang2 = 29 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Irideos S.p.A.' ,Ville ='Rome' , Pays = 'IT' WHERE Rang0 = 46 and Rang1 = 228 and Rang2 = 240 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Amazon Data Services Ireland Limited' ,Ville ='Dublin' , Pays = 'IE' WHERE Rang0 = 34 and Rang1 = 242 and Rang2 = 55 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Indira Gandhi National Tribal University Amarkantak' ,Ville ='Amarkantak' , Pays = 'IN' WHERE Rang0 = 14 and Rang1 = 139 and Rang2 = 45 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='DigitalOcean LLC' ,Ville ='San Francisco' , Pays = 'US' WHERE Rang0 = 107 and Rang1 = 170 and Rang2 = 196 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='DigitalOcean LLC' ,Ville ='San Francisco' , Pays = 'US' WHERE Rang0 = 213 and Rang1 = 91 and Rang2 = 211 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='ENTER S.r.l.' ,Ville ='Milan' , Pays = 'IT' WHERE Rang0 = 87 and Rang1 = 247 and Rang2 = 245 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Zfort Group Ltd' ,Ville ='Kharkiv' , Pays = 'UA' WHERE Rang0 = 91 and Rang1 = 232 and Rang2 = 174 ; 1SELECT `Rang0`, `Rang1`, `Rang2` , Concat(`Rang0`, '.', `Rang1`, '.',`Rang2`, '.1') as IP_CONCAT3 FROM `IP_COMMUNES` WHERE `Ville` ='' OR Ville ='XX' ORDER BY `DERNIERE_VISITE` DESC LIMIT 0, 5000
UPDATE IP_COMMUNES SET FOURNISSEUR='Zfort Group Ltd' ,Ville ='Kharkiv' , Pays = 'UA' WHERE Rang0 = 91 and Rang1 = 232 and Rang2 = 174 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Amazon Technologies Inc.' ,Ville ='Seattle' , Pays = 'US' WHERE Rang0 = 3 and Rang1 = 143 and Rang2 = 255 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Amazon Data Services Ireland Limited' ,Ville ='Dublin' , Pays = 'IE' WHERE Rang0 = 34 and Rang1 = 240 and Rang2 = 233 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Amazon Data Services Ireland Limited' ,Ville ='Dublin' , Pays = 'IE' WHERE Rang0 = 203 and Rang1 = 162 and Rang2 = 166 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Amazon Data Services Ireland Limited' ,Ville ='Dublin' , Pays = 'IE' WHERE Rang0 = 188 and Rang1 = 166 and Rang2 = 109 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='SK Broadband Co Ltd' ,Ville ='Seoul' , Pays = 'KR' WHERE Rang0 = 114 and Rang1 = 202 and Rang2 = 2 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Prime Multitask Pvt. Ltd.' ,Ville ='Ahmedabad' , Pays = 'IN' WHERE Rang0 = 103 and Rang1 = 70 and Rang2 = 29 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Irideos S.p.A.' ,Ville ='Rome' , Pays = 'IT' WHERE Rang0 = 46 and Rang1 = 228 and Rang2 = 240 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Amazon Data Services Ireland Limited' ,Ville ='Dublin' , Pays = 'IE' WHERE Rang0 = 34 and Rang1 = 242 and Rang2 = 55 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Indira Gandhi National Tribal University Amarkantak' ,Ville ='Amarkantak' , Pays = 'IN' WHERE Rang0 = 14 and Rang1 = 139 and Rang2 = 45 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='DigitalOcean LLC' ,Ville ='San Francisco' , Pays = 'US' WHERE Rang0 = 107 and Rang1 = 170 and Rang2 = 196 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='DigitalOcean LLC' ,Ville ='San Francisco' , Pays = 'US' WHERE Rang0 = 213 and Rang1 = 91 and Rang2 = 211 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='ENTER S.r.l.' ,Ville ='Milan' , Pays = 'IT' WHERE Rang0 = 87 and Rang1 = 247 and Rang2 = 245 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Amazon Technologies Inc.' ,Ville ='Seattle' , Pays = 'US' WHERE Rang0 = 3 and Rang1 = 249 and Rang2 = 11 ; 1
city_name | ISP | country_code |
---|
Le suivi des visites par pays(Nbr d'enregistrement :=> 157)
| Les adresses de FAI inconnus(Nbr d'enregistrement :=> 0) | Les adresses de COMMUNES inconnues(Nbr d'enregistrement :=> 0)
|