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

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

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

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

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

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

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

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

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

UPDATE wp_ip_fai SET FOURNISSEUR='Amazon Technologies Inc.' ,Ville ='Ashburn' , Pays = 'US' WHERE Rang0 = 35 and Rang1 = 174 and Rang2 = 62 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='HD NET Limited' ,Ville ='Auckland' , Pays = 'NZ' WHERE Rang0 = 49 and Rang1 = 50 and Rang2 = 240 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Google LLC' ,Ville ='Mountain View' , Pays = 'US' WHERE Rang0 = 35 and Rang1 = 229 and Rang2 = 174 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Google LLC' ,Ville ='Mountain View' , Pays = 'US' WHERE Rang0 = 35 and Rang1 = 187 and Rang2 = 89 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Google LLC' ,Ville ='Mountain View' , Pays = 'US' WHERE Rang0 = 188 and Rang1 = 34 and Rang2 = 196 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Google LLC' ,Ville ='Mountain View' , Pays = 'US' WHERE Rang0 = 203 and Rang1 = 210 and Rang2 = 102 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Hewlett-Packard Company' ,Ville ='Palo Alto' , Pays = 'US' WHERE Rang0 = 14 and Rang1 = 253 and Rang2 = 128 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Vodafone GmbH' ,Ville ='Aachen' , Pays = 'DE' WHERE Rang0 = 146 and Rang1 = 59 and Rang2 = 29 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Unified Layer' ,Ville ='Provo' , Pays = 'US' WHERE Rang0 = 162 and Rang1 = 241 and Rang2 = 127 ; 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='Unified Layer' ,Ville ='Provo' , Pays = 'US' WHERE Rang0 = 162 and Rang1 = 241 and Rang2 = 127 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Vodafone GmbH' ,Ville ='Aachen' , Pays = 'DE' WHERE Rang0 = 146 and Rang1 = 59 and Rang2 = 29 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Hewlett-Packard Company' ,Ville ='Palo Alto' , Pays = 'US' WHERE Rang0 = 14 and Rang1 = 253 and Rang2 = 128 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Hewlett-Packard Company' ,Ville ='Palo Alto' , Pays = 'US' WHERE Rang0 = 203 and Rang1 = 210 and Rang2 = 102 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Hewlett-Packard Company' ,Ville ='Palo Alto' , Pays = 'US' WHERE Rang0 = 188 and Rang1 = 34 and Rang2 = 196 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Google LLC' ,Ville ='Mountain View' , Pays = 'US' WHERE Rang0 = 35 and Rang1 = 187 and Rang2 = 89 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Google LLC' ,Ville ='Mountain View' , Pays = 'US' WHERE Rang0 = 35 and Rang1 = 229 and Rang2 = 174 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Amazon Technologies Inc.' ,Ville ='Ashburn' , Pays = 'US' WHERE Rang0 = 35 and Rang1 = 174 and Rang2 = 62 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='HD NET Limited' ,Ville ='Auckland' , Pays = 'NZ' WHERE Rang0 = 49 and Rang1 = 50 and Rang2 = 240 ; 1
city_nameISPcountry_code

Le suivi des
visites par pays(Nbr d'enregistrement :=> 162)
PaysNomimageNbr FAINbr de visites
ADAndorre22
AEEmirats Arabe Unis62435
AFAfghanistan269
AGAntigua-et-Barbuda34
AMArménie13364
ANANTILLES NEERLANDAISES11
AOAngola22164
AQANTARCTIQUE13
ARArgentine1667332
ATAutriche1721548
AUAustralie87441396
AZAzerbaijan1250
BABosnie-Herzegovine53765
BBBarbade22
BDBangladesh1631517
BEBelgique2028142617
BFBurkinaFaso11
BGBulgarie22816189
BHBAHRAIN111204
BIBurundi117
BJBénin1016
BNBrunei55
BOBolivie821
BRBrésil69417222
BTBhoutan13
BWBotswana11
BYBelarus24619654
BZBelize419
CACanada1999134448
CHSuisse901501
CICote d'ivoire49852
CLChilie411169
CMCameroun48135
CNChine2317357
COColombie1232177
CRCosta Rica434
CW22
CYChypre18931
CZRepublique Tcheque2183968
DEAllemagne61235337
DKDanemark14368820
DORepublique Dominicaine19197
DZAlgérie144388
ECEquateur4580
EEEstonie21406
EGEgypte2681574
ESEspagne2979084
FIFinlande392225
FRFrance1732265507
GAGabon412
GBGrande Bretagne154571198
GEGeorgie32541
GHGhana1557
GNGuinee Equatoriale29
GPGUADELOUPE11
GRGrece941399
GTGuatemala25
GWGuinée Bissau12
HKHong-Kong2615713
HNHonduras931
HRCroatie531171
HUHongrie1451512
IDIndonesie123914007
IEIrelande117128080
ILIsrael7133749
INInde105218480
IQIraq2646
IRIran2385783
ISIslande11486
ITItalie48419060
JMJamaïque748
JOJordanie539
JPJapon42214527
KEKenya20110
KGKyrgyzstan14247
KHCambodge53290
KNSaint-Kitts-et-Nevis13
KRCoree du sud59021643
KWKoweit516
KZKazakhstan62718
LALaos13228
LBLiban1636
LKSri Lanka58280
LRLiberia24
LSLésotho11127
LTLituanie72604
LULuxembourg30429
LVLettonie512563
LYLibye38516
MAMaroc111669
MCMonaco39
MDMoldavie19185
MEMontenegro15349
MGMadagascar912
MKMacedoine (Ex republique Yugoslave)30252
MMMyanmar10126
MNMongolie15303
MOMoldavie843
MTMalte323
MUIles Maurice21122
MVMaldives33
MWMalawi336
MXMexique1093190
MYMalaisie1576712
MZMozambique11
NANamibie832
NCNouvelle-Caledonie11111
NGNigeria66
NINicaragua825
NLPays-bas826185106
NONorvege361151
NPNepal441110
NZNouvelle Zélande62613
OMSultana d'Oman1524
PAPanama3386
PEPerou43699
PFPolynésie Française22
PHPhilippine3011979
PKPakistan2282590
PLPologne702515
PRPuerto Rico947
PSPalestine28133
PTPortugal753679
PYParaguay711
QAQuatar613
RORoumanie4318993
RSSerbie761790
RURussie2100283844
RWRwanda313
SAArabie-saoudite15613007
SCSeychelles770
SDSoudan512
SESuede15528266
SGSingapour77212066
SISlovénie391849
SKSlovaquie24619
SNSenegal25300
SOSomalie33
SRSuriname5272
SVSan Salvador512
SYSyrie847
SZSwaziland14
TGTogo11
THThailande5797106
TJTadjikistan5296
TNTunisie53517
TRTurquie58011434
TTTrinidad et Tobago23
TWTaiwan15912193
TZTanzanie921398
UAUkraine55336307
UGUganda348
USUSA191951185891
UYUruguay25899
UZOusbekistan17738
VEVenezuela38690
VIIles Vierge USA11
VNVietnam230937626
YEYemen1360
ZAAfrique au Sud194929
ZMZambie312
ZWZimbabwe11

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