Provenance des visiteurs
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 584877313 BETWEEN `IP_FROM` AND `IP_TO`

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

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

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

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

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

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

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

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

UPDATE wp_ip_fai SET FOURNISSEUR='' ,Ville ='' , Pays = 'US' WHERE Rang0 = 207 and Rang1 = 154 and Rang2 = 226 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Amazon.com Inc.' ,Ville ='Portland' , Pays = 'US' WHERE Rang0 = 54 and Rang1 = 218 and Rang2 = 3 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Amazon Technologies Inc.' ,Ville ='Portland' , Pays = 'US' WHERE Rang0 = 34 and Rang1 = 220 and Rang2 = 133 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Amazon.com Inc.' ,Ville ='Portland' , Pays = 'US' WHERE Rang0 = 54 and Rang1 = 188 and Rang2 = 175 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Microsoft Corporation' ,Ville ='Bristow' , Pays = 'US' WHERE Rang0 = 40 and Rang1 = 114 and Rang2 = 113 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Amazon.com Inc.' ,Ville ='Portland' , Pays = 'US' WHERE Rang0 = 54 and Rang1 = 218 and Rang2 = 132 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Amazon.com Inc.' ,Ville ='Portland' , Pays = 'US' WHERE Rang0 = 54 and Rang1 = 187 and Rang2 = 156 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='DigitalOcean LLC' ,Ville ='New York City' , Pays = 'US' WHERE Rang0 = 165 and Rang1 = 22 and Rang2 = 238 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Amazon.com Inc.' ,Ville ='Portland' , Pays = 'US' WHERE Rang0 = 54 and Rang1 = 213 and Rang2 = 182 ; 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.com Inc.' ,Ville ='Portland' , Pays = 'US' WHERE Rang0 = 54 and Rang1 = 213 and Rang2 = 182 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='DigitalOcean LLC' ,Ville ='New York City' , Pays = 'US' WHERE Rang0 = 165 and Rang1 = 22 and Rang2 = 238 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Amazon.com Inc.' ,Ville ='Portland' , Pays = 'US' WHERE Rang0 = 54 and Rang1 = 187 and Rang2 = 156 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Amazon.com Inc.' ,Ville ='Portland' , Pays = 'US' WHERE Rang0 = 54 and Rang1 = 218 and Rang2 = 132 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Microsoft Corporation' ,Ville ='Bristow' , Pays = 'US' WHERE Rang0 = 40 and Rang1 = 114 and Rang2 = 113 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Amazon.com Inc.' ,Ville ='Portland' , Pays = 'US' WHERE Rang0 = 54 and Rang1 = 188 and Rang2 = 175 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Amazon Technologies Inc.' ,Ville ='Portland' , Pays = 'US' WHERE Rang0 = 34 and Rang1 = 220 and Rang2 = 133 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Amazon Technologies Inc.' ,Ville ='Portland' , Pays = 'US' WHERE Rang0 = 207 and Rang1 = 154 and Rang2 = 226 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Amazon.com Inc.' ,Ville ='Portland' , Pays = 'US' WHERE Rang0 = 54 and Rang1 = 218 and Rang2 = 3 ; 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
AUAustralie87441397
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
DKDanemark14368822
DORepublique Dominicaine19197
DZAlgérie144388
ECEquateur4580
EEEstonie21406
EGEgypte2681574
ESEspagne2979084
FIFinlande392225
FRFrance1732265510
GAGabon412
GBGrande Bretagne154571198
GEGeorgie32541
GHGhana1557
GNGuinee Equatoriale29
GPGUADELOUPE11
GRGrece941399
GTGuatemala25
GWGuinée Bissau12
HKHong-Kong2615714
HNHonduras931
HRCroatie531171
HUHongrie1451512
IDIndonesie123914007
IEIrelande117128081
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-bas826185110
NONorvege361151
NPNepal441110
NZNouvelle Zélande62613
OMSultana d'Oman1524
PAPanama3386
PEPerou43699
PFPolynésie Française22
PHPhilippine3011979
PKPakistan2282590
PLPologne702515
PRPuerto Rico947
PSPalestine28133
PTPortugal753680
PYParaguay711
QAQuatar613
RORoumanie4318993
RSSerbie761790
RURussie2100283891
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
UAUkraine55336308
UGUganda348
USUSA192041186039
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