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 610214145 BETWEEN `IP_FROM` AND `IP_TO`

SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 697021185 BETWEEN `IP_FROM` AND `IP_TO`

SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 701774337 BETWEEN `IP_FROM` AND `IP_TO`

SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 772442881 BETWEEN `IP_FROM` AND `IP_TO`

SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 1719750145 BETWEEN `IP_FROM` AND `IP_TO`

SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 1734036737 BETWEEN `IP_FROM` AND `IP_TO`

SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 1737111041 BETWEEN `IP_FROM` AND `IP_TO`

SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 1979473153 BETWEEN `IP_FROM` AND `IP_TO`

SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 2525037825 BETWEEN `IP_FROM` AND `IP_TO`

SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 2717962497 BETWEEN `IP_FROM` AND `IP_TO`

SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 2824510721 BETWEEN `IP_FROM` AND `IP_TO`

SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 3125622785 BETWEEN `IP_FROM` AND `IP_TO`

SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 3174236673 BETWEEN `IP_FROM` AND `IP_TO`

SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 3275918337 BETWEEN `IP_FROM` AND `IP_TO`

SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 3288461313 BETWEEN `IP_FROM` AND `IP_TO`

SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 3301451521 BETWEEN `IP_FROM` AND `IP_TO`

SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 3580750337 BETWEEN `IP_FROM` AND `IP_TO`

UPDATE wp_ip_fai SET FOURNISSEUR='Vision Telecom Private Limited' ,Ville ='Lahore' , Pays = 'PK' WHERE Rang0 = 162 and Rang1 = 0 and Rang2 = 209 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Xnet Internet Services (Pty) Ltd' ,Ville ='Cape Town' , Pays = 'ZA' WHERE Rang0 = 102 and Rang1 = 129 and Rang2 = 78 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Xnet Internet Services (Pty) Ltd' ,Ville ='Cape Town' , Pays = 'ZA' WHERE Rang0 = 195 and Rang1 = 66 and Rang2 = 140 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Ebone Network Pvt. Ltd.' ,Ville ='Karachi' , Pays = 'PK' WHERE Rang0 = 150 and Rang1 = 129 and Rang2 = 5 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Ebone Network Pvt. Ltd.' ,Ville ='Karachi' , Pays = 'PK' WHERE Rang0 = 196 and Rang1 = 1 and Rang2 = 240 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Starnet Broaband Services private limited' ,Ville ='Jind' , Pays = 'IN' WHERE Rang0 = 103 and Rang1 = 91 and Rang2 = 77 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Broadlink' ,Ville ='Pretoria' , Pays = 'ZA' WHERE Rang0 = 41 and Rang1 = 212 and Rang2 = 58 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Broadlink' ,Ville ='Pretoria' , Pays = 'ZA' WHERE Rang0 = 196 and Rang1 = 200 and Rang2 = 39 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='PT Ajusnet Lintas Global Data' ,Ville ='Denpasar' , Pays = 'ID' WHERE Rang0 = 103 and Rang1 = 138 and Rang2 = 54 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='For Converged Services in Eastern Region' ,Ville ='Nairobi' , Pays = 'KE' WHERE Rang0 = 41 and Rang1 = 139 and Rang2 = 179 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='For Converged Services in Eastern Region' ,Ville ='Nairobi' , Pays = 'KE' WHERE Rang0 = 168 and Rang1 = 90 and Rang2 = 157 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Bharat Sanchar Nigam Limited' ,Ville ='Delhi' , Pays = 'IN' WHERE Rang0 = 117 and Rang1 = 252 and Rang2 = 93 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='ChinaNet Zhejiang Province Network' ,Ville ='Hangzhou' , Pays = 'CN' WHERE Rang0 = 36 and Rang1 = 95 and Rang2 = 33 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='ChinaNet Zhejiang Province Network' ,Ville ='Hangzhou' , Pays = 'CN' WHERE Rang0 = 189 and Rang1 = 51 and Rang2 = 2 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='BTC-Customer WiFast Services' ,Ville ='Sofia' , Pays = 'BG' WHERE Rang0 = 46 and Rang1 = 10 and Rang2 = 139 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='BTC-Customer WiFast Services' ,Ville ='Sofia' , Pays = 'BG' WHERE Rang0 = 213 and Rang1 = 109 and Rang2 = 234 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='BTC-Customer WiFast Services' ,Ville ='Sofia' , Pays = 'BG' WHERE Rang0 = 186 and Rang1 = 77 and Rang2 = 56 ; 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='BTC-Customer WiFast Services' ,Ville ='Sofia' , Pays = 'BG' WHERE Rang0 = 186 and Rang1 = 77 and Rang2 = 56 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Xnet Internet Services (Pty) Ltd' ,Ville ='Cape Town' , Pays = 'ZA' WHERE Rang0 = 102 and Rang1 = 129 and Rang2 = 78 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Xnet Internet Services (Pty) Ltd' ,Ville ='Cape Town' , Pays = 'ZA' WHERE Rang0 = 195 and Rang1 = 66 and Rang2 = 140 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Ebone Network Pvt. Ltd.' ,Ville ='Karachi' , Pays = 'PK' WHERE Rang0 = 150 and Rang1 = 129 and Rang2 = 5 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Ebone Network Pvt. Ltd.' ,Ville ='Karachi' , Pays = 'PK' WHERE Rang0 = 196 and Rang1 = 1 and Rang2 = 240 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Starnet Broaband Services private limited' ,Ville ='Jind' , Pays = 'IN' WHERE Rang0 = 103 and Rang1 = 91 and Rang2 = 77 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Broadlink' ,Ville ='Pretoria' , Pays = 'ZA' WHERE Rang0 = 41 and Rang1 = 212 and Rang2 = 58 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Broadlink' ,Ville ='Pretoria' , Pays = 'ZA' WHERE Rang0 = 196 and Rang1 = 200 and Rang2 = 39 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='PT Ajusnet Lintas Global Data' ,Ville ='Denpasar' , Pays = 'ID' WHERE Rang0 = 103 and Rang1 = 138 and Rang2 = 54 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='For Converged Services in Eastern Region' ,Ville ='Nairobi' , Pays = 'KE' WHERE Rang0 = 41 and Rang1 = 139 and Rang2 = 179 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='For Converged Services in Eastern Region' ,Ville ='Nairobi' , Pays = 'KE' WHERE Rang0 = 168 and Rang1 = 90 and Rang2 = 157 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Bharat Sanchar Nigam Limited' ,Ville ='Delhi' , Pays = 'IN' WHERE Rang0 = 117 and Rang1 = 252 and Rang2 = 93 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='ChinaNet Zhejiang Province Network' ,Ville ='Hangzhou' , Pays = 'CN' WHERE Rang0 = 36 and Rang1 = 95 and Rang2 = 33 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='ChinaNet Zhejiang Province Network' ,Ville ='Hangzhou' , Pays = 'CN' WHERE Rang0 = 189 and Rang1 = 51 and Rang2 = 2 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='BTC-Customer WiFast Services' ,Ville ='Sofia' , Pays = 'BG' WHERE Rang0 = 46 and Rang1 = 10 and Rang2 = 139 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='BTC-Customer WiFast Services' ,Ville ='Sofia' , Pays = 'BG' WHERE Rang0 = 213 and Rang1 = 109 and Rang2 = 234 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Vision Telecom Private Limited' ,Ville ='Lahore' , Pays = 'PK' WHERE Rang0 = 162 and Rang1 = 0 and Rang2 = 209 ; 1

city_name	ISP	country_code

Le suivi des visites par pays(Nbr d'enregistrement :=> 167) Pays Nom image Nbr FAI Nbr de visites AD Andorre 2 2 AE Emirats Arabe Unis 107 510 AF Afghanistan 6 117 AG Antigua-et-Barbuda 4 5 AL Anguilla 1 4 AM Arménie 15 376 AN ANTILLES NEERLANDAISES 1 1 AO Angola 38 188 AQ ANTARCTIQUE 1 3 AR Argentine 195 8920 AT Autriche 180 1708 AU Australie 995 43014 AZ Azerbaijan 14 89 BA Bosnie-Herzegovine 77 1149 BB Barbade 2 2 BD Bangladesh 222 1997 BE Belgique 2053 150759 BF BurkinaFaso 2 2 BG Bulgarie 265 21205 BH BAHRAIN 17 1211 BI Burundi 1 17 BJ Bénin 13 37 BN Brunei 6 18 BO Bolivie 10 28 BR Brésil 911 19905 BT Bhoutan 1 3 BW Botswana 4 6 BY Belarus 263 21491 BZ Belize 4 19 CA Canada 2102 140885 CD Congo ex Zaïre 2 7 CH Suisse 99 1576 CI Cote d'ivoire 54 912 CL Chilie 46 1275 CM Cameroun 84 747 CN Chine 347 9172 CO Colombie 542 3235 CR Costa Rica 5 37 CV Cap Vert 1 3 CW Curaçao 3 9 CY Chypre 18 980 CZ Republique Tcheque 264 4203 DE Allemagne 783 47789 DK Danemark 156 74499 DO Republique Dominicaine 42 234 DZ Algérie 229 498 EC Equateur 52 118 EE Estonie 149 1632 EG Egypte 427 2614 ES Espagne 374 9823 FI Finlande 61 2395 FR France 1870 303297 GA Gabon 6 15 GB Grande Bretagne 1865 80805 GE Georgie 41 718 GH Ghana 20 91 GN Guinee Equatoriale 2 9 GP GUADELOUPE 1 1 GR Grece 127 1543 GT Guatemala 3 6 GW Guinée Bissau 1 2 HK Hong-Kong 526 7280 HN Honduras 9 31 HR Croatie 70 1208 HU Hongrie 196 1739 ID Indonesie 1491 32655 IE Irelande 1526 40766 IL Israel 78 36799 IN Inde 1358 21469 IQ Iraq 40 71 IR Iran 338 6313 IS Islande 12 516 IT Italie 532 19815 JM Jamaïque 15 78 JO Jordanie 13 51 JP Japon 514 15631 KE Kenya 49 195 KG Kyrgyzstan 15 249 KH Cambodge 63 520 KN Saint-Kitts-et-Nevis 1 3 KR Coree du sud 674 22572 KW Koweit 10 31 KZ Kazakhstan 68 726 LA Laos 19 310 LB Liban 19 41 LK Sri Lanka 83 357 LR Liberia 2 4 LS Lésotho 16 140 LT Lituanie 91 634 LU Luxembourg 32 517 LV Lettonie 66 2617 LY Libye 135 664 MA Maroc 169 747 MC Monaco 3 9 MD Moldavie 21 198 ME Montenegro 19 869 MG Madagascar 12 19 MK Macedoine (Ex republique Yugoslave) 46 288 MM Myanmar 13 135 MN Mongolie 18 315 MO Moldavie 13 49 MQ 1 10 MT Malte 5 27 MU Iles Maurice 47 231 MV Maldives 4 4 MW Malawi 5 38 MX Mexique 116 3258 MY Malaisie 293 7160 MZ Mozambique 3 3 NA Namibie 10 39 NC Nouvelle-Caledonie 11 111 NG Nigeria 10 13 NI Nicaragua 23 51 NL Pays-bas 1355 204304 NO Norvege 45 1700 NP Nepal 52 1140 NZ Nouvelle Zélande 63 641 OM Sultana d'Oman 29 43 PA Panama 3 386 PE Perou 292 2339 PF Polynésie Française 2 2 PG 1 5 PH Philippine 491 2530 PK Pakistan 346 3017 PL Pologne 96 3170 PR Puerto Rico 13 71 PS Palestine 36 379 PT Portugal 89 3850 PY Paraguay 10 15 QA Quatar 9 21 RO Roumanie 526 9409 RS Serbie 112 2173 RU Russie 2353 291700 RW Rwanda 3 16 SA Arabie-saoudite 196 21078 SC Seychelles 7 70 SD Soudan 7 14 SE Suede 191 28549 SG Singapour 873 14632 SI Slovénie 51 1911 SK Slovaquie 30 658 SN Senegal 36 762 SO Somalie 4 4 SR Suriname 5 277 SV San Salvador 6 15 SY Syrie 13 53 SZ Swaziland 2 7 TG Togo 1 1 TH Thailande 857 8983 TJ Tadjikistan 5 308 TN Tunisie 60 527 TR Turquie 1084 13484 TT Trinidad et Tobago 2 3 TW Taiwan 224 16539 TZ Tanzanie 96 1442 UA Ukraine 640 43756 UG Uganda 8 71 US USA 23467 1333541 UY Uruguay 32 1256 UZ Ousbekistan 17 843 VE Venezuela 38 695 VI Iles Vierge USA 1 1 VN Vietnam 2734 41073 YE Yemen 18 65 ZA Afrique au Sud 308 1420 ZM Zambie 9 25 ZW Zimbabwe 1 1

Les adresses de FAI inconnus