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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

UPDATE wp_ip_fai SET FOURNISSEUR='' ,Ville ='' , Pays = 'KR' WHERE Rang0 = 205 and Rang1 = 147 and Rang2 = 109 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='SingTel Optus Pty Ltd' ,Ville ='St Leonards' , Pays = 'AU' WHERE Rang0 = 161 and Rang1 = 35 and Rang2 = 112 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='DigitalOcean LLC' ,Ville ='New York City' , Pays = 'US' WHERE Rang0 = 107 and Rang1 = 170 and Rang2 = 172 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='DigitalOcean LLC' ,Ville ='New York City' , Pays = 'US' WHERE Rang0 = 220 and Rang1 = 118 and Rang2 = 83 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='DigitalOcean LLC' ,Ville ='New York City' , Pays = 'US' WHERE Rang0 = 195 and Rang1 = 201 and Rang2 = 15 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Computer Sciences Corporation' ,Ville ='Falls Church' , Pays = 'US' WHERE Rang0 = 20 and Rang1 = 55 and Rang2 = 75 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Amazon Technologies Inc.' ,Ville ='Seattle' , Pays = 'US' WHERE Rang0 = 18 and Rang1 = 168 and Rang2 = 148 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='SingTel Optus Pty Ltd' ,Ville ='St Leonards' , Pays = 'AU' WHERE Rang0 = 161 and Rang1 = 35 and Rang2 = 74 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Netprotect SRL' ,Ville ='Ganesti' , Pays = 'RO' WHERE Rang0 = 89 and Rang1 = 43 and Rang2 = 31 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Prirodoslovno Matematicki Fakultet-Matematicki Odsjek' ,Ville ='Zagreb' , Pays = 'HR' WHERE Rang0 = 161 and Rang1 = 49 and Rang2 = 215 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='DigitalOcean LLC' ,Ville ='London' , Pays = 'GB' WHERE Rang0 = 159 and Rang1 = 65 and Rang2 = 28 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Google LLC' ,Ville ='Mountain View' , Pays = 'US' WHERE Rang0 = 104 and Rang1 = 196 and Rang2 = 241 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Google LLC' ,Ville ='Mountain View' , Pays = 'US' WHERE Rang0 = 34 and Rang1 = 83 and Rang2 = 145 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Google LLC' ,Ville ='Mountain View' , Pays = 'US' WHERE Rang0 = 34 and Rang1 = 83 and Rang2 = 9 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Google LLC' ,Ville ='Mountain View' , Pays = 'US' WHERE Rang0 = 34 and Rang1 = 82 and Rang2 = 172 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Google LLC' ,Ville ='Amsterdam' , Pays = 'NL' WHERE Rang0 = 34 and Rang1 = 105 and Rang2 = 75 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Google LLC' ,Ville ='Mountain View' , Pays = 'US' WHERE Rang0 = 35 and Rang1 = 227 and Rang2 = 144 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Halliburton Company' ,Ville ='Houston' , Pays = 'US' WHERE Rang0 = 34 and Rang1 = 123 and Rang2 = 143 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Amazon Data Services Ireland Limited' ,Ville ='Dublin' , Pays = 'IE' WHERE Rang0 = 34 and Rang1 = 240 and Rang2 = 8 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Saudi Telecom Company JSC' ,Ville ='Riyadh' , Pays = 'SA' WHERE Rang0 = 95 and Rang1 = 217 and Rang2 = 3 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Amazon Technologies Inc.' ,Ville ='Singapore' , Pays = 'SG' WHERE Rang0 = 54 and Rang1 = 179 and Rang2 = 137 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='AccessKenya Group' ,Ville ='Nairobi' , Pays = 'KE' WHERE Rang0 = 41 and Rang1 = 215 and Rang2 = 85 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='1G Railtel Link from Nic Bhubaneswar' ,Ville ='Padampur' , Pays = 'IN' WHERE Rang0 = 164 and Rang1 = 90 and Rang2 = 134 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Amazon Technologies Inc.' ,Ville ='Dublin' , Pays = 'IE' WHERE Rang0 = 54 and Rang1 = 74 and Rang2 = 120 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Google LLC' ,Ville ='Mountain View' , Pays = 'US' WHERE Rang0 = 35 and Rang1 = 198 and Rang2 = 227 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Adonai Consulting and Technology Solutions Pvt Ltd' ,Ville ='Singapore' , Pays = 'SG' WHERE Rang0 = 119 and Rang1 = 81 and Rang2 = 55 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Amazon Technologies Inc.' ,Ville ='Columbus' , Pays = 'US' WHERE Rang0 = 52 and Rang1 = 15 and Rang2 = 205 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Microsoft Corporation' ,Ville ='Bristow' , Pays = 'US' WHERE Rang0 = 40 and Rang1 = 117 and Rang2 = 129 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Amazon Technologies Inc.' ,Ville ='Seattle' , Pays = 'US' WHERE Rang0 = 3 and Rang1 = 249 and Rang2 = 157 ; 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='Amazon Technologies Inc.' ,Ville ='Seattle' , Pays = 'US' WHERE Rang0 = 205 and Rang1 = 147 and Rang2 = 109 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Amazon Technologies Inc.' ,Ville ='Seattle' , Pays = 'US' WHERE Rang0 = 220 and Rang1 = 118 and Rang2 = 83 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Google LLC' ,Ville ='Mountain View' , Pays = 'US' WHERE Rang0 = 34 and Rang1 = 83 and Rang2 = 145 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Google LLC' ,Ville ='Mountain View' , Pays = 'US' WHERE Rang0 = 104 and Rang1 = 196 and Rang2 = 241 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='DigitalOcean LLC' ,Ville ='London' , Pays = 'GB' WHERE Rang0 = 159 and Rang1 = 65 and Rang2 = 28 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Prirodoslovno Matematicki Fakultet-Matematicki Odsjek' ,Ville ='Zagreb' , Pays = 'HR' WHERE Rang0 = 161 and Rang1 = 49 and Rang2 = 215 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Netprotect SRL' ,Ville ='Ganesti' , Pays = 'RO' WHERE Rang0 = 89 and Rang1 = 43 and Rang2 = 31 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='SingTel Optus Pty Ltd' ,Ville ='St Leonards' , Pays = 'AU' WHERE Rang0 = 161 and Rang1 = 35 and Rang2 = 74 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Amazon Technologies Inc.' ,Ville ='Seattle' , Pays = 'US' WHERE Rang0 = 18 and Rang1 = 168 and Rang2 = 148 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Computer Sciences Corporation' ,Ville ='Falls Church' , Pays = 'US' WHERE Rang0 = 20 and Rang1 = 55 and Rang2 = 75 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Computer Sciences Corporation' ,Ville ='Falls Church' , Pays = 'US' WHERE Rang0 = 195 and Rang1 = 201 and Rang2 = 15 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='DigitalOcean LLC' ,Ville ='New York City' , Pays = 'US' WHERE Rang0 = 107 and Rang1 = 170 and Rang2 = 172 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='SingTel Optus Pty Ltd' ,Ville ='St Leonards' , Pays = 'AU' WHERE Rang0 = 161 and Rang1 = 35 and Rang2 = 112 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Google LLC' ,Ville ='Mountain View' , Pays = 'US' WHERE Rang0 = 34 and Rang1 = 83 and Rang2 = 9 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Google LLC' ,Ville ='Mountain View' , Pays = 'US' WHERE Rang0 = 34 and Rang1 = 82 and Rang2 = 172 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Google LLC' ,Ville ='Amsterdam' , Pays = 'NL' WHERE Rang0 = 34 and Rang1 = 105 and Rang2 = 75 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Microsoft Corporation' ,Ville ='Bristow' , Pays = 'US' WHERE Rang0 = 40 and Rang1 = 117 and Rang2 = 129 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Amazon Technologies Inc.' ,Ville ='Columbus' , Pays = 'US' WHERE Rang0 = 52 and Rang1 = 15 and Rang2 = 205 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Adonai Consulting and Technology Solutions Pvt Ltd' ,Ville ='Singapore' , Pays = 'SG' WHERE Rang0 = 119 and Rang1 = 81 and Rang2 = 55 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Google LLC' ,Ville ='Mountain View' , Pays = 'US' WHERE Rang0 = 35 and Rang1 = 198 and Rang2 = 227 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Amazon Technologies Inc.' ,Ville ='Dublin' , Pays = 'IE' WHERE Rang0 = 54 and Rang1 = 74 and Rang2 = 120 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='1G Railtel Link from Nic Bhubaneswar' ,Ville ='Padampur' , Pays = 'IN' WHERE Rang0 = 164 and Rang1 = 90 and Rang2 = 134 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='AccessKenya Group' ,Ville ='Nairobi' , Pays = 'KE' WHERE Rang0 = 41 and Rang1 = 215 and Rang2 = 85 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Amazon Technologies Inc.' ,Ville ='Singapore' , Pays = 'SG' WHERE Rang0 = 54 and Rang1 = 179 and Rang2 = 137 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Saudi Telecom Company JSC' ,Ville ='Riyadh' , Pays = 'SA' WHERE Rang0 = 95 and Rang1 = 217 and Rang2 = 3 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Amazon Data Services Ireland Limited' ,Ville ='Dublin' , Pays = 'IE' WHERE Rang0 = 34 and Rang1 = 240 and Rang2 = 8 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Halliburton Company' ,Ville ='Houston' , Pays = 'US' WHERE Rang0 = 34 and Rang1 = 123 and Rang2 = 143 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Google LLC' ,Ville ='Mountain View' , Pays = 'US' WHERE Rang0 = 35 and Rang1 = 227 and Rang2 = 144 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Amazon Technologies Inc.' ,Ville ='Seattle' , Pays = 'US' WHERE Rang0 = 3 and Rang1 = 249 and Rang2 = 157 ; 1
city_nameISPcountry_code

Le suivi des
visites par pays(Nbr d'enregistrement :=> 157)
PaysNomimageNbr FAINbr de visites
ADAndorre11
AEEmirats Arabe Unis27386
AFAfghanistan269
AGAntigua-et-Barbuda23
AMArménie12363
ANANTILLES NEERLANDAISES11
AOAngola11151
AQANTARCTIQUE13
ARArgentine1306950
ATAutriche501383
AUAustralie82841032
AZAzerbaijan1148
BABosnie-Herzegovine23731
BBBarbade22
BDBangladesh1051050
BEBelgique2014142113
BFBurkinaFaso11
BGBulgarie19615533
BHBAHRAIN71199
BIBurundi117
BJBénin69
BNBrunei11
BOBolivie821
BRBrésil52616803
BTBhoutan13
BWBotswana11
BYBelarus23919247
BZBelize217
CACanada1979132988
CHSuisse881499
CICote d'ivoire33822
CLChilie391143
CMCameroun1695
CNChine1687112
COColombie1012140
CRCosta Rica333
CYChypre16922
CZRepublique Tcheque1913915
DEAllemagne50233421
DKDanemark14267864
DORepublique Dominicaine8183
DZAlgérie61303
ECEquateur2441
EEEstonie16379
EGEgypte1101389
ESEspagne2478968
FIFinlande332143
FRFrance1691258660
GAGabon19
GBGrande Bretagne142569267
GEGeorgie24531
GHGhana643
GNGuinee Equatoriale18
GPGUADELOUPE11
GRGrece601356
GTGuatemala25
GWGuinée Bissau12
HKHong-Kong2285463
HNHonduras627
HRCroatie321145
HUHongrie931440
IDIndonesie67612898
IEIrelande47324103
ILIsrael6833740
INInde76217606
IQIraq518
IRIran1685652
ISIslande11486
ITItalie47018845
JMJamaïque343
JOJordanie438
JPJapon39614333
KEKenya12102
KGKyrgyzstan8240
KHCambodge40262
KNSaint-Kitts-et-Nevis13
KRCoree du sud54621494
KWKoweit313
KZKazakhstan55707
LALaos9219
LBLiban1029
LKSri Lanka15228
LRLiberia13
LSLésotho11127
LTLituanie51580
LULuxembourg30429
LVLettonie372544
LYLibye11484
MAMaroc68622
MCMonaco39
MDMoldavie18184
MEMontenegro8281
MKMacedoine (Ex republique Yugoslave)14232
MMMyanmar8119
MNMongolie14300
MOMoldavie843
MTMalte222
MUIles Maurice10111
MWMalawi336
MXMexique1093188
MYMalaisie876516
NANamibie123
NCNouvelle-Caledonie11111
NGNigeria44
NINicaragua414
NLPays-bas803182603
NONorvege331019
NPNepal321084
NZNouvelle Zélande37569
OMSultana d'Oman311
PAPanama3386
PEPerou40681
PFPolynésie Française22
PHPhilippine951655
PKPakistan1302423
PLPologne632477
PRPuerto Rico543
PSPalestine19122
PTPortugal733609
PYParaguay711
QAQuatar14
RORoumanie3488787
RSSerbie431744
RURussie1979282390
RWRwanda212
SAArabie-saoudite12212845
SCSeychelles770
SDSoudan512
SESuede14828254
SGSingapour3818453
SISlovénie271828
SKSlovaquie18611
SNSenegal18292
SOSomalie11
SRSuriname5258
SVSan Salvador512
SYSyrie644
SZSwaziland14
TGTogo11
THThailande2876398
TJTadjikistan5296
TNTunisie40500
TRTurquie26810923
TTTrinidad et Tobago12
TWTaiwan11611319
TZTanzanie881384
UAUkraine52735647
UGUganda246
USUSA177481163572
UYUruguay24629
UZOusbekistan17738
VEVenezuela37687
VIIles Vierge USA11
VNVietnam179536791
YEYemen1360
ZAAfrique au Sud81757
ZMZambie110

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