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

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

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

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

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

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

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

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

UPDATE wp_ip_fai SET FOURNISSEUR='Amazon Data Services NoVa' ,Ville ='Ashburn' , Pays = 'US' WHERE Rang0 = 3 and Rang1 = 239 and Rang2 = 40 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Hostkey B.V.' ,Ville ='Amsterdam' , Pays = 'NL' WHERE Rang0 = 31 and Rang1 = 207 and Rang2 = 39 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Hostkey B.V.' ,Ville ='Amsterdam' , Pays = 'NL' WHERE Rang0 = 194 and Rang1 = 87 and Rang2 = 33 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='MTA Solutions' ,Ville ='Anchorage' , Pays = 'US' WHERE Rang0 = 64 and Rang1 = 4 and Rang2 = 161 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Google LLC' ,Ville ='Mountain View' , Pays = 'US' WHERE Rang0 = 35 and Rang1 = 203 and Rang2 = 177 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Google LLC' ,Ville ='Mountain View' , Pays = 'US' WHERE Rang0 = 34 and Rang1 = 82 and Rang2 = 190 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Google LLC' ,Ville ='Mountain View' , Pays = 'US' WHERE Rang0 = 35 and Rang1 = 197 and Rang2 = 62 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Computer Sciences Corporation' ,Ville ='Falls Church' , Pays = 'US' WHERE Rang0 = 20 and Rang1 = 62 and Rang2 = 248 ; 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='Computer Sciences Corporation' ,Ville ='Falls Church' , Pays = 'US' WHERE Rang0 = 194 and Rang1 = 87 and Rang2 = 33 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Computer Sciences Corporation' ,Ville ='Falls Church' , Pays = 'US' WHERE Rang0 = 20 and Rang1 = 62 and Rang2 = 248 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Google LLC' ,Ville ='Mountain View' , Pays = 'US' WHERE Rang0 = 35 and Rang1 = 197 and Rang2 = 62 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Google LLC' ,Ville ='Mountain View' , Pays = 'US' WHERE Rang0 = 34 and Rang1 = 82 and Rang2 = 190 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Google LLC' ,Ville ='Mountain View' , Pays = 'US' WHERE Rang0 = 35 and Rang1 = 203 and Rang2 = 177 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='MTA Solutions' ,Ville ='Anchorage' , Pays = 'US' WHERE Rang0 = 64 and Rang1 = 4 and Rang2 = 161 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Hostkey B.V.' ,Ville ='Amsterdam' , Pays = 'NL' WHERE Rang0 = 31 and Rang1 = 207 and Rang2 = 39 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Amazon Data Services NoVa' ,Ville ='Ashburn' , Pays = 'US' WHERE Rang0 = 3 and Rang1 = 239 and Rang2 = 40 ; 1
city_nameISPcountry_code

Le suivi des
visites par pays(Nbr d'enregistrement :=> 156)
PaysNomimageNbr FAINbr de visites
ADAndorre11
AEEmirats Arabe Unis25383
AFAfghanistan233
AGAntigua-et-Barbuda23
AMArménie12347
ANANTILLES NEERLANDAISES11
AOAngola11151
AQANTARCTIQUE13
ARArgentine1063040
ATAutriche461285
AUAustralie76039545
AZAzerbaijan1038
BABosnie-Herzegovine22566
BBBarbade22
BDBangladesh84829
BEBelgique1978136417
BFBurkinaFaso11
BGBulgarie18512406
BHBAHRAIN71199
BIBurundi117
BJBénin69
BNBrunei11
BOBolivie821
BRBrésil45114394
BTBhoutan13
BWBotswana11
BYBelarus23517969
BZBelize217
CACanada1906125440
CHSuisse881450
CICote d'ivoire31777
CLChilie341090
CMCameroun1695
CNChine1325961
COColombie1012057
CRCosta Rica333
CYChypre13859
CZRepublique Tcheque1763566
DEAllemagne38024810
DKDanemark13763541
DORepublique Dominicaine8183
DZAlgérie59288
ECEquateur2441
EEEstonie10243
EGEgypte1011168
ESEspagne2287702
FIFinlande281374
FRFrance1567218116
GAGabon19
GBGrande Bretagne131865781
GEGeorgie22329
GHGhana643
GNGuinee Equatoriale18
GPGUADELOUPE11
GRGrece581261
GTGuatemala25
GWGuinée Bissau12
HKHong-Kong1704865
HNHonduras419
HRCroatie271133
HUHongrie861395
IDIndonesie63312218
IEIrelande18112567
ILIsrael6730411
INInde63315317
IQIraq518
IRIran1445353
ISIslande10470
ITItalie44118330
JMJamaïque332
JOJordanie438
JPJapon35613635
KEKenya887
KGKyrgyzstan8240
KHCambodge39261
KNSaint-Kitts-et-Nevis13
KRCoree du sud50820904
KWKoweit39
KZKazakhstan50666
LALaos9209
LBLiban1029
LKSri Lanka15228
LRLiberia13
LSLésotho782
LTLituanie48569
LULuxembourg28418
LVLettonie352513
LYLibye11484
MAMaroc64605
MCMonaco39
MDMoldavie18184
MEMontenegro7211
MKMacedoine (Ex republique Yugoslave)13231
MMMyanmar8119
MNMongolie14300
MOMoldavie843
MTMalte222
MUIles Maurice10111
MWMalawi223
MXMexique1093174
MYMalaisie836450
NANamibie123
NCNouvelle-Caledonie11111
NGNigeria44
NINicaragua22
NLPays-bas718163805
NONorvege31920
NPNepal311064
NZNouvelle Zélande34556
OMSultana d'Oman311
PAPanama3386
PEPerou39669
PFPolynésie Française22
PHPhilippine911621
PKPakistan1192327
PLPologne461099
PRPuerto Rico440
PSPalestine16111
PTPortugal683543
PYParaguay711
QAQuatar14
RORoumanie3328572
RSSerbie421724
RURussie1878264472
RWRwanda212
SAArabie-saoudite9812562
SCSeychelles769
SDSoudan512
SESuede13827791
SGSingapour2926671
SISlovénie251815
SKSlovaquie16600
SNSenegal18292
SOSomalie11
SRSuriname5253
SVSan Salvador512
SYSyrie644
SZSwaziland14
TGTogo11
THThailande2525382
TJTadjikistan5296
TNTunisie38411
TRTurquie2519577
TTTrinidad et Tobago12
TWTaiwan1037738
TZTanzanie881384
UAUkraine49930223
UGUganda246
USUSA159571031096
UYUruguay20584
UZOusbekistan16622
VEVenezuela37687
VNVietnam176434985
YEYemen1158
ZAAfrique au Sud54527
ZMZambie110

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