Mise à jour de la table COMMUNE vers wp_ip_fai OK
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) Pays Nom image Nbr FAI Nbr de visites AD Andorre 1 1 AE Emirats Arabe Unis 27 386 AF Afghanistan 2 68 AG Antigua-et-Barbuda 2 3 AM Arménie 12 348 AN ANTILLES NEERLANDAISES 1 1 AO Angola 11 151 AQ ANTARCTIQUE 1 3 AR Argentine 113 3705 AT Autriche 48 1353 AU Australie 795 40331 AZ Azerbaijan 11 43 BA Bosnie-Herzegovine 22 682 BB Barbade 2 2 BD Bangladesh 93 956 BE Belgique 1997 138334 BF BurkinaFaso 1 1 BG Bulgarie 190 14403 BH BAHRAIN 7 1199 BI Burundi 1 17 BJ Bénin 6 9 BN Brunei 1 1 BO Bolivie 8 21 BR Brésil 499 15958 BT Bhoutan 1 3 BW Botswana 1 1 BY Belarus 238 18621 BZ Belize 2 17 CA Canada 1945 129940 CH Suisse 88 1499 CI Cote d'ivoire 32 793 CL Chilie 34 1096 CM Cameroun 16 95 CN Chine 147 6583 CO Colombie 101 2075 CR Costa Rica 3 33 CY Chypre 15 881 CZ Republique Tcheque 186 3806 DE Allemagne 437 29017 DK Danemark 139 66031 DO Republique Dominicaine 8 183 DZ Algérie 61 294 EC Equateur 24 41 EE Estonie 14 287 EG Egypte 105 1293 ES Espagne 234 8810 FI Finlande 29 1495 FR France 1644 240236 GA Gabon 1 9 GB Grande Bretagne 1369 66948 GE Georgie 24 475 GH Ghana 6 43 GN Guinee Equatoriale 1 8 GP GUADELOUPE 1 1 GR Grece 59 1329 GT Guatemala 2 5 GW Guinée Bissau 1 2 HK Hong-Kong 185 5108 HN Honduras 4 19 HR Croatie 29 1141 HU Hongrie 89 1413 ID Indonesie 656 12589 IE Irelande 342 20525 IL Israel 68 30421 IN Inde 716 16897 IQ Iraq 5 18 IR Iran 155 5453 IS Islande 11 486 IT Italie 458 18615 JM Jamaïque 3 43 JO Jordanie 4 38 JP Japon 381 14085 KE Kenya 9 97 KG Kyrgyzstan 8 240 KH Cambodge 40 262 KN Saint-Kitts-et-Nevis 1 3 KR Coree du sud 529 21293 KW Koweit 3 12 KZ Kazakhstan 51 667 LA Laos 9 219 LB Liban 10 29 LK Sri Lanka 15 228 LR Liberia 1 3 LS Lésotho 9 100 LT Lituanie 50 579 LU Luxembourg 30 429 LV Lettonie 37 2523 LY Libye 11 484 MA Maroc 68 622 MC Monaco 3 9 MD Moldavie 18 184 ME Montenegro 8 246 MK Macedoine (Ex republique Yugoslave) 13 231 MM Myanmar 8 119 MN Mongolie 14 300 MO Moldavie 8 43 MT Malte 2 22 MU Iles Maurice 10 111 MW Malawi 3 36 MX Mexique 109 3185 MY Malaisie 87 6489 NA Namibie 1 23 NC Nouvelle-Caledonie 11 111 NG Nigeria 4 4 NI Nicaragua 2 2 NL Pays-bas 767 175855 NO Norvege 32 925 NP Nepal 31 1073 NZ Nouvelle Zélande 37 569 OM Sultana d'Oman 3 11 PA Panama 3 386 PE Perou 40 676 PF Polynésie Française 2 2 PH Philippine 93 1643 PK Pakistan 128 2375 PL Pologne 54 2227 PR Puerto Rico 4 40 PS Palestine 18 121 PT Portugal 70 3567 PY Paraguay 7 11 QA Quatar 1 4 RO Roumanie 341 8681 RS Serbie 43 1733 RU Russie 1931 268903 RW Rwanda 2 12 SA Arabie-saoudite 110 12699 SC Seychelles 7 69 SD Soudan 5 12 SE Suede 148 27976 SG Singapour 326 7168 SI Slovénie 25 1815 SK Slovaquie 18 611 SN Senegal 18 292 SO Somalie 1 1 SR Suriname 5 253 SV San Salvador 5 12 SY Syrie 6 44 SZ Swaziland 1 4 TG Togo 1 1 TH Thailande 275 5964 TJ Tadjikistan 5 296 TN Tunisie 40 500 TR Turquie 255 10485 TT Trinidad et Tobago 1 2 TW Taiwan 109 9580 TZ Tanzanie 88 1384 UA Ukraine 519 33180 UG Uganda 2 46 US USA 16870 1118981 UY Uruguay 22 588 UZ Ousbekistan 17 712 VE Venezuela 37 687 VI Iles Vierge USA 1 1 VN Vietnam 1782 35551 YE Yemen 11 58 ZA Afrique au Sud 71 661 ZM Zambie 1 10

Les adresses de FAI inconnus(Nbr d'enregistrement :=> 0)

Les adresses de COMMUNES inconnues(Nbr d'enregistrement :=> 0) Adresse_IP Fournisseur TEST