Hello, Today i'm selling the database (full sql dump not scrap) of the Fédération Française du Sport Automobile.
Offer a price in PM.
Only MM
The database contain too some Formule 1 and Formule 2 celebrity like Esteban Ocon, Pierre Gasly...
Sample :
The table "_ImportLicencies" contain 286244 rows.
INSERT INTO `_ImportLicencies` VALUES (528231,'{\"nom\": \"PUJOL\", \"oid\": 528231, \"cnil\": 2, \"etat\": 512, \"actif\": true, \"cspID\": 1, \"homme\": true, \"prenom\": \"MARC\", \"pseudo\": \"\", \"formeID\": 10005, \"contactID\": 528232, \"dateDeces\": null, \"numPermis\": \"880.448.321.050\", \"typeOrgID\": 3, \"civiliteID\": 1, \"datePermis\": \"1988-07-08T00:00:00\", \"disPrincID\": null, \"lieuPermis\": \"Toulon\", \"numLicAv95\": 0, \"coordonnees\": {\"oid\": 528235, \"actif\": true, \"telco\": {\"oid\": 528234, \"actif\": true, \"email\": \"\", \"telIp\": \"\", \"telFixe\": \"\", \"emailSec\": \"\", \"telMobile\": \"06 74 33 21 18\", \"telecopie\": \"\", \"dateDerModif\": \"2017-12-19T10:43:41.67\"}, \"adresse\": {\"oid\": 528233, \"actif\": true, \"estVIP\": false, \"ligne1\": \"3 RUE DES CHEVAUCHEURS\", \"ligne2\": \"\", \"communeID\": 1030397, \"dateDerModif\": \"2015-08-29T00:09:48.77\"}, \"dateDerModif\": \"2015-08-29T00:09:48.77\", \"typeAdresseID\": 1}, \"datePremLic\": \"2002-10-29T00:00:00\", \"disSecondID\": null, \"dateDerModif\": \"2002-10-29T00:00:00\", \"dateLicenceOr\": null, \"dateNaissance\": \"1970-05-14T00:00:00\", \"lieuNaissance\": null, \"nationaliteID\": 2, \"organisationID\": 14030, \"numLicenceCours\": \"132818\", \"dateDerModifContact\": \"2015-08-29T13:51:49.527\"}','N',528231,132818,NULL,'2',NULL,'3 RUE DES CHEVAUCHEURS','','Toulon','1988-07-08T00:00:00','880.448.321.050','','','2002-10-29T00:00:00','0','','','','2','',1030397,'1');
INSERT INTO `_ImportLicencies` VALUES (528236,'{\"nom\": \"DE MAYNADIER\", \"oid\": 528236, \"cnil\": 2, \"etat\": 512, \"actif\": true, \"cspID\": 1, \"homme\": true, \"prenom\": \"BENOIT\", \"pseudo\": \"\", \"formeID\": 10005, \"contactID\": 528237, \"dateDeces\": null, \"numPermis\": \"921.075.105.383\", \"typeOrgID\": 3, \"civiliteID\": 1, \"datePermis\": \"1993-01-05T00:00:00\", \"disPrincID\": null, \"lieuPermis\": \"Bordeaux\", \"numLicAv95\": 0, \"coordonnees\": {\"oid\": 528240, \"actif\": true, \"telco\": {\"oid\": 528239, \"actif\": true, \"email\": \"\", \"telIp\": \"\", \"telFixe\": \"01 39 49 07 25\", \"emailSec\": \"\", \"telMobile\": \"\", \"telecopie\": \"\", \"dateDerModif\": \"2017-12-19T10:43:41.67\"}, \"adresse\": {\"oid\": 528238, \"actif\": true, \"estVIP\": false, \"ligne1\": \"1 RUE DE LA CATHEDRALE\", \"ligne2\": \"\", \"communeID\": 1034223, \"dateDerModif\": \"2015-08-29T00:09:48.783\"}, \"dateDerModif\": \"2015-08-29T00:09:48.787\", \"typeAdresseID\": 1}, \"datePremLic\": \"2002-10-29T00:00:00\", \"disSecondID\": null, \"dateDerModif\": \"2002-10-29T00:00:00\", \"dateLicenceOr\": null, \"dateNaissance\": \"1971-01-25T00:00:00\", \"lieuNaissance\": null, \"nationaliteID\": 2, \"organisationID\": 14030, \"numLicenceCours\": \"132819\", \"dateDerModifContact\": \"2015-08-29T13:51:49.527\"}','N',528236,132819,NULL,'2',NULL,'1 RUE DE LA CATHEDRALE','','Bordeaux','1993-01-05T00:00:00','921.075.105.383','','','2002-10-29T00:00:00','0','','','','2','',1034223,'1');
INSERT INTO `_ImportLicencies` VALUES (528241,'{\"nom\": \"COLIBET\", \"oid\": 528241, \"cnil\": 1, \"etat\": 32, \"actif\": true, \"cspID\": 1, \"homme\": true, \"prenom\": \"JACQUES\", \"pseudo\": \"\", \"formeID\": 10005, \"contactID\": 528242, \"dateDeces\": null, \"numPermis\": \"15AN07419\", \"typeOrgID\": 3, \"civiliteID\": 1, \"datePermis\": \"2015-07-06T00:00:00\", \"disPrincID\": null, \"lieuPermis\": \"Evry\", \"numLicAv95\": 53521, \"coordonnees\": {\"oid\": 528245, \"actif\": true, \"telco\": {\"oid\": 528244, \"actif\": true, \"email\": \"christinecolibet@orange.fr\", \"telIp\": \"\", \"telFixe\": \"\", \"emailSec\": \"\", \"telMobile\": \"06 80 92 18 08\", \"telecopie\": \"\", \"dateDerModif\": \"2018-06-24T02:00:04.38\"}, \"adresse\": {\"oid\": 528243, \"actif\": true, \"estVIP\": false, \"ligne1\": \"52 RUE DE LA BOISSIERE\", \"ligne2\": \"\", \"communeID\": 1038365, \"dateDerModif\": \"2018-06-22T22:08:28\"}, \"dateDerModif\": \"2018-06-22T22:08:28\", \"typeAdresseID\": 1}, \"datePremLic\": \"1995-03-10T00:00:00\", \"disSecondID\": null, \"dateDerModif\": \"2018-06-22T22:08:28\", \"dateLicenceOr\": null, \"dateNaissance\": \"1955-01-25T00:00:00\", \"lieuNaissance\": \"BRETIGNY SUR ORGE\", \"nationaliteID\": 2, \"organisationID\": 15362, \"numLicenceCours\": \"13282\", \"dateDerModifContact\": \"2018-06-22T22:08:28\"}','N',528241,13282,NULL,'2',NULL,'52 RUE DE LA BOISSIERE','','Evry','2015-07-06T00:00:00','15AN07419','','','1995-03-10T00:00:00','53521','','','','1','',1038365,'1');
INSERT INTO `_ImportLicencies` VALUES (528246,'{\"nom\": \"MARTEAU\", \"oid\": 528246, \"cnil\": 2, \"etat\": 512, \"actif\": true, \"cspID\": 1, \"homme\": true, \"prenom\": \"OLIVIER\", \"pseudo\": \"\", \"formeID\": 10005, \"contactID\": 528247, \"dateDeces\": null, \"numPermis\": \"920.779.200.418\", \"typeOrgID\": 3, \"civiliteID\": 1, \"datePermis\": \"1994-08-11T00:00:00\", \"disPrincID\": null, \"lieuPermis\": \"Niort\", \"numLicAv95\": 0, \"coordonnees\": {\"oid\": 528250, \"actif\": true, \"telco\": {\"oid\": 528249, \"actif\": true, \"email\": \"\", \"telIp\": \"\", \"telFixe\": \"\", \"emailSec\": \"\", \"telMobile\": \"06 60 49 38 88\", \"telecopie\": \"\", \"dateDerModif\": \"2017-12-19T10:43:41.673\"}, \"adresse\": {\"oid\": 528248, \"actif\": true, \"estVIP\": false, \"ligne1\": \"ROUTE DE LA PLAGNE\", \"ligne2\": \"\", \"communeID\": 1032485, \"dateDerModif\": \"2015-08-29T00:09:48.813\"}, \"dateDerModif\": \"2015-08-29T00:09:48.817\", \"typeAdresseID\": 1}, \"datePremLic\": \"2002-10-29T00:00:00\", \"disSecondID\": null, \"dateDerModif\": \"2002-10-29T00:00:00\", \"dateLicenceOr\": null, \"dateNaissance\": \"1976-07-06T00:00:00\", \"lieuNaissance\": null, \"nationaliteID\": 2, \"organisationID\": 14030, \"numLicenceCours\": \"132820\", \"dateDerModifContact\": \"2015-08-29T13:51:49.53\"}','N',528246,132820,NULL,'2',NULL,'ROUTE DE LA PLAGNE','','Niort','1994-08-11T00:00:00','920.779.200.418','','','2002-10-29T00:00:00','0','','','','2','',1032485,'1');
INSERT INTO `_ImportLicencies` VALUES (528251,'{\"nom\": \"PELEGRY\", \"oid\": 528251, \"cnil\": 2, \"etat\": 512, \"actif\": true, \"cspID\": 1, \"homme\": true, \"prenom\": \"CEDRIC\", \"pseudo\": \"\", \"formeID\": 10005, \"contactID\": 528252, \"dateDeces\": null, \"numPermis\": \"910681110580\", \"typeOrgID\": 3, \"civiliteID\": 1, \"datePermis\": \"1997-06-24T00:00:00\", \"disPrincID\": null, \"lieuPermis\": \"Albi\", \"numLicAv95\": 0, \"coordonnees\": {\"oid\": 528255, \"actif\": true, \"telco\": {\"oid\": 528254, \"actif\": true, \"email\": \"\", \"telIp\": \"\", \"telFixe\": \"\", \"emailSec\": \"\", \"telMobile\": \"06 24 28 60 46\", \"telecopie\": \"\", \"dateDerModif\": \"2017-12-19T10:43:41.673\"}, \"adresse\": {\"oid\": 528253, \"actif\": true, \"estVIP\": false, \"ligne1\": \"6 RUE PEGASSE\", \"ligne2\": \"\", \"communeID\": 1035513, \"dateDerModif\": \"2015-08-29T00:09:48.83\"}, \"dateDerModif\": \"2015-08-29T00:09:48.833\", \"typeAdresseID\": 1}, \"datePremLic\": \"2002-10-29T00:00:00\", \"disSecondID\": null, \"dateDerModif\": \"2002-10-29T00:00:00\", \"dateLicenceOr\": null, \"dateNaissance\": \"1973-08-22T00:00:00\", \"lieuNaissance\": null, \"nationaliteID\": 2, \"organisationID\": 13209, \"numLicenceCours\": \"132821\", \"dateDerModifContact\": \"2015-08-29T13:51:49.53\"}','N',528251,132821,NULL,'2',NULL,'6 RUE PEGASSE','','Albi','1997-06-24T00:00:00','910681110580','','','2002-10-29T00:00:00','0','','','','2','',1035513,'1');
INSERT INTO `_ImportLicencies` VALUES (528256,'{\"nom\": \"LEROY\", \"oid\": 528256, \"cnil\": 2, \"etat\": 512, \"actif\": true, \"cspID\": 10012, \"homme\": false, \"prenom\": \"RENEE\", \"pseudo\": \"\", \"formeID\": 10005, \"contactID\": 528257, \"dateDeces\": null, \"numPermis\": \"800.527.300.841\", \"typeOrgID\": 3, \"civiliteID\": 2, \"datePermis\": \"1980-12-24T00:00:00\", \"disPrincID\": null, \"lieuPermis\": \"Evreux\", \"numLicAv95\": 0, \"coordonnees\": {\"oid\": 528260, \"actif\": true, \"telco\": {\"oid\": 528259, \"actif\": true, \"email\": \"\", \"telIp\": \"\", \"telFixe\": \"02 43 72 08 26\", \"emailSec\": \"\", \"telMobile\": \"\", \"telecopie\": \"\", \"dateDerModif\": \"2017-12-19T10:43:41.677\"}, \"adresse\": {\"oid\": 528258, \"actif\": true, \"estVIP\": false, \"ligne1\": \"156 AVENUE BOLLEE - HALL 5\", \"ligne2\": \"\", \"communeID\": 1031754, \"dateDerModif\": \"2015-08-29T00:09:48.843\"}, \"dateDerModif\": \"2015-08-29T00:09:48.847\", \"typeAdresseID\": 1}, \"datePremLic\": \"2002-10-29T00:00:00\", \"disSecondID\": null, \"dateDerModif\": \"2003-02-05T00:00:00\", \"dateLicenceOr\": null, \"dateNaissance\": \"1962-10-09T00:00:00\", \"lieuNaissance\": null, \"nationaliteID\": 2, \"organisationID\": 14687, \"numLicenceCours\": \"132822\", \"dateDerModifContact\": \"2015-08-29T13:51:49.53\"}','N',528256,132822,NULL,'2',NULL,'156 AVENUE BOLLEE - HALL 5','','Evreux','1980-12-24T00:00:00','800.527.300.841','','','2002-10-29T00:00:00','0','','','','2','',1031754,'2');
INSERT INTO `_ImportLicencies` VALUES (528261,'{\"nom\": \"LEROY\", \"oid\": 528261, \"cnil\": 2, \"etat\": 512, \"actif\": true, \"cspID\": 10015, \"homme\": true, \"prenom\": \"NICOLAS\", \"pseudo\": \"\", \"formeID\": 10005, \"contactID\": 528262, \"dateDeces\": null, \"numPermis\": \"\", \"typeOrgID\": 3, \"civiliteID\": 1, \"datePermis\": null, \"disPrincID\": null, \"lieuPermis\": \"\", \"numLicAv95\": 0, \"coordonnees\": {\"oid\": 528265, \"actif\": true, \"telco\": {\"oid\": 528264, \"actif\": true, \"email\": \"\", \"telIp\": \"\", \"telFixe\": \"02 43 72 08 26\", \"emailSec\": \"\", \"telMobile\": \"\", \"telecopie\": \"\", \"dateDerModif\": \"2017-12-19T10:43:41.677\"}, \"adresse\": {\"oid\": 528263, \"actif\": true, \"estVIP\": false, \"ligne1\": \"156 AVENUE BOLLEE\", \"ligne2\": \"HALL 5\", \"communeID\": 1031754, \"dateDerModif\": \"2015-08-29T00:09:48.857\"}, \"dateDerModif\": \"2015-08-29T00:09:48.86\", \"typeAdresseID\": 1}, \"datePremLic\": \"2002-10-21T00:00:00\", \"disSecondID\": null, \"dateDerModif\": \"2003-02-05T00:00:00\", \"dateLicenceOr\": null, \"dateNaissance\": \"1986-08-04T00:00:00\", \"lieuNaissance\": null, \"nationaliteID\": 2, \"organisationID\": 14687, \"numLicenceCours\": \"106948\", \"dateDerModifContact\": \"2015-08-29T13:51:49.54\"}','N',528261,106948,NULL,'2',NULL,'156 AVENUE BOLLEE','HALL 5','','','','','','2002-10-21T00:00:00','0','','','','2','',1031754,'1');
The table "Adresses" contain 362875 rows.
INSERT INTO `Adresses` VALUES (252461,1608248,0,'2015-08-29 01:08:30','PR',NULL,NULL,NULL,NULL,NULL,'81 rue des Cassis','Althen des Palude',NULL,'','84210','','PERNES LES FONTAINES',1036209,'00000',NULL,'FR','','','90621927','','',NULL,'',NULL,NULL,NULL,000,000);
HUGO','',NULL,'','72600','','MAMERS',1031753,'00000',NULL,'FR','','','0243974641','','',NULL,'',NULL,NULL,NULL,000,000);
INSERT INTO `Adresses` VALUES (252476,1608346,0,'2015-08-29 01:08:31','PR',NULL,NULL,NULL,NULL,NULL,'Z.A de la Brique','',NULL,'','53810','','CHANGE',1021670,'00000',NULL,'FR','','','43536690','','',NULL,'',NULL,NULL,NULL,000,000);
INSERT INTO `Adresses` VALUES (252477,1608351,0,'2024-03-11 20:06:06','PR',NULL,NULL,NULL,NULL,NULL,'11 RUE RICHARD COEUR DE LION','',NULL,'','17170','','BENON',1006357,'17041',NULL,'FR','anthonydesousa17170@gmail.com','','','','0650932543',NULL,NULL,NULL,NULL,NULL,000,000);
INSERT INTO `Adresses` VALUES (252478,1608366,0,'2015-08-29 01:08:31','PR',NULL,NULL,NULL,NULL,NULL,'13 rue Mal Delattre de Tassigny','',NULL,'','49240','','AVRILLE',1019421,'00000',NULL,'FR','','','0241342764','','',NULL,'',NULL,NULL,NULL,000,000);
INSERT INTO `Adresses` VALUES (252479,1608376,0,'2015-08-29 01:08:31','PR',NULL,NULL,NULL,NULL,NULL,'9 rue du Coche d\'eau','',NULL,'','44000','','NANTES',1018056,'00000',NULL,'FR','','','40124731','','',NULL,'',NULL,NULL,NULL,000,000);
INSERT INTO `Adresses` VALUES (252480,1608381,0,'2015-08-29 01:08:31','PR',NULL,NULL,NULL,NULL,NULL,'4 AVENUE DU CLERY','',NULL,'','44500','','LA BAULE ESCOUBLAC',1017991,'00000',NULL,'FR','tassin.nicolas@neuf.fr','','0240530776','','',NULL,'',NULL,NULL,NULL,000,000);
INSERT INTO `Adresses` VALUES (252481,1608386,0,'2015-08-29 01:08:31','PR',NULL,NULL,NULL,NULL,NULL,'2 rue Pointoise','Chacrise',NULL,'','02200','','SOISSONS',1001171,'00000',NULL,'FR','','','23551691','','',NULL,'',NULL,NULL,NULL,000,000);
INSERT INTO `Adresses` VALUES (252482,1608391,0,'2015-08-29 01:08:31','PR',NULL,NULL,NULL,NULL,NULL,'15 Res.Pasteur','Avenue Dupuis',NULL,'','02800','','LA FERE',1000758,'00000',NULL,'FR','','','23567754','','',NULL,'',NULL,NULL,NULL,000,000);
INSERT INTO `Adresses` VALUES (252483,1608396,0,'2015-08-29 01:08:31','PR',NULL,NULL,NULL,NULL,NULL,'8 RUE STENDHAL','',NULL,'','35235','','THORIGNE FOUILLARD',1014967,'00000',NULL,'FR','','','0299620220','','',NULL,'',NULL,NULL,NULL,000,000);
INSERT INTO `Adresses` VALUES (252484,1608401,0,'2015-08-29 01:08:31','PR',NULL,NULL,NULL,NULL,NULL,'2 rue Pontoise','Chacrise',NULL,'','02200','','SOISSONS',1001171,'00000',NULL,'FR','','','23551691','','',NULL,'',NULL,NULL,NULL,000,000);
The table "CompteLicencie" contain 51359 rows.
INSERT INTO `CompteLicencie` VALUES ('263283',24367422,'TSka1E55u9d0B2FD0s9Vx8IPGFLQevLHiC8ySFtX9PGgYArBJ/nWv1EHHZwR7BQhCaY7vycyIK4WOXN77nUIxnhgLoNgj/P8l6AaeSRyRP8e3AZ0y+ZeVPOZb+PGiQx36UAld7MU0tl9G/c6KZKXHQ==','54b595f1e8041902682aa5485a7d2903254ecee3600a9967482d8f0e7ae32d9beebc86af337ce621b416fc8f31a27c66bf5f9590f9a8e23d3458f906750bc413','$1$WTm4WVG7$hQk7hxTLfbUv4UZJxq5bs/','2023-04-01 01:06:08','2023-06-05 19:47:54');
INSERT INTO `CompteLicencie` VALUES ('239557',1066638,'CGq1ZaYy1PHzadu71B5rPZJ+iN9RH5jC7FztyN8RgoJxAO9ga2o84ybFgol+FS5OAwyUaTDkRWLjnsQUfuFnMBksCvecCvehb9NRHSGzWRQl7rnBqlmR1CG+N+cpN/Wk','b7a80a66ecbe0d52e99faf33f55baf72767c5b1de0c631365624d8ec740860f5af9edcc535d32fa5c50d21128efd53be879e681d49957e6db393af147ab95648','$1$bAP/rqr1$Nvt4Z6TKmwekrqyY5fH4j/','2023-04-01 05:09:05','2023-04-01 05:09:05');
INSERT INTO `CompteLicencie` VALUES ('344044',500047340,'YF5bCFnBZeSMt/4gXTWipkG2B4zUfTHasv0rEnbocTKby3xF0PmsfHbm4QlJeTlo7e3/VNcptOe4NjeOEhvfqLOYegkIewk5mGKJW0kHDg0cXSqJrOtvYMD70838tSyX','225b9b0463a5fdbc4f748e3777b600ab623711f8172c2d6db92e17157d9527338a2f5a77832668d90ea66af350d9f402c1e2d31fedbb095d1c2ab4a86c71dd7f','$1$09e/LUs5$J3A7glYBf33ULF40bSrC5/','2023-04-01 08:27:43','2023-04-01 08:27:43');
INSERT INTO `CompteLicencie` VALUES ('310872',500014169,'gjkj5fGOFU1S20InX7LIlq98hZd1QtSxZ7c1DQSW9+ygY8ylKnBbR/xkDre10n9/XkakDbKIAKpi5dZ1NUjObG8eWdhdi1CghopHGM1GRyQv7edVKMrdKpV2/spd1RuG','50231622a1e076d36b749244025c72300a30622a8658cb0cf7a9a636a4b0052b68bb5cb7f7e979bbc6b8c47009d77315b49f6dff439c14489096c1f8d9a6b398','$1$EXmTzHEK$aqnlxx4TFpjXnLaZwvJjE1','2023-04-01 09:03:48','2024-06-10 09:54:35');
INSERT INTO `CompteLicencie` VALUES ('344046',500047342,'f7ITWiC7y0n7gJoHJm2O7jh8MyFg+wk0ZJ1NksriSIqhvXD+Lf22E8lXiy+xT7vzgh1hUgPWBHUedlJ9kOXU7slZo4cpOYQrTKwfEUdlikKQKpTGqR/ccizIb2YptB2j','456186df3de4dc1109e4bfe3c04c8568ddf8196fae47b276a49f0ad6f82f2fbb2c8e976f68faa8d67363d08542ff8ff640b1434648a37f30aaf8e4a3f96bf125','$1$9UVZnz5R$HHu9lavKntRJZ7apaOUEM.','2023-04-01 09:05:42','2023-04-01 09:05:42');
INSERT INTO `CompteLicencie` VALUES ('344045',500047341,'Y61mTi1ZvNv7MCfH4EoXs44pGf9X3LMHu2Jb9QeZ74F682canWngWHs3VKeiCkGM7NxqZ3VT1MR/yh7dbdutqGrD4Xfm5kHaiVTsshalY6GFMZGrtQR+LaoOSumcja4H','53aadc589c21757f55378873179b8abbbfb073db61ceadf07ccce5b4bb13ec62e86d9199f7b7a8bb5063b893a5501e2b7ae82eb26c6c44be6681b8941ea98c05','$1$0DnaIqQM$uYOoCh1RdkQwSt2.Xi9mT1','2023-04-01 09:05:48','2023-04-01 09:05:48');
INSERT INTO `CompteLicencie` VALUES ('335140',500038434,'wxW3IYt31dSwc3LU/78JxCwwCSRRxAZG3iS/JsQqLxZtWVyqT3PVEYwP9Sjr6kZKBmULDa/mWzL/hU8WZpNbOQ/Yg1jFgBjrydHntn+G8NN2RhbC9T1JlywnYeBLbyG3','f222770598908f6d022bae6a62eacf71d6a09738f956a040d686f0a9f9c9f10bfe7c2d8cd2c888d9070276561b98c71fa0c0c08797de82d64f22c4a74cfb25f3','$1$yPG6l4ij$HIaFNUxgrUeIe2oTEIl840','2023-04-01 09:31:31','2024-05-22 09:22:23');
The table "PanierCmdElectroniques" contain 280762 rows.
NSERT INTO `PanierCmdElectroniques` VALUES (122312,'15c677e0c4c916cc5a4d5504e090f06d8f9c571cf6d7e8729f7c6170e495711f','2021-09-09 11:32:25',0,994646,49893,'-500131870-',100,2021,'CB1',177.00,'Tzo4OiJzdGRDbGFzcyI6NTp7czoxMToidG90YWxQYW5pZXIiO2Q6MTc3O3M6MjA6InRvdGFsUmVndWxhdGlvblNvbGRlIjtpOjA7czoxNDoidG90YWxSZWdsZW1lbnQiO2Q6MTc3O3M6MTE6IkFkcmVzc2VtYWlsIjtzOjI1OiJmbGF2ZXJnbmVAZ2FsdmFub3IyMDAwLmZyIjtzOjEzOiJtb3llblBhaWVtZW50IjtzOjM6IkNCMSI7fQ==','YTozOntpOjA7YToxNDp7czoxOiJZIjtzOjM6IkxJQyI7czo5OiJMaWNlbmNlSWQiO3M6OToiNTAwMTMxODcwIjtzOjU6IkVjcklkIjtzOjY6IjQ4NjUyNCI7czo3OiJFY3JEYXRlIjtzOjE5OiIyMDIxLTA5LTA5IDExOjMyOjA0IjtzOjExOiJMaWNlbmNlRXRhdCI7czoxOiJOIjtzOjEzOiJMaWNHcm91cGVUeXBlIjtzOjM6IkFOVSI7czoxMzoiTGljR3JvdXBlQ29kZSI7czo3OiIyMDIxTkFUIjtzOjE0OiJMaWNlbmNlTW9udGFudCI7czo0OiIwLjAwIjtzOjE2OiJMaWNlbmNlVGFyaWZQcml4IjtzOjQ6IjAuMDAiO3M6MjA6IkxpY2VuY2VUYXJpZlBhcnRBc3N1IjtzOjQ6IjAuMDAiO3M6OToiU3RydWN0dXJlIjtzOjMzOiIxNDg2IC0gQVNLIENPUk1FSUxMRVMgRU4gVkVYSU4gOTUiO3M6MTA6IkVjckxpYmVsbGUiO3M6NzE6IkxpY2VuY2UgMjAyMSA6IE5BVElPTkFMRSBDT05DVVJSRU5UIENPTkRVQ1RFVVIgQVVUTyAtIE0gTEFWRVJHTkUgRlJBTkNLIjtzOjg6IlBlcnNvbm5lIjtzOjE1OiJMQVZFUkdORSBGUkFOQ0siO3M6ODoiQ29tcHRhSWQiO3M6NToiNDk4OTMiO31pOjE7YTo4OntzOjE6IlkiO3M6MzoiQ01VIjtzOjk6IkxpY2VuY2VJZCI7czo5OiI1MDAxMzE4NzAiO3M6NToiRWNySWQiO3M6NjoiNDg2NTI2IjtzOjc6IkVjckRhdGUiO3M6MTk6IjIwMjEtMDktMDkgMTE6MzI6MDQiO3M6MTQ6IkxpY2VuY2VNb250YW50IjtzOjU6IjEwLjAwIjtzOjk6IlN0cnVjdHVyZSI7czozMzoiMTQ4NiAtIEFTSyBDT1JNRUlMTEVTIEVOIFZFWElOIDk1IjtzOjEwOiJFY3JMaWJlbGxlIjtzOjc4OiJDb8O7dCBkZSBjdW11bCAyMDIxIDogTkFUSU9OQUxFIENPTkNVUlJFTlQgQ09ORFVDVEVVUiBBVVRPIC0gTSBMQVZFUkdORSBGUkFOQ0siO3M6ODoiUGVyc29ubmUiO3M6MTU6IkxBVkVSR05FIEZSQU5DSyI7fWk6MjthOjg6e3M6MToiWSI7czo0OiJETElDIjtzOjk6IkxpY2VuY2VJZCI7czo5OiI1MDAxMzE4NzAiO3M6NToiRWNySWQiO3M6NjoiNDg2NTI3IjtzOjc6IkVjckRhdGUiO3M6MTk6IjIwMjEtMDktMDkgMTE6MzI6MDQiO3M6MTQ6IkxpY2VuY2VNb250YW50IjtzOjY6IjE2Ny4wMCI7czo5OiJTdHJ1Y3R1cmUiO3M6MzM6IjE0ODYgLSBBU0sgQ09STUVJTExFUyBFTiBWRVhJTiA5NSI7czoxMDoiRWNyTGliZWxsZSI7czo3NToiRGlmZsOpcmVuY2UgMjAyMSA6IE5BVElPTkFMRSBDT05DVVJSRU5UIENPTkRVQ1RFVVIgQVVUTyAtIE0gTEFWRVJHTkUgRlJBTkNLIjtzOjg6IlBlcnNvbm5lIjtzOjE1OiJMQVZFUkdORSBGUkFOQ0siO319',NULL,NULL,'a:64:{s:11:\"vads_amount\";s:5:\"17700\";s:14:\"vads_auth_mode\";s:4:\"FULL\";s:16:\"vads_auth_number\";s:6:\"224261\";s:16:\"vads_auth_result\";s:2:\"00\";s:18:\"vads_capture_delay\";s:1:\"0\";s:15:\"vads_card_brand\";s:2:\"CB\";s:16:\"vads_card_number\";s:16:\"477173XXXXXX7325\";s:24:\"vads_payment_certificate\";s:40:\"618d8ff1466d467caa74b5c7d782446763dc3f48\";s:13:\"vads_ctx_mode\";s:10:\"PRODUCTION\";s:13:\"vads_currency\";s:3:\"978\";s:21:\"vads_effective_amount\";s:5:\"17700\";s:23:\"vads_effective_currency\";s:3:\"978\";s:12:\"vads_site_id\";s:8:\"21195833\";s:15:\"vads_trans_date\";s:14:\"20210909093225\";s:13:\"vads_trans_id\";s:6:\"134132\";s:15:\"vads_trans_uuid\";s:32:\"aa717f714eec45548bae96966ef2b309\";s:20:\"vads_validation_mode\";s:1:\"0\";s:12:\"vads_version\";s:2:\"V2\";s:20:\"vads_warranty_result\";s:3:\"YES\";s:16:\"vads_payment_src\";s:2:\"EC\";s:13:\"vads_order_id\";s:14:\"21042510122312\";s:15:\"vads_cust_email\";s:25:\"flavergne@galvanor2000.fr\";s:12:\"vads_cust_id\";s:6:\"225412\";s:16:\"vads_cust_status\";s:7:\"PRIVATE\";s:14:\"vads_cust_name\";s:15:\"FRANCK LAVERGNE\";s:20:\"vads_cust_first_name\";s:6:\"FRANCK\";s:19:\"vads_cust_last_name\";s:8:\"LAVERGNE\";s:20:\"vads_cust_legal_name\";s:0:\"\";s:8:\"vads_tid\";s:3:\"001\";s:20:\"vads_sequence_number\";s:1:\"1\";s:21:\"vads_acquirer_network\";s:2:\"CB\";s:18:\"vads_contract_used\";s:7:\"5945746\";s:17:\"vads_trans_status\";s:10:\"AUTHORISED\";s:17:\"vads_expiry_month\";s:1:\"6\";s:16:\"vads_expiry_year\";s:4:\"2023\";s:14:\"vads_bank_code\";s:5:\"30003\";s:15:\"vads_bank_label\";s:20:\"Société générale\";s:17:\"vads_bank_product\";s:1:\"I\";s:12:\"vads_pays_ip\";s:2:\"FR\";s:22:\"vads_presentation_date\";s:14:\"20210909093243\";s:28:\"vads_effective_creation_date\";s:14:\"20210909093243\";s:20:\"vads_occurrence_type\";s:8:\"UNITAIRE\";s:19:\"vads_operation_type\";s:5:\"DEBIT\";s:11:\"vads_result\";s:2:\"00\";s:17:\"vads_extra_result\";s:0:\"\";s:17:\"vads_card_country\";s:2:\"FR\";s:13:\"vads_language\";s:2:\"fr\";s:21:\"vads_brand_management\";s:55:\"{\"userChoice\":false,\"brandList\":\"CB|VISA\",\"brand\":\"CB\"}\";s:9:\"vads_hash\";s:64:\"5f8c085d849f5e7546543614b738922aa30327cfb212c6b2721aea36fe6a077f\";s:18:\"vads_url_check_src\";s:3:\"PAY\";s:16:\"vads_action_mode\";s:11:\"INTERACTIVE\";s:19:\"vads_payment_config\";s:6:\"SINGLE\";s:16:\"vads_page_action\";s:7:\"PAYMENT\";s:21:\"vads_threeds_enrolled\";s:1:\"Y\";s:22:\"vads_threeds_auth_type\";s:9:\"CHALLENGE\";s:16:\"vads_threeds_eci\";s:2:\"05\";s:16:\"vads_threeds_xid\";s:0:\"\";s:26:\"vads_threeds_cavvAlgorithm\";s:0:\"\";s:19:\"vads_threeds_status\";s:1:\"Y\";s:23:\"vads_threeds_sign_valid\";s:0:\"\";s:23:\"vads_threeds_error_code\";s:0:\"\";s:24:\"vads_threeds_exit_status\";s:2:\"10\";s:17:\"vads_threeds_cavv\";s:28:\"AAgBB2AAUAAAAEUkl4JSdFo/5Eo=\";s:9:\"signature\";s:40:\"0d2cd086ede39f58ad70fa7ad5bb63fbb2dd61e5\";}','a:25:{s:12:\"vads_site_id\";s:8:\"21195833\";s:13:\"vads_ctx_mode\";s:10:\"PRODUCTION\";s:12:\"vads_version\";s:2:\"V2\";s:13:\"vads_language\";s:2:\"fr\";s:9:\"signature\";s:0:\"\";s:15:\"vads_trans_date\";s:14:\"20210909093225\";s:13:\"vads_trans_id\";s:6:\"134132\";s:13:\"vads_currency\";s:3:\"978\";s:16:\"vads_page_action\";s:7:\"PAYMENT\";s:16:\"vads_action_mode\";s:11:\"INTERACTIVE\";s:19:\"vads_payment_config\";s:6:\"SINGLE\";s:16:\"vads_return_mode\";s:4:\"POST\";s:15:\"vads_url_return\";s:68:\"https://licence.ffsa.org/paiements/commandepagec/21042510122312.html\";s:16:\"vads_url_success\";s:68:\"https://licence.ffsa.org/paiements/commandepagec/21042510122312.html\";s:15:\"vads_url_cancel\";s:53:\"https://licence.ffsa.org/paiements/commandepageb.html\";s:14:\"vads_url_error\";s:53:\"https://licence.ffsa.org/paiements/commandepageb.html\";s:16:\"vads_url_refused\";s:53:\"https://licence.ffsa.org/paiements/commandepageb.html\";s:15:\"vads_cust_email\";s:25:\"flavergne@galvanor2000.fr\";s:20:\"vads_cust_first_name\";s:6:\"FRANCK\";s:12:\"vads_cust_id\";s:6:\"225412\";s:19:\"vads_cust_last_name\";s:8:\"LAVERGNE\";s:20:\"vads_cust_legal_name\";N;s:16:\"vads_cust_status\";s:7:\"PRIVATE\";s:11:\"vads_amount\";d:17700;s:13:\"vads_order_id\";s:14:\"21042510122312\";}','2','21042510122312',NULL,NULL,486528,NULL,NULL,'0','2021-09-09 11:34:12',0.00,NULL,NULL,NULL,NULL,'N',NULL);
INSERT INTO `PanierCmdElectroniques` VALUES (122318,'c60c0cf4f3db11c93525a78ff96fde060ea6c583baf00112237e14c4b9a1dda5','2021-09-09 13:11:26',0,828786,25047,'-500131876-',100,2021,'CB1',383.00,'Tzo4OiJzdGRDbGFzcyI6NTp7czoxMToidG90YWxQYW5pZXIiO2Q6MzgzO3M6MjA6InRvdGFsUmVndWxhdGlvblNvbGRlIjtpOjA7czoxNDoidG90YWxSZWdsZW1lbnQiO2Q6MzgzO3M6MTE6IkFkcmVzc2VtYWlsIjtzOjE4OiJqZWZmeTJhQGhvdG1haWwuZnIiO3M6MTM6Im1veWVuUGFpZW1lbnQiO3M6MzoiQ0IxIjt9','YTo0OntpOjA7YToxNDp7czoxOiJZIjtzOjM6IkxJQyI7czo5OiJMaWNlbmNlSWQiO3M6OToiNTAwMTMxODc2IjtzOjU6IkVjcklkIjtzOjY6IjQ4NjU0NyI7czo3OiJFY3JEYXRlIjtzOjE5OiIyMDIxLTA5LTA5IDEzOjEwOjI0IjtzOjExOiJMaWNlbmNlRXRhdCI7czoxOiJOIjtzOjEzOiJMaWNHcm91cGVUeXBlIjtzOjM6IkFOVSI7czoxMzoiTGljR3JvdXBlQ29kZSI7czo3OiIyMDIxTkFUIjtzOjE0OiJMaWNlbmNlTW9udGFudCI7czo0OiIwLjAwIjtzOjE2OiJMaWNlbmNlVGFyaWZQcml4IjtzOjQ6IjAuMDAiO3M6MjA6IkxpY2VuY2VUYXJpZlBhcnRBc3N1IjtzOjQ6IjAuMDAiO3M6OToiU3RydWN0dXJlIjtzOjE4OiIwNjA2IC0gQVNBIENPUlNJQ0EiO3M6MTA6IkVjckxpYmVsbGUiO3M6NzU6IkxpY2VuY2UgMjAyMSA6IE5BVElPTkFMRSBDT05DVVJSRU5UIENPTkRVQ1RFVVIgQVVUTyAtIE0gUE9SQ1UgSkVBTi1GUkFOQ09JUyI7czo4OiJQZXJzb25uZSI7czoxOToiUE9SQ1UgSkVBTi1GUkFOQ09JUyI7czo4OiJDb21wdGFJZCI7czo1OiIyNTA0NyI7fWk6MTthOjg6e3M6MToiWSI7czo1OiJDVENMVSI7czo5OiJMaWNlbmNlSWQiO3M6OToiNTAwMTMxODc2IjtzOjU6IkVjcklkIjtzOjY6IjQ4NjU1MSI7czo3OiJFY3JEYXRlIjtzOjE5OiIyMDIxLTA5LTA5IDEzOjEwOjI0IjtzOjE0OiJMaWNlbmNlTW9udGFudCI7czo0OiIxLjAwIjtzOjk6IlN0cnVjdHVyZSI7czoxODoiMDYwNiAtIEFTQSBDT1JTSUNBIjtzOjEwOiJFY3JMaWJlbGxlIjtzOjU4OiJDb3Rpc2F0aW9uIENsdWIgMDYwNiAtIEFTQSBDT1JTSUNBIC0gTSBQT1JDVSBKRUFOLUZSQU5DT0lTIjtzOjg6IlBlcnNvbm5lIjtzOjE5OiJQT1JDVSBKRUFOLUZSQU5DT0lTIjt9aToyO2E6ODp7czoxOiJZIjtzOjM6IkNNVSI7czo5OiJMaWNlbmNlSWQiO3M6OToiNTAwMTMxODc2IjtzOjU6IkVjcklkIjtzOjY6IjQ4NjU0OSI7czo3OiJFY3JEYXRlIjtzOjE5OiIyMDIxLTA5LTA5IDEzOjEwOjI0IjtzOjE0OiJMaWNlbmNlTW9udGFudCI7czo1OiIxMC4wMCI7czo5OiJTdHJ1Y3R1cmUiO3M6MTg6IjA2MDYgLSBBU0EgQ09SU0lDQSI7czoxMDoiRWNyTGliZWxsZSI7czo4MjoiQ2/Du3QgZGUgY3VtdWwgMjAyMSA6IE5BVElPTkFMRSBDT05DVVJSRU5UIENPTkRVQ1RFVVIgQVVUTyAtIE0gUE9SQ1UgSkVBTi1GUkFOQ09JUyI7czo4OiJQZXJzb25uZSI7czoxOToiUE9SQ1UgSkVBTi1GUkFOQ09JUyI7fWk6MzthOjg6e3M6MToiWSI7czo0OiJETElDIjtzOjk6IkxpY2VuY2VJZCI7czo5OiI1MDAxMzE4NzYiO3M6NToiRWNySWQiO3M6NjoiNDg2NTUwIjtzOjc6IkVjckRhdGUiO3M6MTk6IjIwMjEtMDktMDkgMTM6MTA6MjQiO3M6MTQ6IkxpY2VuY2VNb250YW50IjtzOjY6IjM3Mi4wMCI7czo5OiJTdHJ1Y3R1cmUiO3M6MTg6IjA2MDYgLSBBU0EgQ09SU0lDQSI7czoxMDoiRWNyTGliZWxsZSI7czo3OToiRGlmZsOpcmVuY2UgMjAyMSA6IE5BVElPTkFMRSBDT05DVVJSRU5UIENPTkRVQ1RFVVIgQVVUTyAtIE0gUE9SQ1UgSkVBTi1GUkFOQ09JUyI7czo4OiJQZXJzb25uZSI7czoxOToiUE9SQ1UgSkVBTi1GUkFOQ09JUyI7fX0=',NULL,NULL,'a:64:{s:11:\"vads_amount\";s:5:\"38300\";s:14:\"vads_auth_mode\";s:4:\"FULL\";s:16:\"vads_auth_number\";s:6:\"424665\";s:16:\"vads_auth_result\";s:2:\"00\";s:18:\"vads_capture_delay\";s:1:\"0\";s:15:\"vads_card_brand\";s:2:\"CB\";s:16:\"vads_card_number\";s:16:\"513162XXXXXX6766\";s:24:\"vads_payment_certificate\";s:40:\"6368c54bfd7354d1c9af6b80b92db03d6b8ce9b5\";s:13:\"vads_ctx_mode\";s:10:\"PRODUCTION\";s:13:\"vads_currency\";s:3:\"978\";s:21:\"vads_effective_amount\";s:5:\"38300\";s:23:\"vads_effective_currency\";s:3:\"978\";s:12:\"vads_site_id\";s:8:\"21195833\";s:15:\"vads_trans_date\";s:14:\"20210909111126\";s:13:\"vads_trans_id\";s:6:\"134142\";s:15:\"vads_trans_uuid\";s:32:\"00c9eb7be6cd4f1fa455c3206af77851\";s:20:\"vads_validation_mode\";s:1:\"0\";s:12:\"vads_version\";s:2:\"V2\";s:20:\"vads_warranty_result\";s:3:\"YES\";s:16:\"vads_payment_src\";s:2:\"EC\";s:13:\"vads_order_id\";s:14:\"21042510122318\";s:15:\"vads_cust_email\";s:18:\"jeffy2a@hotmail.fr\";s:12:\"vads_cust_id\";s:6:\"192731\";s:16:\"vads_cust_status\";s:7:\"PRIVATE\";s:14:\"vads_cust_name\";s:19:\"JEAN-FRANCOIS PORCU\";s:20:\"vads_cust_first_name\";s:13:\"JEAN-FRANCOIS\";s:19:\"vads_cust_last_name\";s:5:\"PORCU\";s:20:\"vads_cust_legal_name\";s:0:\"\";s:8:\"vads_tid\";s:3:\"001\";s:20:\"vads_sequence_number\";s:1:\"1\";s:21:\"vads_acquirer_network\";s:2:\"CB\";s:18:\"vads_contract_used\";s:7:\"5945746\";s:17:\"vads_trans_status\";s:10:\"AUTHORISED\";s:17:\"vads_expiry_month\";s:1:\"1\";s:16:\"vads_expiry_year\";s:4:\"2024\";s:14:\"vads_bank_code\";s:5:\"12006\";s:15:\"vads_bank_label\";s:56:\"Caisse régionale de crédit agricole mutuel de la Corse\";s:17:\"vads_bank_product\";s:3:\"TCS\";s:12:\"vads_pays_ip\";s:2:\"FR\";s:22:\"vads_presentation_date\";s:14:\"20210909111138\";s:28:\"vads_effective_creation_date\";s:14:\"20210909111138\";s:20:\"vads_occurrence_type\";s:8:\"UNITAIRE\";s:19:\"vads_operation_type\";s:5:\"DEBIT\";s:11:\"vads_result\";s:2:\"00\";s:17:\"vads_extra_result\";s:0:\"\";s:17:\"vads_card_country\";s:2:\"FR\";s:13:\"vads_language\";s:2:\"fr\";s:21:\"vads_brand_management\";s:61:\"{\"userChoice\":false,\"brandList\":\"CB|MASTERCARD\",\"brand\":\"CB\"}\";s:9:\"vads_hash\";s:64:\"bc0729b45a737461e1c361144febe9f157ac7a07e4fb992b9dd1f24ca782b95b\";s:18:\"vads_url_check_src\";s:3:\"PAY\";s:16:\"vads_action_mode\";s:11:\"INTERACTIVE\";s:19:\"vads_payment_config\";s:6:\"SINGLE\";s:16:\"vads_page_action\";s:7:\"PAYMENT\";s:21:\"vads_threeds_enrolled\";s:1:\"Y\";s:22:\"vads_threeds_auth_type\";s:9:\"CHALLENGE\";s:16:\"vads_threeds_eci\";s:2:\"02\";s:16:\"vads_threeds_xid\";s:0:\"\";s:26:\"vads_threeds_cavvAlgorithm\";s:0:\"\";s:19:\"vads_threeds_status\";s:1:\"Y\";s:23:\"vads_threeds_sign_valid\";s:0:\"\";s:23:\"vads_threeds_error_code\";s:0:\"\";s:24:\"vads_threeds_exit_status\";s:2:\"10\";s:17:\"vads_threeds_cavv\";s:28:\"jGE67DDSdi/oAAVhOewf+hbHrFI=\";s:9:\"signature\";s:40:\"b0cff63ea202acd2849f406f4de1701361453f55\";}','a:25:{s:12:\"vads_site_id\";s:8:\"21195833\";s:13:\"vads_ctx_mode\";s:10:\"PRODUCTION\";s:12:\"vads_version\";s:2:\"V2\";s:13:\"vads_language\";s:2:\"fr\";s:9:\"signature\";s:0:\"\";s:15:\"vads_trans_date\";s:14:\"20210909111126\";s:13:\"vads_trans_id\";s:6:\"134142\";s:13:\"vads_currency\";s:3:\"978\";s:16:\"vads_page_action\";s:7:\"PAYMENT\";s:16:\"vads_action_mode\";s:11:\"INTERACTIVE\";s:19:\"vads_payment_config\";s:6:\"SINGLE\";s:16:\"vads_return_mode\";s:4:\"POST\";s:15:\"vads_url_return\";s:68:\"https://licence.ffsa.org/paiements/commandepagec/21042510122318.html\";s:16:\"vads_url_success\";s:68:\"https://licence.ffsa.org/paiements/commandepagec/21042510122318.html\";s:15:\"vads_url_cancel\";s:53:\"https://licence.ffsa.org/paiements/commandepageb.html\";s:14:\"vads_url_error\";s:53:\"https://licence.ffsa.org/paiements/commandepageb.html\";s:16:\"vads_url_refused\";s:53:\"https://licence.ffsa.org/paiements/commandepageb.html\";s:15:\"vads_cust_email\";s:18:\"jeffy2a@hotmail.fr\";s:20:\"vads_cust_first_name\";s:13:\"JEAN-FRANCOIS\";s:12:\"vads_cust_id\";s:6:\"192731\";s:19:\"vads_cust_last_name\";s:5:\"PORCU\";s:20:\"vads_cust_legal_name\";N;s:16:\"vads_cust_status\";s:7:\"PRIVATE\";s:11:\"vads_amount\";d:38300;s:13:\"vads_order_id\";s:14:\"21042510122318\";}','2','21042510122318',NULL,NULL,486552,NULL,NULL,'0','2021-09-09 13:12:33',0.00,NULL,NULL,NULL,NULL,'N',NULL);
The table "Personnes" contain 361740 rows.
INSERT INTO `Personnes` VALUES (541732,'2003-02-27 00:00:00','2015-08-29 13:51:52','P',10005,'M','DURANEL','OLIVIER','M','1970-07-29',NULL,'FR','250',NULL,NULL,NULL,NULL,0,0,'DURANEL',NULL,'N','JN','A',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'O',NULL,NULL,NULL,NULL,NULL,'10012','NR',NULL,'O','N',NULL,NULL,NULL,'N','N','O','O');
INSERT INTO `Personnes` VALUES (541742,'2003-02-27 00:00:00','2015-08-29 13:51:52','P',10005,'M','BES','CYRIL','M','1973-11-04',NULL,'FR','250',NULL,NULL,NULL,NULL,0,0,'BES',NULL,'N','JN','A',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'O',NULL,NULL,NULL,NULL,NULL,'1','NR',NULL,'O','N',NULL,NULL,NULL,'N','N','O','O');
541756,'2003-02-27 00:00:00','2016-12-09 12:52:05','P',10005,'M','GARIN','PIERRE','M','1984-11-12','','FR','250',NULL,NULL,NULL,NULL,0,0,'GARIN',NULL,'N','JN','A',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'O',NULL,NULL,NULL,NULL,NULL,'10015','NR',NULL,'O','N',NULL,NULL,NULL,'N','N','O','O'
INSERT INTO `Personnes` VALUES (541774,'2003-02-27 00:00:00','2024-03-20 08:31:43','P',10005,'M','GUILLERIN','NICOLAS','M','1979-06-10',NULL,'FR','250','','','',NULL,0,0,'GUILLERIN',NULL,'N','JN','A',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'O','2024-03-20 08:29:39',NULL,NULL,NULL,NULL,'0',NULL,'','O','O','2019-01-02 13:03:01',NULL,'2019-02-12 13:03:58','N','N','O','O');
The table "UfolepDiplomes" contain 2084 rows.
INSERT INTO `UfolepDiplomes` VALUES (1211,'1','VALLERAY','Fabrice','TIVOLI POST COLON','97200','FORT DE France','UFOLEP',53764653,'2014/07/1184',1,'2014-05-11',58,NULL,'valleray fabrice .jpg',NULL,'','','','FAUX','1',NULL,NULL,500060521);
INSERT INTO `UfolepDiplomes` VALUES (1212,'2','CALVEYRAC','Claudine','Qrt Grotin Rue Appolinaire vilant','97213','ROS MORNE','UFOLEP',53764653,'2014/07/1185',4,'2014-05-11',58,NULL,'calveyrac claudine .jpg',NULL,'','','','FAUX','1',NULL,NULL,500060522);
INSERT INTO `UfolepDiplomes` VALUES (1213,'1','LAGUERRE','Philippe','10 Rue Constantin sylvestre','97200','FORT DE France','UFOLEP',53764653,'2014/07/1186',4,'2014-05-11',58,NULL,'laguerre philippe .jpg',NULL,'','','','FAUX','1',NULL,NULL,500060523);
INSERT INTO `UfolepDiplomes` VALUES (1214,'2','BARRAL','Françoise','315 Quartier Peyroulaud','26400','MIRABEL ET BLACONS','UFOLEP',53764653,'2015/06/1187',1,'2015-02-28',59,'2022-12-31','BARAL Françoise.JPG',NULL,'','','','VRAI','1',54,'2020-01-11',500060524);
INSERT INTO `UfolepDiplomes` VALUES (1215,'2','DAVAL','Lucie','365 chemin de la Combe','38260','ARZAY','UFOLEP',53764653,'2015/06/1188',1,'2015-02-28',59,'2017-12-31','DAVAL Lucie.JPG',NULL,'','','','VRAI','1',NULL,NULL,500060525);
INSERT INTO `UfolepDiplomes` VALUES (1216,'1','DUCREUX','Anthony','Le Laffray','69770','VILLECHENEVE','UFOLEP',53764653,'2015/06/1189',1,'2015-02-28',59,'2021-12-31','DUCREUX Anthony.JPG',NULL,'','','','VRAI','1',63,'2021-05-05',500060526);
INSERT INTO `UfolepDiplomes` VALUES (1217,'1','DUCREUX','Sébastien','Le Laffray','69770','VILLECHENEVE','UFOLEP',53764653,'2015/06/1190',1,'2015-02-28',59,'2021-12-31','DUCREUX Sébastien.JPG',NULL,'','','','VRAI','1',63,'2021-05-05',500060527);
INSERT INTO `UfolepDiplomes` VALUES (1218,'2','GELIN','Fatima','282 route des Champs','01400','MOGNENEINS','UFOLEP',53764653,'2015/06/1191',1,'2015-02-25',59,'2017-12-31','GELIN Fatima.JPG',NULL,'','','','VRAI','1',NULL,NULL,500060528);
INSERT INTO `UfolepDiplomes` VALUES (1219,'2','GELIN','Isabelle','655 route D\' arS','01600','SAINTE EUPHEMIE','UFOLEP',53764653,'2015/06/1192',1,'2015-02-28',59,'2021-12-31','GELIN Isabelle.JPG',NULL,'','','','VRAI','1',63,'2021-05-05',500060529);
The table "users" contain 11460 rows.
INSERT INTO `users` VALUES (11453,'GUILLE NELLY','41642',1164301,'nelly.guille@gmail.com',NULL,'$2y$10$9.LaTc3ApxXzPkTulZtYDeuzXMfX7fEFUOw5YBHlgZNu9CZb0RU5W',NULL,'2024-12-15 10:21:16','2024-12-15 10:21:16');
INSERT INTO `users` VALUES (11454,'BOUVIER PHILIPPE','PBOUVIER',1365161,'philippe-bouvier@laposte.net',NULL,'$2y$10$KT1OP9kAUAp7o.OT0tcGIu8oWd15B4powM3Xg9wsKE1mudfDDMiN6',NULL,'2024-12-15 10:50:49','2024-12-15 10:50:49');
INSERT INTO `users` VALUES (11455,'JOSEPH TEDDY','315006',500018304,'chris91.joseph@gmail.com',NULL,'$2y$10$YHDH8YNlCORbxNSQD/IrEuV1pTihaQuzMGceGt48W/B1SssxqK1Ze',NULL,'2024-12-15 11:47:52','2024-12-15 11:47:52');
INSERT INTO `users` VALUES (11456,'LAFFITTE LOIC','210100',917585,'tayga33@live.fr',NULL,'$2y$10$6PpvTB08KjNJG4Pm8Dkz.evG.Xw6ImMGwNcTzzdg.d/FkYLwVXHZ.',NULL,'2024-12-15 13:00:55','2024-12-15 13:02:55');
INSERT INTO `users` VALUES (11457,'GUINE YAEL','366954',500070252,'guine.yael@gmail.com',NULL,'$2y$10$e9bcerpMXSDfMvJDQk5A4OM7cz.1LEknsuYadBfcrzhIWdNfKUl3q',NULL,'2024-12-15 13:57:12','2024-12-15 13:57:12');
INSERT INTO `users` VALUES (11458,'LEJEUNE LOUIS','143156',20540306,'louislejeune@orange.fr',NULL,'$2y$10$YVlz0wNlKFFCwkaNwn9DEemv1TWIQ.0dF84EMG8LZFZpcQAKvgBD2',NULL,'2024-12-15 14:45:33','2024-12-15 14:45:33');
INSERT INTO `users` VALUES (11459,'JOLY KYLIAN','100492',378890,'kylian-joly@orange.fr',NULL,'$2y$10$q6RbfzbsQ4zo7rUpvfWUK.bh0v8ruk3Y3eQtOrAVBtmjx1YcUno7i',NULL,'2024-12-15 15:46:24','2024-12-15 15:46:24');
INSERT INTO `users` VALUES (11460,'GAST NATHAN','358256',500061554,'g.gast@express-sundgoviens.fr',NULL,'$2y$10$OJLadW4DafODkXQRe9oaNefZc.vcNxv7gO.PkEEFjrUOge29Zwjke',NULL,'2024-12-15 16:38:50','2024-12-15 16:38:50');
INSERT INTO `users` VALUES (11461,'MOULIN JEAN MICHEL','368165',500071463,'moulin.jeanmichel@free.fr',NULL,'$2y$10$SjkrDfWiPViQK.6hFtqqduhtFzHpDvr17HziXdgaB0Re9gOk7iDji',NULL,'2024-12-15 17:04:37','2024-12-15 17:04:37');
INSERT INTO `users` VALUES (11462,'CROS BENJAMIN','314466',500017763,'benjamincros@orange.fr',NULL,'$2y$10$5RTCKH4M3oLY1LHQtkHQfOtC0KwCVS93DUKHandl3Y3PTlCcDzI4u',NULL,'2024-12-15 17:51:21','2024-12-15 17:51:21');
Offer a price in PM.
Only MM
The database contain too some Formule 1 and Formule 2 celebrity like Esteban Ocon, Pierre Gasly...
Sample :
The table "_ImportLicencies" contain 286244 rows.
INSERT INTO `_ImportLicencies` VALUES (528231,'{\"nom\": \"PUJOL\", \"oid\": 528231, \"cnil\": 2, \"etat\": 512, \"actif\": true, \"cspID\": 1, \"homme\": true, \"prenom\": \"MARC\", \"pseudo\": \"\", \"formeID\": 10005, \"contactID\": 528232, \"dateDeces\": null, \"numPermis\": \"880.448.321.050\", \"typeOrgID\": 3, \"civiliteID\": 1, \"datePermis\": \"1988-07-08T00:00:00\", \"disPrincID\": null, \"lieuPermis\": \"Toulon\", \"numLicAv95\": 0, \"coordonnees\": {\"oid\": 528235, \"actif\": true, \"telco\": {\"oid\": 528234, \"actif\": true, \"email\": \"\", \"telIp\": \"\", \"telFixe\": \"\", \"emailSec\": \"\", \"telMobile\": \"06 74 33 21 18\", \"telecopie\": \"\", \"dateDerModif\": \"2017-12-19T10:43:41.67\"}, \"adresse\": {\"oid\": 528233, \"actif\": true, \"estVIP\": false, \"ligne1\": \"3 RUE DES CHEVAUCHEURS\", \"ligne2\": \"\", \"communeID\": 1030397, \"dateDerModif\": \"2015-08-29T00:09:48.77\"}, \"dateDerModif\": \"2015-08-29T00:09:48.77\", \"typeAdresseID\": 1}, \"datePremLic\": \"2002-10-29T00:00:00\", \"disSecondID\": null, \"dateDerModif\": \"2002-10-29T00:00:00\", \"dateLicenceOr\": null, \"dateNaissance\": \"1970-05-14T00:00:00\", \"lieuNaissance\": null, \"nationaliteID\": 2, \"organisationID\": 14030, \"numLicenceCours\": \"132818\", \"dateDerModifContact\": \"2015-08-29T13:51:49.527\"}','N',528231,132818,NULL,'2',NULL,'3 RUE DES CHEVAUCHEURS','','Toulon','1988-07-08T00:00:00','880.448.321.050','','','2002-10-29T00:00:00','0','','','','2','',1030397,'1');
INSERT INTO `_ImportLicencies` VALUES (528236,'{\"nom\": \"DE MAYNADIER\", \"oid\": 528236, \"cnil\": 2, \"etat\": 512, \"actif\": true, \"cspID\": 1, \"homme\": true, \"prenom\": \"BENOIT\", \"pseudo\": \"\", \"formeID\": 10005, \"contactID\": 528237, \"dateDeces\": null, \"numPermis\": \"921.075.105.383\", \"typeOrgID\": 3, \"civiliteID\": 1, \"datePermis\": \"1993-01-05T00:00:00\", \"disPrincID\": null, \"lieuPermis\": \"Bordeaux\", \"numLicAv95\": 0, \"coordonnees\": {\"oid\": 528240, \"actif\": true, \"telco\": {\"oid\": 528239, \"actif\": true, \"email\": \"\", \"telIp\": \"\", \"telFixe\": \"01 39 49 07 25\", \"emailSec\": \"\", \"telMobile\": \"\", \"telecopie\": \"\", \"dateDerModif\": \"2017-12-19T10:43:41.67\"}, \"adresse\": {\"oid\": 528238, \"actif\": true, \"estVIP\": false, \"ligne1\": \"1 RUE DE LA CATHEDRALE\", \"ligne2\": \"\", \"communeID\": 1034223, \"dateDerModif\": \"2015-08-29T00:09:48.783\"}, \"dateDerModif\": \"2015-08-29T00:09:48.787\", \"typeAdresseID\": 1}, \"datePremLic\": \"2002-10-29T00:00:00\", \"disSecondID\": null, \"dateDerModif\": \"2002-10-29T00:00:00\", \"dateLicenceOr\": null, \"dateNaissance\": \"1971-01-25T00:00:00\", \"lieuNaissance\": null, \"nationaliteID\": 2, \"organisationID\": 14030, \"numLicenceCours\": \"132819\", \"dateDerModifContact\": \"2015-08-29T13:51:49.527\"}','N',528236,132819,NULL,'2',NULL,'1 RUE DE LA CATHEDRALE','','Bordeaux','1993-01-05T00:00:00','921.075.105.383','','','2002-10-29T00:00:00','0','','','','2','',1034223,'1');
INSERT INTO `_ImportLicencies` VALUES (528241,'{\"nom\": \"COLIBET\", \"oid\": 528241, \"cnil\": 1, \"etat\": 32, \"actif\": true, \"cspID\": 1, \"homme\": true, \"prenom\": \"JACQUES\", \"pseudo\": \"\", \"formeID\": 10005, \"contactID\": 528242, \"dateDeces\": null, \"numPermis\": \"15AN07419\", \"typeOrgID\": 3, \"civiliteID\": 1, \"datePermis\": \"2015-07-06T00:00:00\", \"disPrincID\": null, \"lieuPermis\": \"Evry\", \"numLicAv95\": 53521, \"coordonnees\": {\"oid\": 528245, \"actif\": true, \"telco\": {\"oid\": 528244, \"actif\": true, \"email\": \"christinecolibet@orange.fr\", \"telIp\": \"\", \"telFixe\": \"\", \"emailSec\": \"\", \"telMobile\": \"06 80 92 18 08\", \"telecopie\": \"\", \"dateDerModif\": \"2018-06-24T02:00:04.38\"}, \"adresse\": {\"oid\": 528243, \"actif\": true, \"estVIP\": false, \"ligne1\": \"52 RUE DE LA BOISSIERE\", \"ligne2\": \"\", \"communeID\": 1038365, \"dateDerModif\": \"2018-06-22T22:08:28\"}, \"dateDerModif\": \"2018-06-22T22:08:28\", \"typeAdresseID\": 1}, \"datePremLic\": \"1995-03-10T00:00:00\", \"disSecondID\": null, \"dateDerModif\": \"2018-06-22T22:08:28\", \"dateLicenceOr\": null, \"dateNaissance\": \"1955-01-25T00:00:00\", \"lieuNaissance\": \"BRETIGNY SUR ORGE\", \"nationaliteID\": 2, \"organisationID\": 15362, \"numLicenceCours\": \"13282\", \"dateDerModifContact\": \"2018-06-22T22:08:28\"}','N',528241,13282,NULL,'2',NULL,'52 RUE DE LA BOISSIERE','','Evry','2015-07-06T00:00:00','15AN07419','','','1995-03-10T00:00:00','53521','','','','1','',1038365,'1');
INSERT INTO `_ImportLicencies` VALUES (528246,'{\"nom\": \"MARTEAU\", \"oid\": 528246, \"cnil\": 2, \"etat\": 512, \"actif\": true, \"cspID\": 1, \"homme\": true, \"prenom\": \"OLIVIER\", \"pseudo\": \"\", \"formeID\": 10005, \"contactID\": 528247, \"dateDeces\": null, \"numPermis\": \"920.779.200.418\", \"typeOrgID\": 3, \"civiliteID\": 1, \"datePermis\": \"1994-08-11T00:00:00\", \"disPrincID\": null, \"lieuPermis\": \"Niort\", \"numLicAv95\": 0, \"coordonnees\": {\"oid\": 528250, \"actif\": true, \"telco\": {\"oid\": 528249, \"actif\": true, \"email\": \"\", \"telIp\": \"\", \"telFixe\": \"\", \"emailSec\": \"\", \"telMobile\": \"06 60 49 38 88\", \"telecopie\": \"\", \"dateDerModif\": \"2017-12-19T10:43:41.673\"}, \"adresse\": {\"oid\": 528248, \"actif\": true, \"estVIP\": false, \"ligne1\": \"ROUTE DE LA PLAGNE\", \"ligne2\": \"\", \"communeID\": 1032485, \"dateDerModif\": \"2015-08-29T00:09:48.813\"}, \"dateDerModif\": \"2015-08-29T00:09:48.817\", \"typeAdresseID\": 1}, \"datePremLic\": \"2002-10-29T00:00:00\", \"disSecondID\": null, \"dateDerModif\": \"2002-10-29T00:00:00\", \"dateLicenceOr\": null, \"dateNaissance\": \"1976-07-06T00:00:00\", \"lieuNaissance\": null, \"nationaliteID\": 2, \"organisationID\": 14030, \"numLicenceCours\": \"132820\", \"dateDerModifContact\": \"2015-08-29T13:51:49.53\"}','N',528246,132820,NULL,'2',NULL,'ROUTE DE LA PLAGNE','','Niort','1994-08-11T00:00:00','920.779.200.418','','','2002-10-29T00:00:00','0','','','','2','',1032485,'1');
INSERT INTO `_ImportLicencies` VALUES (528251,'{\"nom\": \"PELEGRY\", \"oid\": 528251, \"cnil\": 2, \"etat\": 512, \"actif\": true, \"cspID\": 1, \"homme\": true, \"prenom\": \"CEDRIC\", \"pseudo\": \"\", \"formeID\": 10005, \"contactID\": 528252, \"dateDeces\": null, \"numPermis\": \"910681110580\", \"typeOrgID\": 3, \"civiliteID\": 1, \"datePermis\": \"1997-06-24T00:00:00\", \"disPrincID\": null, \"lieuPermis\": \"Albi\", \"numLicAv95\": 0, \"coordonnees\": {\"oid\": 528255, \"actif\": true, \"telco\": {\"oid\": 528254, \"actif\": true, \"email\": \"\", \"telIp\": \"\", \"telFixe\": \"\", \"emailSec\": \"\", \"telMobile\": \"06 24 28 60 46\", \"telecopie\": \"\", \"dateDerModif\": \"2017-12-19T10:43:41.673\"}, \"adresse\": {\"oid\": 528253, \"actif\": true, \"estVIP\": false, \"ligne1\": \"6 RUE PEGASSE\", \"ligne2\": \"\", \"communeID\": 1035513, \"dateDerModif\": \"2015-08-29T00:09:48.83\"}, \"dateDerModif\": \"2015-08-29T00:09:48.833\", \"typeAdresseID\": 1}, \"datePremLic\": \"2002-10-29T00:00:00\", \"disSecondID\": null, \"dateDerModif\": \"2002-10-29T00:00:00\", \"dateLicenceOr\": null, \"dateNaissance\": \"1973-08-22T00:00:00\", \"lieuNaissance\": null, \"nationaliteID\": 2, \"organisationID\": 13209, \"numLicenceCours\": \"132821\", \"dateDerModifContact\": \"2015-08-29T13:51:49.53\"}','N',528251,132821,NULL,'2',NULL,'6 RUE PEGASSE','','Albi','1997-06-24T00:00:00','910681110580','','','2002-10-29T00:00:00','0','','','','2','',1035513,'1');
INSERT INTO `_ImportLicencies` VALUES (528256,'{\"nom\": \"LEROY\", \"oid\": 528256, \"cnil\": 2, \"etat\": 512, \"actif\": true, \"cspID\": 10012, \"homme\": false, \"prenom\": \"RENEE\", \"pseudo\": \"\", \"formeID\": 10005, \"contactID\": 528257, \"dateDeces\": null, \"numPermis\": \"800.527.300.841\", \"typeOrgID\": 3, \"civiliteID\": 2, \"datePermis\": \"1980-12-24T00:00:00\", \"disPrincID\": null, \"lieuPermis\": \"Evreux\", \"numLicAv95\": 0, \"coordonnees\": {\"oid\": 528260, \"actif\": true, \"telco\": {\"oid\": 528259, \"actif\": true, \"email\": \"\", \"telIp\": \"\", \"telFixe\": \"02 43 72 08 26\", \"emailSec\": \"\", \"telMobile\": \"\", \"telecopie\": \"\", \"dateDerModif\": \"2017-12-19T10:43:41.677\"}, \"adresse\": {\"oid\": 528258, \"actif\": true, \"estVIP\": false, \"ligne1\": \"156 AVENUE BOLLEE - HALL 5\", \"ligne2\": \"\", \"communeID\": 1031754, \"dateDerModif\": \"2015-08-29T00:09:48.843\"}, \"dateDerModif\": \"2015-08-29T00:09:48.847\", \"typeAdresseID\": 1}, \"datePremLic\": \"2002-10-29T00:00:00\", \"disSecondID\": null, \"dateDerModif\": \"2003-02-05T00:00:00\", \"dateLicenceOr\": null, \"dateNaissance\": \"1962-10-09T00:00:00\", \"lieuNaissance\": null, \"nationaliteID\": 2, \"organisationID\": 14687, \"numLicenceCours\": \"132822\", \"dateDerModifContact\": \"2015-08-29T13:51:49.53\"}','N',528256,132822,NULL,'2',NULL,'156 AVENUE BOLLEE - HALL 5','','Evreux','1980-12-24T00:00:00','800.527.300.841','','','2002-10-29T00:00:00','0','','','','2','',1031754,'2');
INSERT INTO `_ImportLicencies` VALUES (528261,'{\"nom\": \"LEROY\", \"oid\": 528261, \"cnil\": 2, \"etat\": 512, \"actif\": true, \"cspID\": 10015, \"homme\": true, \"prenom\": \"NICOLAS\", \"pseudo\": \"\", \"formeID\": 10005, \"contactID\": 528262, \"dateDeces\": null, \"numPermis\": \"\", \"typeOrgID\": 3, \"civiliteID\": 1, \"datePermis\": null, \"disPrincID\": null, \"lieuPermis\": \"\", \"numLicAv95\": 0, \"coordonnees\": {\"oid\": 528265, \"actif\": true, \"telco\": {\"oid\": 528264, \"actif\": true, \"email\": \"\", \"telIp\": \"\", \"telFixe\": \"02 43 72 08 26\", \"emailSec\": \"\", \"telMobile\": \"\", \"telecopie\": \"\", \"dateDerModif\": \"2017-12-19T10:43:41.677\"}, \"adresse\": {\"oid\": 528263, \"actif\": true, \"estVIP\": false, \"ligne1\": \"156 AVENUE BOLLEE\", \"ligne2\": \"HALL 5\", \"communeID\": 1031754, \"dateDerModif\": \"2015-08-29T00:09:48.857\"}, \"dateDerModif\": \"2015-08-29T00:09:48.86\", \"typeAdresseID\": 1}, \"datePremLic\": \"2002-10-21T00:00:00\", \"disSecondID\": null, \"dateDerModif\": \"2003-02-05T00:00:00\", \"dateLicenceOr\": null, \"dateNaissance\": \"1986-08-04T00:00:00\", \"lieuNaissance\": null, \"nationaliteID\": 2, \"organisationID\": 14687, \"numLicenceCours\": \"106948\", \"dateDerModifContact\": \"2015-08-29T13:51:49.54\"}','N',528261,106948,NULL,'2',NULL,'156 AVENUE BOLLEE','HALL 5','','','','','','2002-10-21T00:00:00','0','','','','2','',1031754,'1');
The table "Adresses" contain 362875 rows.
INSERT INTO `Adresses` VALUES (252461,1608248,0,'2015-08-29 01:08:30','PR',NULL,NULL,NULL,NULL,NULL,'81 rue des Cassis','Althen des Palude',NULL,'','84210','','PERNES LES FONTAINES',1036209,'00000',NULL,'FR','','','90621927','','',NULL,'',NULL,NULL,NULL,000,000);
HUGO','',NULL,'','72600','','MAMERS',1031753,'00000',NULL,'FR','','','0243974641','','',NULL,'',NULL,NULL,NULL,000,000);
INSERT INTO `Adresses` VALUES (252476,1608346,0,'2015-08-29 01:08:31','PR',NULL,NULL,NULL,NULL,NULL,'Z.A de la Brique','',NULL,'','53810','','CHANGE',1021670,'00000',NULL,'FR','','','43536690','','',NULL,'',NULL,NULL,NULL,000,000);
INSERT INTO `Adresses` VALUES (252477,1608351,0,'2024-03-11 20:06:06','PR',NULL,NULL,NULL,NULL,NULL,'11 RUE RICHARD COEUR DE LION','',NULL,'','17170','','BENON',1006357,'17041',NULL,'FR','anthonydesousa17170@gmail.com','','','','0650932543',NULL,NULL,NULL,NULL,NULL,000,000);
INSERT INTO `Adresses` VALUES (252478,1608366,0,'2015-08-29 01:08:31','PR',NULL,NULL,NULL,NULL,NULL,'13 rue Mal Delattre de Tassigny','',NULL,'','49240','','AVRILLE',1019421,'00000',NULL,'FR','','','0241342764','','',NULL,'',NULL,NULL,NULL,000,000);
INSERT INTO `Adresses` VALUES (252479,1608376,0,'2015-08-29 01:08:31','PR',NULL,NULL,NULL,NULL,NULL,'9 rue du Coche d\'eau','',NULL,'','44000','','NANTES',1018056,'00000',NULL,'FR','','','40124731','','',NULL,'',NULL,NULL,NULL,000,000);
INSERT INTO `Adresses` VALUES (252480,1608381,0,'2015-08-29 01:08:31','PR',NULL,NULL,NULL,NULL,NULL,'4 AVENUE DU CLERY','',NULL,'','44500','','LA BAULE ESCOUBLAC',1017991,'00000',NULL,'FR','tassin.nicolas@neuf.fr','','0240530776','','',NULL,'',NULL,NULL,NULL,000,000);
INSERT INTO `Adresses` VALUES (252481,1608386,0,'2015-08-29 01:08:31','PR',NULL,NULL,NULL,NULL,NULL,'2 rue Pointoise','Chacrise',NULL,'','02200','','SOISSONS',1001171,'00000',NULL,'FR','','','23551691','','',NULL,'',NULL,NULL,NULL,000,000);
INSERT INTO `Adresses` VALUES (252482,1608391,0,'2015-08-29 01:08:31','PR',NULL,NULL,NULL,NULL,NULL,'15 Res.Pasteur','Avenue Dupuis',NULL,'','02800','','LA FERE',1000758,'00000',NULL,'FR','','','23567754','','',NULL,'',NULL,NULL,NULL,000,000);
INSERT INTO `Adresses` VALUES (252483,1608396,0,'2015-08-29 01:08:31','PR',NULL,NULL,NULL,NULL,NULL,'8 RUE STENDHAL','',NULL,'','35235','','THORIGNE FOUILLARD',1014967,'00000',NULL,'FR','','','0299620220','','',NULL,'',NULL,NULL,NULL,000,000);
INSERT INTO `Adresses` VALUES (252484,1608401,0,'2015-08-29 01:08:31','PR',NULL,NULL,NULL,NULL,NULL,'2 rue Pontoise','Chacrise',NULL,'','02200','','SOISSONS',1001171,'00000',NULL,'FR','','','23551691','','',NULL,'',NULL,NULL,NULL,000,000);
The table "CompteLicencie" contain 51359 rows.
INSERT INTO `CompteLicencie` VALUES ('263283',24367422,'TSka1E55u9d0B2FD0s9Vx8IPGFLQevLHiC8ySFtX9PGgYArBJ/nWv1EHHZwR7BQhCaY7vycyIK4WOXN77nUIxnhgLoNgj/P8l6AaeSRyRP8e3AZ0y+ZeVPOZb+PGiQx36UAld7MU0tl9G/c6KZKXHQ==','54b595f1e8041902682aa5485a7d2903254ecee3600a9967482d8f0e7ae32d9beebc86af337ce621b416fc8f31a27c66bf5f9590f9a8e23d3458f906750bc413','$1$WTm4WVG7$hQk7hxTLfbUv4UZJxq5bs/','2023-04-01 01:06:08','2023-06-05 19:47:54');
INSERT INTO `CompteLicencie` VALUES ('239557',1066638,'CGq1ZaYy1PHzadu71B5rPZJ+iN9RH5jC7FztyN8RgoJxAO9ga2o84ybFgol+FS5OAwyUaTDkRWLjnsQUfuFnMBksCvecCvehb9NRHSGzWRQl7rnBqlmR1CG+N+cpN/Wk','b7a80a66ecbe0d52e99faf33f55baf72767c5b1de0c631365624d8ec740860f5af9edcc535d32fa5c50d21128efd53be879e681d49957e6db393af147ab95648','$1$bAP/rqr1$Nvt4Z6TKmwekrqyY5fH4j/','2023-04-01 05:09:05','2023-04-01 05:09:05');
INSERT INTO `CompteLicencie` VALUES ('344044',500047340,'YF5bCFnBZeSMt/4gXTWipkG2B4zUfTHasv0rEnbocTKby3xF0PmsfHbm4QlJeTlo7e3/VNcptOe4NjeOEhvfqLOYegkIewk5mGKJW0kHDg0cXSqJrOtvYMD70838tSyX','225b9b0463a5fdbc4f748e3777b600ab623711f8172c2d6db92e17157d9527338a2f5a77832668d90ea66af350d9f402c1e2d31fedbb095d1c2ab4a86c71dd7f','$1$09e/LUs5$J3A7glYBf33ULF40bSrC5/','2023-04-01 08:27:43','2023-04-01 08:27:43');
INSERT INTO `CompteLicencie` VALUES ('310872',500014169,'gjkj5fGOFU1S20InX7LIlq98hZd1QtSxZ7c1DQSW9+ygY8ylKnBbR/xkDre10n9/XkakDbKIAKpi5dZ1NUjObG8eWdhdi1CghopHGM1GRyQv7edVKMrdKpV2/spd1RuG','50231622a1e076d36b749244025c72300a30622a8658cb0cf7a9a636a4b0052b68bb5cb7f7e979bbc6b8c47009d77315b49f6dff439c14489096c1f8d9a6b398','$1$EXmTzHEK$aqnlxx4TFpjXnLaZwvJjE1','2023-04-01 09:03:48','2024-06-10 09:54:35');
INSERT INTO `CompteLicencie` VALUES ('344046',500047342,'f7ITWiC7y0n7gJoHJm2O7jh8MyFg+wk0ZJ1NksriSIqhvXD+Lf22E8lXiy+xT7vzgh1hUgPWBHUedlJ9kOXU7slZo4cpOYQrTKwfEUdlikKQKpTGqR/ccizIb2YptB2j','456186df3de4dc1109e4bfe3c04c8568ddf8196fae47b276a49f0ad6f82f2fbb2c8e976f68faa8d67363d08542ff8ff640b1434648a37f30aaf8e4a3f96bf125','$1$9UVZnz5R$HHu9lavKntRJZ7apaOUEM.','2023-04-01 09:05:42','2023-04-01 09:05:42');
INSERT INTO `CompteLicencie` VALUES ('344045',500047341,'Y61mTi1ZvNv7MCfH4EoXs44pGf9X3LMHu2Jb9QeZ74F682canWngWHs3VKeiCkGM7NxqZ3VT1MR/yh7dbdutqGrD4Xfm5kHaiVTsshalY6GFMZGrtQR+LaoOSumcja4H','53aadc589c21757f55378873179b8abbbfb073db61ceadf07ccce5b4bb13ec62e86d9199f7b7a8bb5063b893a5501e2b7ae82eb26c6c44be6681b8941ea98c05','$1$0DnaIqQM$uYOoCh1RdkQwSt2.Xi9mT1','2023-04-01 09:05:48','2023-04-01 09:05:48');
INSERT INTO `CompteLicencie` VALUES ('335140',500038434,'wxW3IYt31dSwc3LU/78JxCwwCSRRxAZG3iS/JsQqLxZtWVyqT3PVEYwP9Sjr6kZKBmULDa/mWzL/hU8WZpNbOQ/Yg1jFgBjrydHntn+G8NN2RhbC9T1JlywnYeBLbyG3','f222770598908f6d022bae6a62eacf71d6a09738f956a040d686f0a9f9c9f10bfe7c2d8cd2c888d9070276561b98c71fa0c0c08797de82d64f22c4a74cfb25f3','$1$yPG6l4ij$HIaFNUxgrUeIe2oTEIl840','2023-04-01 09:31:31','2024-05-22 09:22:23');
The table "PanierCmdElectroniques" contain 280762 rows.
NSERT INTO `PanierCmdElectroniques` VALUES (122312,'15c677e0c4c916cc5a4d5504e090f06d8f9c571cf6d7e8729f7c6170e495711f','2021-09-09 11:32:25',0,994646,49893,'-500131870-',100,2021,'CB1',177.00,'Tzo4OiJzdGRDbGFzcyI6NTp7czoxMToidG90YWxQYW5pZXIiO2Q6MTc3O3M6MjA6InRvdGFsUmVndWxhdGlvblNvbGRlIjtpOjA7czoxNDoidG90YWxSZWdsZW1lbnQiO2Q6MTc3O3M6MTE6IkFkcmVzc2VtYWlsIjtzOjI1OiJmbGF2ZXJnbmVAZ2FsdmFub3IyMDAwLmZyIjtzOjEzOiJtb3llblBhaWVtZW50IjtzOjM6IkNCMSI7fQ==','YTozOntpOjA7YToxNDp7czoxOiJZIjtzOjM6IkxJQyI7czo5OiJMaWNlbmNlSWQiO3M6OToiNTAwMTMxODcwIjtzOjU6IkVjcklkIjtzOjY6IjQ4NjUyNCI7czo3OiJFY3JEYXRlIjtzOjE5OiIyMDIxLTA5LTA5IDExOjMyOjA0IjtzOjExOiJMaWNlbmNlRXRhdCI7czoxOiJOIjtzOjEzOiJMaWNHcm91cGVUeXBlIjtzOjM6IkFOVSI7czoxMzoiTGljR3JvdXBlQ29kZSI7czo3OiIyMDIxTkFUIjtzOjE0OiJMaWNlbmNlTW9udGFudCI7czo0OiIwLjAwIjtzOjE2OiJMaWNlbmNlVGFyaWZQcml4IjtzOjQ6IjAuMDAiO3M6MjA6IkxpY2VuY2VUYXJpZlBhcnRBc3N1IjtzOjQ6IjAuMDAiO3M6OToiU3RydWN0dXJlIjtzOjMzOiIxNDg2IC0gQVNLIENPUk1FSUxMRVMgRU4gVkVYSU4gOTUiO3M6MTA6IkVjckxpYmVsbGUiO3M6NzE6IkxpY2VuY2UgMjAyMSA6IE5BVElPTkFMRSBDT05DVVJSRU5UIENPTkRVQ1RFVVIgQVVUTyAtIE0gTEFWRVJHTkUgRlJBTkNLIjtzOjg6IlBlcnNvbm5lIjtzOjE1OiJMQVZFUkdORSBGUkFOQ0siO3M6ODoiQ29tcHRhSWQiO3M6NToiNDk4OTMiO31pOjE7YTo4OntzOjE6IlkiO3M6MzoiQ01VIjtzOjk6IkxpY2VuY2VJZCI7czo5OiI1MDAxMzE4NzAiO3M6NToiRWNySWQiO3M6NjoiNDg2NTI2IjtzOjc6IkVjckRhdGUiO3M6MTk6IjIwMjEtMDktMDkgMTE6MzI6MDQiO3M6MTQ6IkxpY2VuY2VNb250YW50IjtzOjU6IjEwLjAwIjtzOjk6IlN0cnVjdHVyZSI7czozMzoiMTQ4NiAtIEFTSyBDT1JNRUlMTEVTIEVOIFZFWElOIDk1IjtzOjEwOiJFY3JMaWJlbGxlIjtzOjc4OiJDb8O7dCBkZSBjdW11bCAyMDIxIDogTkFUSU9OQUxFIENPTkNVUlJFTlQgQ09ORFVDVEVVUiBBVVRPIC0gTSBMQVZFUkdORSBGUkFOQ0siO3M6ODoiUGVyc29ubmUiO3M6MTU6IkxBVkVSR05FIEZSQU5DSyI7fWk6MjthOjg6e3M6MToiWSI7czo0OiJETElDIjtzOjk6IkxpY2VuY2VJZCI7czo5OiI1MDAxMzE4NzAiO3M6NToiRWNySWQiO3M6NjoiNDg2NTI3IjtzOjc6IkVjckRhdGUiO3M6MTk6IjIwMjEtMDktMDkgMTE6MzI6MDQiO3M6MTQ6IkxpY2VuY2VNb250YW50IjtzOjY6IjE2Ny4wMCI7czo5OiJTdHJ1Y3R1cmUiO3M6MzM6IjE0ODYgLSBBU0sgQ09STUVJTExFUyBFTiBWRVhJTiA5NSI7czoxMDoiRWNyTGliZWxsZSI7czo3NToiRGlmZsOpcmVuY2UgMjAyMSA6IE5BVElPTkFMRSBDT05DVVJSRU5UIENPTkRVQ1RFVVIgQVVUTyAtIE0gTEFWRVJHTkUgRlJBTkNLIjtzOjg6IlBlcnNvbm5lIjtzOjE1OiJMQVZFUkdORSBGUkFOQ0siO319',NULL,NULL,'a:64:{s:11:\"vads_amount\";s:5:\"17700\";s:14:\"vads_auth_mode\";s:4:\"FULL\";s:16:\"vads_auth_number\";s:6:\"224261\";s:16:\"vads_auth_result\";s:2:\"00\";s:18:\"vads_capture_delay\";s:1:\"0\";s:15:\"vads_card_brand\";s:2:\"CB\";s:16:\"vads_card_number\";s:16:\"477173XXXXXX7325\";s:24:\"vads_payment_certificate\";s:40:\"618d8ff1466d467caa74b5c7d782446763dc3f48\";s:13:\"vads_ctx_mode\";s:10:\"PRODUCTION\";s:13:\"vads_currency\";s:3:\"978\";s:21:\"vads_effective_amount\";s:5:\"17700\";s:23:\"vads_effective_currency\";s:3:\"978\";s:12:\"vads_site_id\";s:8:\"21195833\";s:15:\"vads_trans_date\";s:14:\"20210909093225\";s:13:\"vads_trans_id\";s:6:\"134132\";s:15:\"vads_trans_uuid\";s:32:\"aa717f714eec45548bae96966ef2b309\";s:20:\"vads_validation_mode\";s:1:\"0\";s:12:\"vads_version\";s:2:\"V2\";s:20:\"vads_warranty_result\";s:3:\"YES\";s:16:\"vads_payment_src\";s:2:\"EC\";s:13:\"vads_order_id\";s:14:\"21042510122312\";s:15:\"vads_cust_email\";s:25:\"flavergne@galvanor2000.fr\";s:12:\"vads_cust_id\";s:6:\"225412\";s:16:\"vads_cust_status\";s:7:\"PRIVATE\";s:14:\"vads_cust_name\";s:15:\"FRANCK LAVERGNE\";s:20:\"vads_cust_first_name\";s:6:\"FRANCK\";s:19:\"vads_cust_last_name\";s:8:\"LAVERGNE\";s:20:\"vads_cust_legal_name\";s:0:\"\";s:8:\"vads_tid\";s:3:\"001\";s:20:\"vads_sequence_number\";s:1:\"1\";s:21:\"vads_acquirer_network\";s:2:\"CB\";s:18:\"vads_contract_used\";s:7:\"5945746\";s:17:\"vads_trans_status\";s:10:\"AUTHORISED\";s:17:\"vads_expiry_month\";s:1:\"6\";s:16:\"vads_expiry_year\";s:4:\"2023\";s:14:\"vads_bank_code\";s:5:\"30003\";s:15:\"vads_bank_label\";s:20:\"Société générale\";s:17:\"vads_bank_product\";s:1:\"I\";s:12:\"vads_pays_ip\";s:2:\"FR\";s:22:\"vads_presentation_date\";s:14:\"20210909093243\";s:28:\"vads_effective_creation_date\";s:14:\"20210909093243\";s:20:\"vads_occurrence_type\";s:8:\"UNITAIRE\";s:19:\"vads_operation_type\";s:5:\"DEBIT\";s:11:\"vads_result\";s:2:\"00\";s:17:\"vads_extra_result\";s:0:\"\";s:17:\"vads_card_country\";s:2:\"FR\";s:13:\"vads_language\";s:2:\"fr\";s:21:\"vads_brand_management\";s:55:\"{\"userChoice\":false,\"brandList\":\"CB|VISA\",\"brand\":\"CB\"}\";s:9:\"vads_hash\";s:64:\"5f8c085d849f5e7546543614b738922aa30327cfb212c6b2721aea36fe6a077f\";s:18:\"vads_url_check_src\";s:3:\"PAY\";s:16:\"vads_action_mode\";s:11:\"INTERACTIVE\";s:19:\"vads_payment_config\";s:6:\"SINGLE\";s:16:\"vads_page_action\";s:7:\"PAYMENT\";s:21:\"vads_threeds_enrolled\";s:1:\"Y\";s:22:\"vads_threeds_auth_type\";s:9:\"CHALLENGE\";s:16:\"vads_threeds_eci\";s:2:\"05\";s:16:\"vads_threeds_xid\";s:0:\"\";s:26:\"vads_threeds_cavvAlgorithm\";s:0:\"\";s:19:\"vads_threeds_status\";s:1:\"Y\";s:23:\"vads_threeds_sign_valid\";s:0:\"\";s:23:\"vads_threeds_error_code\";s:0:\"\";s:24:\"vads_threeds_exit_status\";s:2:\"10\";s:17:\"vads_threeds_cavv\";s:28:\"AAgBB2AAUAAAAEUkl4JSdFo/5Eo=\";s:9:\"signature\";s:40:\"0d2cd086ede39f58ad70fa7ad5bb63fbb2dd61e5\";}','a:25:{s:12:\"vads_site_id\";s:8:\"21195833\";s:13:\"vads_ctx_mode\";s:10:\"PRODUCTION\";s:12:\"vads_version\";s:2:\"V2\";s:13:\"vads_language\";s:2:\"fr\";s:9:\"signature\";s:0:\"\";s:15:\"vads_trans_date\";s:14:\"20210909093225\";s:13:\"vads_trans_id\";s:6:\"134132\";s:13:\"vads_currency\";s:3:\"978\";s:16:\"vads_page_action\";s:7:\"PAYMENT\";s:16:\"vads_action_mode\";s:11:\"INTERACTIVE\";s:19:\"vads_payment_config\";s:6:\"SINGLE\";s:16:\"vads_return_mode\";s:4:\"POST\";s:15:\"vads_url_return\";s:68:\"https://licence.ffsa.org/paiements/commandepagec/21042510122312.html\";s:16:\"vads_url_success\";s:68:\"https://licence.ffsa.org/paiements/commandepagec/21042510122312.html\";s:15:\"vads_url_cancel\";s:53:\"https://licence.ffsa.org/paiements/commandepageb.html\";s:14:\"vads_url_error\";s:53:\"https://licence.ffsa.org/paiements/commandepageb.html\";s:16:\"vads_url_refused\";s:53:\"https://licence.ffsa.org/paiements/commandepageb.html\";s:15:\"vads_cust_email\";s:25:\"flavergne@galvanor2000.fr\";s:20:\"vads_cust_first_name\";s:6:\"FRANCK\";s:12:\"vads_cust_id\";s:6:\"225412\";s:19:\"vads_cust_last_name\";s:8:\"LAVERGNE\";s:20:\"vads_cust_legal_name\";N;s:16:\"vads_cust_status\";s:7:\"PRIVATE\";s:11:\"vads_amount\";d:17700;s:13:\"vads_order_id\";s:14:\"21042510122312\";}','2','21042510122312',NULL,NULL,486528,NULL,NULL,'0','2021-09-09 11:34:12',0.00,NULL,NULL,NULL,NULL,'N',NULL);
INSERT INTO `PanierCmdElectroniques` VALUES (122318,'c60c0cf4f3db11c93525a78ff96fde060ea6c583baf00112237e14c4b9a1dda5','2021-09-09 13:11:26',0,828786,25047,'-500131876-',100,2021,'CB1',383.00,'Tzo4OiJzdGRDbGFzcyI6NTp7czoxMToidG90YWxQYW5pZXIiO2Q6MzgzO3M6MjA6InRvdGFsUmVndWxhdGlvblNvbGRlIjtpOjA7czoxNDoidG90YWxSZWdsZW1lbnQiO2Q6MzgzO3M6MTE6IkFkcmVzc2VtYWlsIjtzOjE4OiJqZWZmeTJhQGhvdG1haWwuZnIiO3M6MTM6Im1veWVuUGFpZW1lbnQiO3M6MzoiQ0IxIjt9','YTo0OntpOjA7YToxNDp7czoxOiJZIjtzOjM6IkxJQyI7czo5OiJMaWNlbmNlSWQiO3M6OToiNTAwMTMxODc2IjtzOjU6IkVjcklkIjtzOjY6IjQ4NjU0NyI7czo3OiJFY3JEYXRlIjtzOjE5OiIyMDIxLTA5LTA5IDEzOjEwOjI0IjtzOjExOiJMaWNlbmNlRXRhdCI7czoxOiJOIjtzOjEzOiJMaWNHcm91cGVUeXBlIjtzOjM6IkFOVSI7czoxMzoiTGljR3JvdXBlQ29kZSI7czo3OiIyMDIxTkFUIjtzOjE0OiJMaWNlbmNlTW9udGFudCI7czo0OiIwLjAwIjtzOjE2OiJMaWNlbmNlVGFyaWZQcml4IjtzOjQ6IjAuMDAiO3M6MjA6IkxpY2VuY2VUYXJpZlBhcnRBc3N1IjtzOjQ6IjAuMDAiO3M6OToiU3RydWN0dXJlIjtzOjE4OiIwNjA2IC0gQVNBIENPUlNJQ0EiO3M6MTA6IkVjckxpYmVsbGUiO3M6NzU6IkxpY2VuY2UgMjAyMSA6IE5BVElPTkFMRSBDT05DVVJSRU5UIENPTkRVQ1RFVVIgQVVUTyAtIE0gUE9SQ1UgSkVBTi1GUkFOQ09JUyI7czo4OiJQZXJzb25uZSI7czoxOToiUE9SQ1UgSkVBTi1GUkFOQ09JUyI7czo4OiJDb21wdGFJZCI7czo1OiIyNTA0NyI7fWk6MTthOjg6e3M6MToiWSI7czo1OiJDVENMVSI7czo5OiJMaWNlbmNlSWQiO3M6OToiNTAwMTMxODc2IjtzOjU6IkVjcklkIjtzOjY6IjQ4NjU1MSI7czo3OiJFY3JEYXRlIjtzOjE5OiIyMDIxLTA5LTA5IDEzOjEwOjI0IjtzOjE0OiJMaWNlbmNlTW9udGFudCI7czo0OiIxLjAwIjtzOjk6IlN0cnVjdHVyZSI7czoxODoiMDYwNiAtIEFTQSBDT1JTSUNBIjtzOjEwOiJFY3JMaWJlbGxlIjtzOjU4OiJDb3Rpc2F0aW9uIENsdWIgMDYwNiAtIEFTQSBDT1JTSUNBIC0gTSBQT1JDVSBKRUFOLUZSQU5DT0lTIjtzOjg6IlBlcnNvbm5lIjtzOjE5OiJQT1JDVSBKRUFOLUZSQU5DT0lTIjt9aToyO2E6ODp7czoxOiJZIjtzOjM6IkNNVSI7czo5OiJMaWNlbmNlSWQiO3M6OToiNTAwMTMxODc2IjtzOjU6IkVjcklkIjtzOjY6IjQ4NjU0OSI7czo3OiJFY3JEYXRlIjtzOjE5OiIyMDIxLTA5LTA5IDEzOjEwOjI0IjtzOjE0OiJMaWNlbmNlTW9udGFudCI7czo1OiIxMC4wMCI7czo5OiJTdHJ1Y3R1cmUiO3M6MTg6IjA2MDYgLSBBU0EgQ09SU0lDQSI7czoxMDoiRWNyTGliZWxsZSI7czo4MjoiQ2/Du3QgZGUgY3VtdWwgMjAyMSA6IE5BVElPTkFMRSBDT05DVVJSRU5UIENPTkRVQ1RFVVIgQVVUTyAtIE0gUE9SQ1UgSkVBTi1GUkFOQ09JUyI7czo4OiJQZXJzb25uZSI7czoxOToiUE9SQ1UgSkVBTi1GUkFOQ09JUyI7fWk6MzthOjg6e3M6MToiWSI7czo0OiJETElDIjtzOjk6IkxpY2VuY2VJZCI7czo5OiI1MDAxMzE4NzYiO3M6NToiRWNySWQiO3M6NjoiNDg2NTUwIjtzOjc6IkVjckRhdGUiO3M6MTk6IjIwMjEtMDktMDkgMTM6MTA6MjQiO3M6MTQ6IkxpY2VuY2VNb250YW50IjtzOjY6IjM3Mi4wMCI7czo5OiJTdHJ1Y3R1cmUiO3M6MTg6IjA2MDYgLSBBU0EgQ09SU0lDQSI7czoxMDoiRWNyTGliZWxsZSI7czo3OToiRGlmZsOpcmVuY2UgMjAyMSA6IE5BVElPTkFMRSBDT05DVVJSRU5UIENPTkRVQ1RFVVIgQVVUTyAtIE0gUE9SQ1UgSkVBTi1GUkFOQ09JUyI7czo4OiJQZXJzb25uZSI7czoxOToiUE9SQ1UgSkVBTi1GUkFOQ09JUyI7fX0=',NULL,NULL,'a:64:{s:11:\"vads_amount\";s:5:\"38300\";s:14:\"vads_auth_mode\";s:4:\"FULL\";s:16:\"vads_auth_number\";s:6:\"424665\";s:16:\"vads_auth_result\";s:2:\"00\";s:18:\"vads_capture_delay\";s:1:\"0\";s:15:\"vads_card_brand\";s:2:\"CB\";s:16:\"vads_card_number\";s:16:\"513162XXXXXX6766\";s:24:\"vads_payment_certificate\";s:40:\"6368c54bfd7354d1c9af6b80b92db03d6b8ce9b5\";s:13:\"vads_ctx_mode\";s:10:\"PRODUCTION\";s:13:\"vads_currency\";s:3:\"978\";s:21:\"vads_effective_amount\";s:5:\"38300\";s:23:\"vads_effective_currency\";s:3:\"978\";s:12:\"vads_site_id\";s:8:\"21195833\";s:15:\"vads_trans_date\";s:14:\"20210909111126\";s:13:\"vads_trans_id\";s:6:\"134142\";s:15:\"vads_trans_uuid\";s:32:\"00c9eb7be6cd4f1fa455c3206af77851\";s:20:\"vads_validation_mode\";s:1:\"0\";s:12:\"vads_version\";s:2:\"V2\";s:20:\"vads_warranty_result\";s:3:\"YES\";s:16:\"vads_payment_src\";s:2:\"EC\";s:13:\"vads_order_id\";s:14:\"21042510122318\";s:15:\"vads_cust_email\";s:18:\"jeffy2a@hotmail.fr\";s:12:\"vads_cust_id\";s:6:\"192731\";s:16:\"vads_cust_status\";s:7:\"PRIVATE\";s:14:\"vads_cust_name\";s:19:\"JEAN-FRANCOIS PORCU\";s:20:\"vads_cust_first_name\";s:13:\"JEAN-FRANCOIS\";s:19:\"vads_cust_last_name\";s:5:\"PORCU\";s:20:\"vads_cust_legal_name\";s:0:\"\";s:8:\"vads_tid\";s:3:\"001\";s:20:\"vads_sequence_number\";s:1:\"1\";s:21:\"vads_acquirer_network\";s:2:\"CB\";s:18:\"vads_contract_used\";s:7:\"5945746\";s:17:\"vads_trans_status\";s:10:\"AUTHORISED\";s:17:\"vads_expiry_month\";s:1:\"1\";s:16:\"vads_expiry_year\";s:4:\"2024\";s:14:\"vads_bank_code\";s:5:\"12006\";s:15:\"vads_bank_label\";s:56:\"Caisse régionale de crédit agricole mutuel de la Corse\";s:17:\"vads_bank_product\";s:3:\"TCS\";s:12:\"vads_pays_ip\";s:2:\"FR\";s:22:\"vads_presentation_date\";s:14:\"20210909111138\";s:28:\"vads_effective_creation_date\";s:14:\"20210909111138\";s:20:\"vads_occurrence_type\";s:8:\"UNITAIRE\";s:19:\"vads_operation_type\";s:5:\"DEBIT\";s:11:\"vads_result\";s:2:\"00\";s:17:\"vads_extra_result\";s:0:\"\";s:17:\"vads_card_country\";s:2:\"FR\";s:13:\"vads_language\";s:2:\"fr\";s:21:\"vads_brand_management\";s:61:\"{\"userChoice\":false,\"brandList\":\"CB|MASTERCARD\",\"brand\":\"CB\"}\";s:9:\"vads_hash\";s:64:\"bc0729b45a737461e1c361144febe9f157ac7a07e4fb992b9dd1f24ca782b95b\";s:18:\"vads_url_check_src\";s:3:\"PAY\";s:16:\"vads_action_mode\";s:11:\"INTERACTIVE\";s:19:\"vads_payment_config\";s:6:\"SINGLE\";s:16:\"vads_page_action\";s:7:\"PAYMENT\";s:21:\"vads_threeds_enrolled\";s:1:\"Y\";s:22:\"vads_threeds_auth_type\";s:9:\"CHALLENGE\";s:16:\"vads_threeds_eci\";s:2:\"02\";s:16:\"vads_threeds_xid\";s:0:\"\";s:26:\"vads_threeds_cavvAlgorithm\";s:0:\"\";s:19:\"vads_threeds_status\";s:1:\"Y\";s:23:\"vads_threeds_sign_valid\";s:0:\"\";s:23:\"vads_threeds_error_code\";s:0:\"\";s:24:\"vads_threeds_exit_status\";s:2:\"10\";s:17:\"vads_threeds_cavv\";s:28:\"jGE67DDSdi/oAAVhOewf+hbHrFI=\";s:9:\"signature\";s:40:\"b0cff63ea202acd2849f406f4de1701361453f55\";}','a:25:{s:12:\"vads_site_id\";s:8:\"21195833\";s:13:\"vads_ctx_mode\";s:10:\"PRODUCTION\";s:12:\"vads_version\";s:2:\"V2\";s:13:\"vads_language\";s:2:\"fr\";s:9:\"signature\";s:0:\"\";s:15:\"vads_trans_date\";s:14:\"20210909111126\";s:13:\"vads_trans_id\";s:6:\"134142\";s:13:\"vads_currency\";s:3:\"978\";s:16:\"vads_page_action\";s:7:\"PAYMENT\";s:16:\"vads_action_mode\";s:11:\"INTERACTIVE\";s:19:\"vads_payment_config\";s:6:\"SINGLE\";s:16:\"vads_return_mode\";s:4:\"POST\";s:15:\"vads_url_return\";s:68:\"https://licence.ffsa.org/paiements/commandepagec/21042510122318.html\";s:16:\"vads_url_success\";s:68:\"https://licence.ffsa.org/paiements/commandepagec/21042510122318.html\";s:15:\"vads_url_cancel\";s:53:\"https://licence.ffsa.org/paiements/commandepageb.html\";s:14:\"vads_url_error\";s:53:\"https://licence.ffsa.org/paiements/commandepageb.html\";s:16:\"vads_url_refused\";s:53:\"https://licence.ffsa.org/paiements/commandepageb.html\";s:15:\"vads_cust_email\";s:18:\"jeffy2a@hotmail.fr\";s:20:\"vads_cust_first_name\";s:13:\"JEAN-FRANCOIS\";s:12:\"vads_cust_id\";s:6:\"192731\";s:19:\"vads_cust_last_name\";s:5:\"PORCU\";s:20:\"vads_cust_legal_name\";N;s:16:\"vads_cust_status\";s:7:\"PRIVATE\";s:11:\"vads_amount\";d:38300;s:13:\"vads_order_id\";s:14:\"21042510122318\";}','2','21042510122318',NULL,NULL,486552,NULL,NULL,'0','2021-09-09 13:12:33',0.00,NULL,NULL,NULL,NULL,'N',NULL);
The table "Personnes" contain 361740 rows.
INSERT INTO `Personnes` VALUES (541732,'2003-02-27 00:00:00','2015-08-29 13:51:52','P',10005,'M','DURANEL','OLIVIER','M','1970-07-29',NULL,'FR','250',NULL,NULL,NULL,NULL,0,0,'DURANEL',NULL,'N','JN','A',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'O',NULL,NULL,NULL,NULL,NULL,'10012','NR',NULL,'O','N',NULL,NULL,NULL,'N','N','O','O');
INSERT INTO `Personnes` VALUES (541742,'2003-02-27 00:00:00','2015-08-29 13:51:52','P',10005,'M','BES','CYRIL','M','1973-11-04',NULL,'FR','250',NULL,NULL,NULL,NULL,0,0,'BES',NULL,'N','JN','A',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'O',NULL,NULL,NULL,NULL,NULL,'1','NR',NULL,'O','N',NULL,NULL,NULL,'N','N','O','O');
541756,'2003-02-27 00:00:00','2016-12-09 12:52:05','P',10005,'M','GARIN','PIERRE','M','1984-11-12','','FR','250',NULL,NULL,NULL,NULL,0,0,'GARIN',NULL,'N','JN','A',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'O',NULL,NULL,NULL,NULL,NULL,'10015','NR',NULL,'O','N',NULL,NULL,NULL,'N','N','O','O'
INSERT INTO `Personnes` VALUES (541774,'2003-02-27 00:00:00','2024-03-20 08:31:43','P',10005,'M','GUILLERIN','NICOLAS','M','1979-06-10',NULL,'FR','250','','','',NULL,0,0,'GUILLERIN',NULL,'N','JN','A',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'O','2024-03-20 08:29:39',NULL,NULL,NULL,NULL,'0',NULL,'','O','O','2019-01-02 13:03:01',NULL,'2019-02-12 13:03:58','N','N','O','O');
The table "UfolepDiplomes" contain 2084 rows.
INSERT INTO `UfolepDiplomes` VALUES (1211,'1','VALLERAY','Fabrice','TIVOLI POST COLON','97200','FORT DE France','UFOLEP',53764653,'2014/07/1184',1,'2014-05-11',58,NULL,'valleray fabrice .jpg',NULL,'','','','FAUX','1',NULL,NULL,500060521);
INSERT INTO `UfolepDiplomes` VALUES (1212,'2','CALVEYRAC','Claudine','Qrt Grotin Rue Appolinaire vilant','97213','ROS MORNE','UFOLEP',53764653,'2014/07/1185',4,'2014-05-11',58,NULL,'calveyrac claudine .jpg',NULL,'','','','FAUX','1',NULL,NULL,500060522);
INSERT INTO `UfolepDiplomes` VALUES (1213,'1','LAGUERRE','Philippe','10 Rue Constantin sylvestre','97200','FORT DE France','UFOLEP',53764653,'2014/07/1186',4,'2014-05-11',58,NULL,'laguerre philippe .jpg',NULL,'','','','FAUX','1',NULL,NULL,500060523);
INSERT INTO `UfolepDiplomes` VALUES (1214,'2','BARRAL','Françoise','315 Quartier Peyroulaud','26400','MIRABEL ET BLACONS','UFOLEP',53764653,'2015/06/1187',1,'2015-02-28',59,'2022-12-31','BARAL Françoise.JPG',NULL,'','','','VRAI','1',54,'2020-01-11',500060524);
INSERT INTO `UfolepDiplomes` VALUES (1215,'2','DAVAL','Lucie','365 chemin de la Combe','38260','ARZAY','UFOLEP',53764653,'2015/06/1188',1,'2015-02-28',59,'2017-12-31','DAVAL Lucie.JPG',NULL,'','','','VRAI','1',NULL,NULL,500060525);
INSERT INTO `UfolepDiplomes` VALUES (1216,'1','DUCREUX','Anthony','Le Laffray','69770','VILLECHENEVE','UFOLEP',53764653,'2015/06/1189',1,'2015-02-28',59,'2021-12-31','DUCREUX Anthony.JPG',NULL,'','','','VRAI','1',63,'2021-05-05',500060526);
INSERT INTO `UfolepDiplomes` VALUES (1217,'1','DUCREUX','Sébastien','Le Laffray','69770','VILLECHENEVE','UFOLEP',53764653,'2015/06/1190',1,'2015-02-28',59,'2021-12-31','DUCREUX Sébastien.JPG',NULL,'','','','VRAI','1',63,'2021-05-05',500060527);
INSERT INTO `UfolepDiplomes` VALUES (1218,'2','GELIN','Fatima','282 route des Champs','01400','MOGNENEINS','UFOLEP',53764653,'2015/06/1191',1,'2015-02-25',59,'2017-12-31','GELIN Fatima.JPG',NULL,'','','','VRAI','1',NULL,NULL,500060528);
INSERT INTO `UfolepDiplomes` VALUES (1219,'2','GELIN','Isabelle','655 route D\' arS','01600','SAINTE EUPHEMIE','UFOLEP',53764653,'2015/06/1192',1,'2015-02-28',59,'2021-12-31','GELIN Isabelle.JPG',NULL,'','','','VRAI','1',63,'2021-05-05',500060529);
The table "users" contain 11460 rows.
INSERT INTO `users` VALUES (11453,'GUILLE NELLY','41642',1164301,'nelly.guille@gmail.com',NULL,'$2y$10$9.LaTc3ApxXzPkTulZtYDeuzXMfX7fEFUOw5YBHlgZNu9CZb0RU5W',NULL,'2024-12-15 10:21:16','2024-12-15 10:21:16');
INSERT INTO `users` VALUES (11454,'BOUVIER PHILIPPE','PBOUVIER',1365161,'philippe-bouvier@laposte.net',NULL,'$2y$10$KT1OP9kAUAp7o.OT0tcGIu8oWd15B4powM3Xg9wsKE1mudfDDMiN6',NULL,'2024-12-15 10:50:49','2024-12-15 10:50:49');
INSERT INTO `users` VALUES (11455,'JOSEPH TEDDY','315006',500018304,'chris91.joseph@gmail.com',NULL,'$2y$10$YHDH8YNlCORbxNSQD/IrEuV1pTihaQuzMGceGt48W/B1SssxqK1Ze',NULL,'2024-12-15 11:47:52','2024-12-15 11:47:52');
INSERT INTO `users` VALUES (11456,'LAFFITTE LOIC','210100',917585,'tayga33@live.fr',NULL,'$2y$10$6PpvTB08KjNJG4Pm8Dkz.evG.Xw6ImMGwNcTzzdg.d/FkYLwVXHZ.',NULL,'2024-12-15 13:00:55','2024-12-15 13:02:55');
INSERT INTO `users` VALUES (11457,'GUINE YAEL','366954',500070252,'guine.yael@gmail.com',NULL,'$2y$10$e9bcerpMXSDfMvJDQk5A4OM7cz.1LEknsuYadBfcrzhIWdNfKUl3q',NULL,'2024-12-15 13:57:12','2024-12-15 13:57:12');
INSERT INTO `users` VALUES (11458,'LEJEUNE LOUIS','143156',20540306,'louislejeune@orange.fr',NULL,'$2y$10$YVlz0wNlKFFCwkaNwn9DEemv1TWIQ.0dF84EMG8LZFZpcQAKvgBD2',NULL,'2024-12-15 14:45:33','2024-12-15 14:45:33');
INSERT INTO `users` VALUES (11459,'JOLY KYLIAN','100492',378890,'kylian-joly@orange.fr',NULL,'$2y$10$q6RbfzbsQ4zo7rUpvfWUK.bh0v8ruk3Y3eQtOrAVBtmjx1YcUno7i',NULL,'2024-12-15 15:46:24','2024-12-15 15:46:24');
INSERT INTO `users` VALUES (11460,'GAST NATHAN','358256',500061554,'g.gast@express-sundgoviens.fr',NULL,'$2y$10$OJLadW4DafODkXQRe9oaNefZc.vcNxv7gO.PkEEFjrUOge29Zwjke',NULL,'2024-12-15 16:38:50','2024-12-15 16:38:50');
INSERT INTO `users` VALUES (11461,'MOULIN JEAN MICHEL','368165',500071463,'moulin.jeanmichel@free.fr',NULL,'$2y$10$SjkrDfWiPViQK.6hFtqqduhtFzHpDvr17HziXdgaB0Re9gOk7iDji',NULL,'2024-12-15 17:04:37','2024-12-15 17:04:37');
INSERT INTO `users` VALUES (11462,'CROS BENJAMIN','314466',500017763,'benjamincros@orange.fr',NULL,'$2y$10$5RTCKH4M3oLY1LHQtkHQfOtC0KwCVS93DUKHandl3Y3PTlCcDzI4u',NULL,'2024-12-15 17:51:21','2024-12-15 17:51:21');