08-01-2025, 12:20 PM
Hello, Today i'm selling the database (full sql dump not scrap) of the Fédération Sportive et Culturelle de France.
Offer a price in PM.
Only MM
Sample :
The table "adherent" contain 16842 rows.
INSERT INTO `adherent` VALUES (1,0,6,'2014-06-14 00:00:00','2014-06-15 00:00:00',0,'ARGUES','DOMINIQUE','F','2 IMPASSE JL GAUFFRE',24100,'BERGERAC','1949-01-04','')
(83,0,10,'2014-07-07 00:00:00','2014-07-11 00:00:00',0,'OLIVAIN','AMELIE','F','204 Rue des soldanelles',74800,'LA ROCHE SUR FORON','2003-08-03',''),(84,0,10,'2014-07-08 00:00:00','2014-07-11 00:00:00',0,'CHOMAT','CAPUCINE','F','33 Rue de la pierre d\'angeroux',74800,'LA ROCHE SUR FORON','2003-06-03',''),(85,0,10,'2014-07-08 00:00:00','2014-07-11 00:00:00',0,'ROSELIER','LEA','F','180 Route de la gare ',74800,'ST LAURENT','2001-10-01',''),(87,0,16,'2014-10-11 00:00:00','2014-10-11 00:00:00',0,'LEBASTARD ','Angélica','F','9 La Barre',44390,'SAFFRÉ','1979-09-14','angelica.lebastard@hotmail.fr'),(133,0,18,'2014-10-25 00:00:00','2014-11-01 00:00:00',0,'BAR','Mathilde','F','1420, route de Garlin',64160,'SEVIGNACQ','1997-04-19','nathalie.desclaux@club-internet.fr'),(89,0,16,'2014-10-11 00:00:00','2014-10-11 00:00:00',0,'CHARRIER ','Marie-Gabrielle','F','16 rue de l\'Epine',85130,'LA VERRIE','1948-01-19','gabycharrier@orange.fr'),(90,0,16,'2014-10-11 00:00:00','2014-10-11 00:00:00',0,'SACHOT ','Chantal','F','3 rue des roches',85130,'LA GAUBRETIERE','1965-12-14','chantalsachot@orange.fr'),(91,0,16,'2014-10-11 00:00:00','2014-10-11 00:00:00',0,'MORILLE ','Marie-Colette','F','20 la sauzaie',49600,'GESTÉ','1958-09-20','morillejp@orange.fr'),(92,0,16,'2014-10-11 00:00:00','2014-10-11 00:00:00',0,'ANIS ','Anne-Marie','F','11 bis rue Elie de Mieulle',49640,'CHEMIRÉ SUR SARTHE','1959-11-11','anne-marie.anis@orange.fr'),(93,0,16,'2014-10-11 00:00:00','2014-10-11 00:00:00',0,'GUERIN ','Marie-Cécile','F','19 rue des cloudis',85740,'L\'ÉPINE','1944-05-23','mariececileguerin@yahoo.fr'),(94,0,16,'2014-10-11 00:00:00','2014-10-11 00:00:00',0,'FAVROU ','Brigitte','F','29, impasse Abbé Grégoire',85000,'LA ROCHE SUR YON','1958-03-17','brigitte.barritaud@sfr.fr'),(95,0,16,'2014-10-11 00:00:00','2014-10-11 00:00:00',0,'JAUD ','Séverine','F','Les Terrasses',85000,'LA ROCHE SUR YON','1973-12-22','severine.jaud@free.fr'),(96,0,16,'2014-10-11 00:00:00','2014-10-11 00:00:00',0,'LALY ','Marie-José','F','11 impasse raphael',44200,'NANTES','1952-07-07',''),(97,0,16,'2014-10-11 00:00:00','2014-10-11 00:00:00',0,'PONTOIRE ','Sylvianne','F','1 allée des belettes',49450,'ST MACAIRE','1975-09-14','stephasyl@aol.com'),(98,0,16,'2014-10-11 00:00:00','2014-10-11 00:00:00',0,'GILBERT ','Carole','F','35 le val du petit lay',85500,'ST PAUL EN PAREDS','1969-07-21','benoitpasquier@wanadoo.fr'),(99,0,16,'2014-10-11 00:00:00','2014-10-11 00:00:00',0,'CHAUVET ','Françoise','F','18 ter rue Branly',44620,'LA MONTAGNE','1965-12-09','christophe.chauvet120@orange.fr'),(132,0,18,'2014-10-25 00:00:00','2014-11-01 00:00:00',0,'FERNANDES DE ALMEIDA','Maylis','F','15, rue Ignace Franois Bibal',64500,'SAINT JEAN DE LUZ','1996-06-04','mayllis64@hotmail.fr'),(131,0,18,'2014-10-25 00:00:00','2014-11-01 00:00:00',0,'CESSAC','Marianne','F','7, avenue de Barges',64000,'PAU','1996-02-18','marianne.cessac@orange.fr'),(130,0,18,'2014-10-25 00:00:00','2014-11-01 00:00:00',0,'URRUTIA','Estitxu','F','42, rue MUNHOA',64122,'URRUGNE','1997-09-12','cathyurrutia@orange.fr'),(129,0,18,'2014-10-25 00:00:00','2014-11-01 00:00:00',0,'DUHALDE','Lorea','F','Maison Lur Xuri Bidean',64250,'LOUHOSSOA','1997-10-07','lorea-mail@orange.fr')
The table "adresses" contain 1484629 rows.
NSERT INTO `adresses` VALUES (1,'2021-06-23 01:34:21','2023-07-12 09:01:57',NULL,1,'ST','22','RUE','OBERKAMPF',NULL,NULL,NULL,'75011',NULL,'PARIS','75056','11','75','FR','adagio@fscf.asso.fr',NULL,'0143385057',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'https://www.fscf.asso.fr/',NULL,NULL,NULL,'{\"twitter\": \"https://twitter.com/laFSCF\", \"facebook\": \"https://www.facebook.com/laFSCF\"}',NULL)
(36,'2021-06-23 06:00:00','2021-11-25 15:34:42',NULL,561818,'ST',NULL,NULL,'113 bd Emile Zola',NULL,NULL,NULL,'54520',NULL,'Laxou','54304','44','54','FR',NULL,NULL,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'2021-06-23 06:00:00','2021-11-25 15:34:42',NULL,561819,'ST',NULL,NULL,'65 rue Bellecombe',NULL,NULL,NULL,'69006',NULL,'Lyon','69123','84','69','FR','fscf.lyonnais@9online.fr',NULL,'0472740921',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'2021-06-23 06:00:00','2021-06-23 06:00:00',NULL,561820,'ST',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','00000',NULL,NULL,'FR',NULL,NULL,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'2021-06-23 06:00:00','2021-06-23 06:00:00',NULL,561821,'ST',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','00000',NULL,NULL,'FR',NULL,NULL,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'2021-06-23 06:00:00','2021-11-25 15:34:42',NULL,561822,'ST',NULL,NULL,'Maison des Sports','1240 rue de Bergeresse',NULL,NULL,'45160',NULL,'Olivet','45232','24','45','FR',NULL,NULL,'0238692429',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'2021-06-23 06:00:00','2021-11-25 15:34:42',NULL,561823,'ST',NULL,NULL,'Maison des Sports','44 rue R. Rolland BP 90312',NULL,NULL,'44103',NULL,'44103','00000',NULL,NULL,'FR','fscf.paysdelaloire@wanadoo.fr',NULL,'0240586162',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,'2021-06-23 06:00:00','2021-06-23 06:00:00',NULL,561824,'ST',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','00000',NULL,NULL,'FR',NULL,NULL,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'2021-06-23 06:00:00','2021-11-25 15:34:42',NULL,561825,'ST',NULL,NULL,'277 Chemin du Vallon de l\'Oriol',NULL,NULL,NULL,'13007',NULL,'Marseille','13055','93','13','FR','fscf.liguepaca@cegetel.net',NULL,'0491523281',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'2021-06-23 06:00:00','2021-11-25 15:34:42',NULL,561826,'ST',NULL,NULL,'84 rue de Flandre','BP 40',NULL,NULL,'60190',NULL,'Blincourt','60078','32','60','FR','cdoise.fscf@wanadoo.fr',NULL,'0344419663',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,'2021-06-23 06:00:00','2021-11-25 15:34:42',NULL,561827,'ST',NULL,NULL,'3 Place de la Mairie','La Bourgeoisie',NULL,NULL,'86240',NULL,'Iteuil','86113','75','86','FR','fscfpoitouchar@aliceadsl.fr',NULL,'0549381169',NULL,NULL,'0609213389',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
The table "preinsc_personnes_imports_personnes" contain 33011 rows.
NSERT INTO `preinsc_personnes_imports_personnes` VALUES (1,'2022-01-21 13:51:18','2022-01-21 13:52:50',7,1254914,1,'{\"nom\": \"ADRIANO CATALDO\", \"photo\": null, \"prenom\": \"Thais\", \"civilite\": \"M\", \"adresse-tel\": null, \"nationalite\": null, \"adresse-mail\": \"jeremy.adriano1504@gmail.com\", \"adresse-pays\": null, \"code-adherent\": null, \"nom-naissance\": null, \"adresse-mobile\": null, \"lieu-naissance\": null, \"adresse-commune\": null, \"adresse-batiment\": null, \"adresse-escalier\": null, \"adresse-lieu-dit\": null, \"adresse-nom-voie\": null, \"adresse-num-voie\": null, \"adresse-type-voie\": null, \"commune-naissance\": null, \"date-de-naissance\": \"15/04/2010\", \"pays-de-naissance\": null, \"adresse-code-insee\": null, \"adresse-code-postal\": null, \"autorisation-legale\": false, \"departement-naissance\": null, \"autorisation-offre-com\": false, \"conditions-utilisation\": false, \"representant-legal-nom\": null, \"autorisation-newsletter\": false, \"representant-legal-mail\": null, \"representant-legal-prenom\": null, \"representant-legal-civilite\": \"M\", \"representant-legal-telephone\": null, \"autorisation-offre-com-autres\": false}','{\"nom\": \"ADRIANO CATALDO\", \"photo\": null, \"prenom\": \"Thais\", \"civilite\": \"Mme(Madame)\", \"adresse-tel\": null, \"nationalite\": null, \"adresse-mail\": \"jeremy.adriano1504@gmail.com\", \"adresse-pays\": null, \"code-adherent\": null, \"nom-naissance\": null, \"adresse-mobile\": null, \"lieu-naissance\": null, \"adresse-commune\": null, \"adresse-batiment\": null, \"adresse-escalier\": null, \"adresse-lieu-dit\": null, \"adresse-nom-voie\": null, \"adresse-num-voie\": null, \"adresse-type-voie\": null, \"commune-naissance\": null, \"date-de-naissance\": \"15/04/2010\", \"pays-de-naissance\": null, \"adresse-code-insee\": null, \"adresse-code-postal\": null, \"autorisation-legale\": null, \"departement-naissance\": null, \"autorisation-offre-com\": null, \"conditions-utilisation\": null, \"representant-legal-nom\": null, \"autorisation-newsletter\": null, \"representant-legal-mail\": null, \"representant-legal-prenom\": null, \"representant-legal-civilite\": null, \"representant-legal-telephone\": null, \"autorisation-offre-com-autres\": null}','[]','{\"adresse-mail\": \"jeremy.adriano1504@gmail.com\", \"autorisation-legale\": 0, \"autorisation-offre-com\": false, \"conditions-utilisation\": 0, \"autorisation-newsletter\": false, \"autorisation-offre-com-autres\": 0}','26ea8d1b05d44ccb3551e98c02282273'),
(5,'2022-01-21 13:51:18','2022-01-21 13:57:47',7,1300065,1,'{\"nom\": \"FACQUEUR\", \"photo\": null, \"prenom\": \"JORDAN\", \"civilite\": \"M\", \"adresse-tel\": null, \"nationalite\": null, \"adresse-mail\": \"oxana_rdn@yahoo.com\", \"adresse-pays\": null, \"code-adherent\": null, \"nom-naissance\": null, \"adresse-mobile\": null, \"lieu-naissance\": null, \"adresse-commune\": null, \"adresse-batiment\": null, \"adresse-escalier\": null, \"adresse-lieu-dit\": null, \"adresse-nom-voie\": null, \"adresse-num-voie\": null, \"adresse-type-voie\": null, \"commune-naissance\": null, \"date-de-naissance\": \"16/06/2008\", \"pays-de-naissance\": null, \"adresse-code-insee\": null, \"adresse-code-postal\": null, \"autorisation-legale\": false, \"departement-naissance\": null, \"autorisation-offre-com\": false, \"conditions-utilisation\": false, \"representant-legal-nom\": null, \"autorisation-newsletter\": false, \"representant-legal-mail\": null, \"representant-legal-prenom\": null, \"representant-legal-civilite\": \"M\", \"representant-legal-telephone\": null, \"autorisation-offre-com-autres\": false}','{\"nom\": \"FACQUEUR\", \"photo\": null, \"prenom\": \"JORDAN\", \"civilite\": \"M (Monsieur)\", \"adresse-tel\": null, \"nationalite\": null, \"adresse-mail\": \"oxana_rdn@yahoo.com\", \"adresse-pays\": null, \"code-adherent\": null, \"nom-naissance\": null, \"adresse-mobile\": null, \"lieu-naissance\": null, \"adresse-commune\": null, \"adresse-batiment\": null, \"adresse-escalier\": null, \"adresse-lieu-dit\": null, \"adresse-nom-voie\": null, \"adresse-num-voie\": null, \"adresse-type-voie\": null, \"commune-naissance\": null, \"date-de-naissance\": \"16/06/2008\", \"pays-de-naissance\": null, \"adresse-code-insee\": null, \"adresse-code-postal\": null, \"autorisation-legale\": null, \"departement-naissance\": null, \"autorisation-offre-com\": null, \"conditions-utilisation\": null, \"representant-legal-nom\": null, \"autorisation-newsletter\": null, \"representant-legal-mail\": null, \"representant-legal-prenom\": null, \"representant-legal-civilite\": null, \"representant-legal-telephone\": null, \"autorisation-offre-com-autres\": null}','[]','{\"autorisation-legale\": 0, \"autorisation-offre-com\": false, \"conditions-utilisation\": 0, \"autorisation-newsletter\": false, \"autorisation-offre-com-autres\": 0}','35fd1342a0db6c5ee976ace21a360099')
The table "personnes_representants_legaux" contain 300702 rows.
INSERT INTO `personnes_representants_legaux` VALUES (1,79620,'LEBRETON','CHRISTINE','0642490996','bruno.beaudouin0461@orange.fr',NULL,'PRI'),(2,1294047,'Petit','Delphine','06 61 89 69 15','petit.d2507@gmail.com',NULL,'PRI'),(3,148015,'MILLIER','LUDOVIC','0612464283','millier.ludovic@free.fr',NULL,'PRI'),,
(69,1294231,'LEGRAND','Audrey','0615526641','audreylegrand@laposte.net','Mme','PRI'),(70,613186,'ADAM','SANDRINE','06 88 00 08 22','adamhutt@orange.fr',NULL,'PRI'),(71,1294236,'YAPI','OLGA','0664059968','olga_kaela@hotmail.fr',NULL,'PRI'),(72,1294242,'ANDRE','VIRGINIE','0749696350','cvirginie.lea87@gmail.com',NULL,'PRI'),(73,1294248,'petre','marina','0687077547','marinazambelli@gmail.com',NULL,'PRI'),(74,1294249,'PELISSIER','PHILIPPE','0620301085','pelissierphilippe@hotmail.fr',NULL,'PRI'),(75,1294253,'benjelloun','anonyme','0637222821','benjellounzouhair@yahoo.fr',NULL,'PRI'),(76,614453,'le MOAL','Pascale','0661754888','pascale.billard-le-moal@wanadoo.fr',NULL,'PRI'),(77,1294255,'D\'ONOFRIO','laurent','06 25 54 37 43','stefroyon@yahoo.fr',NULL,'PRI'),(78,619318,'GARCIA','Ana','0385914609','ana.garcia@orange.fr',NULL,'PRI'),(79,1294302,'KWAN KOC HONG','SOLENE','0611097154','keyshikkh@msn.com',NULL,'PRI'),(80,624458,'danion','louise','06 87 66 29 25','familledanion@orange.fr',NULL,'PRI'),(81,1294322,'CHELET','MICKAEL','0642215402','carla.paz.api@gmail.com',NULL,'PRI'),(82,625534,'DECOLOGNE','Delphine','0636064301','gymaplicences@gmail.com',NULL,'PRI'),(83,1294331,'CAVIL','FRANK','0665226989','loicia.lancelot@sfr.fr',NULL,'PRI'),(85,1294353,'LOUESDON','LAETITIA','067191275','laetitia.louesdon@hotmail.fr',NULL,'PRI'),(86,630610,'Francois','MAgali','0607343466','magali.francois59@gmail.com',NULL,'PRI'),(87,1294362,'Larquier','Bruno','0777994400','bruno.larquier-laplace@orange.fr',NULL,'PRI'),(89,1294385,'LEMOINE','AURORE','0687528848','auroma56@hotmail.fr',NULL,'PRI'),(93,632174,'CHAUX','Catherine','06 41 14 60 16','catherinechaux@orange.fr',NULL,'PRI'),(94,632178,'MILESI','Gérald','06 84 78 02 56','geraldcecile@sfr.fr',NULL,'PRI'),(95,1294389,'LIZE','CHARLOTTE','0662544228','charlotte.lize56690@gmail.com',NULL,'PRI'),(97,1294406,'FOURDRAIN','NICOLAS','0682433649','sabrinadesiage74@gmail.com',NULL,'PRI'),(98,1294408,'JOUVE','ISABELLE','06 77 84 00 39','isabelle.jouve42@free.fr',NULL,'PRI'),(99,632601,'Veillard','Patricia','fannyveillard@gmail.com','0600000001',NULL,'PRI'),(101,1294441,'DEVROUX','Jean','06 40 73 89 01','chrisetambre@aol.com',NULL,'PRI')
The table "personne" contain 1334442 rows.
INSERT INTO `personne` VALUES (1,'Physique','LicenciéMigré','','','','AVIGAD','ELINOR','1999-08-16','F','','','','Rue eydoux','',13006,'MARSEILLE',NULL,'','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2006-05-21 00:00:00','',0,1,0,'','','','',''),(2,'Physique','LicenciéMigré','0','','','ODLAN','AZIADE','1999-01-08','F','','','','6 Rue Eydoux','',13006,'MARSEILLE',NULL,'FRANCE','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2006-02-24 00:00:00','',0,1,0,'','','','',''),(3,'Physique','LicenciéMigré','0000009689','','','DENIS','AURORE','1986-12-22','F','','','','2/73 RUE GERNES RIEUX','',59113,'SECLIN','59560','FRANCE','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2005-01-25 00:00:00','',0,1,0,'','','','',''),
(27,'Physique','LicenciéMigré','0000500582','','','MOUGNERES','CAROLE','1966-02-13','F','','','','14 RUE AOUQUE','',40180,'OEYRELUY','40207','','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2006-02-06 00:00:00','',0,1,0,'','','','',''),(28,'Physique','LicenciéMigré','0000500583','','','POTTIER','LEO','1998-11-20','M','','','','ALLEE DE STALINES','',40140,'SOUSTONS','40310','','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2006-11-27 14:51:40','',0,1,0,'','','','',''),(29,'Physique','LicenciéMigré','0000500584','','','PHILIPART','ESTER','1999-05-06','F','','','2','ALLEE DE PASSECAN','',40140,'SOUSTONS','40310','','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2006-12-18 15:56:39','',0,1,0,'','','','',''),(30,'Physique','LicenciéMigré','0000500585','','','MONSARRAT','GILLES','1985-10-16','M','','','','43 BD HIPPOLYTE SINTAS','',40100,'DAX','40088','','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2006-02-06 00:00:00','',0,1,0,'','','','',''),(31,'Physique','LicenciéMigré','0000500586','','','PAQUERO','PAUL','1984-08-05','M','','','','26 RUE JEAN LE BON','',40100,'DAX','40088','','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2006-02-06 00:00:00','',0,1,0,'','','','',''),(32,'Physique','LicenciéMigré','0000500587','','','QUESNOT','ANAIS','1984-09-02','F','','','','12 RUE PASCAL DUPRAT','',40990,'SAINT PAUL LES DAX',NULL,'','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2006-02-06 00:00:00','',0,1,0,'','','','',''),(33,'Physique','LicenciéMigré','0000500588','','','BRAYER','EMILIE','1981-01-12','F','','','','31 AVENUE VICTOR HUGO','',40100,'DAX','40088','','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2006-02-06 00:00:00','',0,1,0,'','','','',''),(34,'Physique','LicenciéMigré','0000500589','','','CORSEZ','CELINE','1976-04-14','F','','','','27 RUE PIERRE BENOIT','',40100,'DAX','40088','','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2006-02-06 00:00:00','',0,1,0,'','','','',''),(35,'Physique','LicenciéMigré','0000500590','','','PANTEIX','STEPHANIE','1976-01-18','F','','','','36 ROUTE D\'ASPREMONT','',40100,'DAX','40088','','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2006-02-06 00:00:00','',0,1,0,'','','','',''),(36,'Physique','LicenciéMigré','0000500591','','','BOUTEILLE','VICTOR','2002-03-13','M','','','','168 AVENUE GEORGES CLEMENCEAU','',40100,'DAX','40088','','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2006-02-06 00:00:00','',0,1,0,'','','','',''),(37,'Physique','LicenciéMigré','0000500592','','','CALU','AINHOA','2002-01-29','F','','','','22 RUE DES FAUVETTES','',40100,'DAX','40088','','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2006-02-06 00:00:00','',0,1,0,'','','','',''),(38,'Physique','LicenciéMigré','0000500593','','M','CAZAUX','THOMAS','2001-01-05','M','','','5','RUE CHARLES DESPIAU','',40100,'DAX','40088','FRANCE','','','','','thomas.cazaux40@gmail.com','','','','','0000-00-00','0000-00-00',0,0,0,'','2018-10-03 18:24:52','',0,2,0,'','','','','')
The table "commandes_lignes" contain 1741273 rows.
INSERT INTO `commandes_lignes` VALUES (1371663,'2024-09-18 11:04:28','2024-09-18 11:04:28',385710,'LIC','Prise de licence CA - Sports Collectifs 2025 - Mme SERBOURDIN Axelle',97,NULL,13.50,'ELicence\\Core\\Models\\Licence',3612715,1419996,0,NULL,'LIC','{\"mouvement_code\":\"LIC\",\"licence_id\":3612715,\"personne_id\":1435659,\"compta_id\":1283,\"structure_id\":563090,\"libelle\":\"Prise de licence CA - Sports Collectifs 2025 - Mme SERBOURDIN Axelle\",\"devise\":\"EUR\",\"saison\":2025,\"debit\":13.5}',NULL),(1371664,'2024-09-18 11:04:28','2024-09-18 11:04:28',385710,NULL,'Cotisation Régionale CA - Sports Collectifs 2025 - Mme SERBOURDIN Axelle',97,NULL,1.50,'ELicence\\Core\\Models\\Licence',3612715,1419997,0,NULL,'CTLLIG','{\"mouvement_code\":\"CTLLIG\",\"licence_id\":3612715,\"personne_id\":1435659,\"compta_id\":1283,\"structure_id\":563090,\"libelle\":\"Cotisation R\\u00e9gionale CA - Sports Collectifs 2025 - Mme SERBOURDIN Axelle\",\"devise\":\"EUR\",\"saison\":2025,\"debit\":1.5,\"mutation_id\":null}',NULL),(1371665,'2024-09-18 11:04:28','2024-09-18 11:04:28',385710,NULL,'Cotisation Départementale CA - Sports Collectifs 2025 - Mme SERBOURDIN Axelle',97,NULL,20.50,'ELicence\\Core\\Models\\Licence',3612715,1419998,0,NULL,'CTLDEP','{\"mouvement_code\":\"CTLDEP\",\"licence_id\":3612715,\"personne_id\":1435659,\"compta_id\":1283,\"structure_id\":563090,\"libelle\":\"Cotisation D\\u00e9partementale CA - Sports Collectifs 2025 - Mme SERBOURDIN Axelle\",\"devise\":\"EUR\",\"saison\":2025,\"debit\":20.5,\"mutation_id\":null}',NULL),(1371666,'2024-09-18 11:04:59','2024-09-18 11:04:59',385711,'LIC','Prise de licence CL - Activités en loisir 2025 - Mme ANCEL Aude-Armandine',100,NULL,10.00,'ELicence\\Core\\Models\\Licence',3612716,1419999,0,NULL,'LIC','{\"mouvement_code\":\"LIC\",\"licence_id\":36127
The table "felixlicencie" contain 45684 rows.
INSERT INTO `felixlicencie` VALUES (45424,'0459303135','GABORET','ELISABETH','21/02/1981','0450004','2','2','09/10/1993','1','LE CLOU','','45500','ST GONDON','25/11/1993','','1','0','0','25/11/1993','','25/11/1993','1994','\r\n'),
(45446,'0899300021','FUENTES','JESSICA','29/06/1979','0890003','2','2','','1','','','','','21/09/1993','','2','','','21/09/1993','279512','','\r\n',''),(45447,'0899300022','ARNOUD','LYDIE','16/07/1979','0890003','2','2','','1','','','','','21/09/1993','','2','','','21/09/1993','279513','','\r\n',''),(45448,'0899300023','FONTAINE','CAROLINE','19/04/1981','0890003','2','2','','1','5 IMPASSE PAUL FORT','','16800','SOYAUX','21/09/1993','','2','','','21/09/1993','279514','','\r\n',''),(45449,'0899300024','FONTAINE','CECILE','19/03/1983','0890003','2','2','','1','','','','','21/09/1993','','2','','','21/09/1993','279515','','\r\n',''),(45450,'0899300025','MAGNE','JOSIANE','26/12/1940','0890003','3','2','','1','1 ALLEE ROUAULT','','89200','AVALLON','21/09/1993','','2','','','21/09/1993','279516','','\r\n',''),(45451,'0899300026','ARNOUD','PASCALE','03/08/1957','0890003','3','2','','1','','','','','21/09/1993','','2','','','21/09/1993','279517','','\r\n',''),(45452,'0899300027','SAGET','ISABELLE','16/04/1975','0890010','2','2','08/10/1993','1','les Michaults','','89240','POURRAIN','01/12/1993','','1','','','21/09/1993','279518','01/12/1993','1994',''),(45453,'0899300028','BALTAZART','SYLVIE','21/04/1969','0890010','2','2','08/10/1993','1','Les Bonnaults','','89240','POURRAIN','13/01/1994','','1','','','21/09/1993','279519','13/01/1994','1994',''),(45454,'0899300029','FAUSSOT','SEVERINE','25/10/1973','0890013','2','2','','1','Chemin des Cordeliers','','89700','TONNERRE','21/09/1993','','2','','','21/09/1993','279525','','\r\n',''),(45455,'0899300030','MATTIUSSI','KAREN','17/04/1978','0890013','2','2','','1','21 RUE CAMILLE DORMOIS','','89700','TONNERRE','21/09/1993','','2','','','21/09/1993','279529\r\n','','',''),(45456,'0899300031','DIDIER','ANGELIQUE','10/07/1982','0890013','2','2','','1','Rue de Louvois','','89700','TONNERRE','21/09/1993','','2','','','21/09/1993','279536\r\n','','',''),(45457,'0899300032','OTTONDO','DEBORAH','01/09/1982','0890013','2','2','','1','2 RUE DE VOULAVINEE','','89700','VEZINNES','21/09/1993','','2','','','21/09/1993','279538\r\n','','',''),(45458,'0899300033','DEQUEKER','CHARLOTTE','01/11/1982','0890013','2','2','','1','4, rue Georges Henri Carre','','89700','TONNERRE','21/09/1993','','2','','','21/09/1993','279539\r\n','','','')
Offer a price in PM.
Only MM
Sample :
The table "adherent" contain 16842 rows.
INSERT INTO `adherent` VALUES (1,0,6,'2014-06-14 00:00:00','2014-06-15 00:00:00',0,'ARGUES','DOMINIQUE','F','2 IMPASSE JL GAUFFRE',24100,'BERGERAC','1949-01-04','')
(83,0,10,'2014-07-07 00:00:00','2014-07-11 00:00:00',0,'OLIVAIN','AMELIE','F','204 Rue des soldanelles',74800,'LA ROCHE SUR FORON','2003-08-03',''),(84,0,10,'2014-07-08 00:00:00','2014-07-11 00:00:00',0,'CHOMAT','CAPUCINE','F','33 Rue de la pierre d\'angeroux',74800,'LA ROCHE SUR FORON','2003-06-03',''),(85,0,10,'2014-07-08 00:00:00','2014-07-11 00:00:00',0,'ROSELIER','LEA','F','180 Route de la gare ',74800,'ST LAURENT','2001-10-01',''),(87,0,16,'2014-10-11 00:00:00','2014-10-11 00:00:00',0,'LEBASTARD ','Angélica','F','9 La Barre',44390,'SAFFRÉ','1979-09-14','angelica.lebastard@hotmail.fr'),(133,0,18,'2014-10-25 00:00:00','2014-11-01 00:00:00',0,'BAR','Mathilde','F','1420, route de Garlin',64160,'SEVIGNACQ','1997-04-19','nathalie.desclaux@club-internet.fr'),(89,0,16,'2014-10-11 00:00:00','2014-10-11 00:00:00',0,'CHARRIER ','Marie-Gabrielle','F','16 rue de l\'Epine',85130,'LA VERRIE','1948-01-19','gabycharrier@orange.fr'),(90,0,16,'2014-10-11 00:00:00','2014-10-11 00:00:00',0,'SACHOT ','Chantal','F','3 rue des roches',85130,'LA GAUBRETIERE','1965-12-14','chantalsachot@orange.fr'),(91,0,16,'2014-10-11 00:00:00','2014-10-11 00:00:00',0,'MORILLE ','Marie-Colette','F','20 la sauzaie',49600,'GESTÉ','1958-09-20','morillejp@orange.fr'),(92,0,16,'2014-10-11 00:00:00','2014-10-11 00:00:00',0,'ANIS ','Anne-Marie','F','11 bis rue Elie de Mieulle',49640,'CHEMIRÉ SUR SARTHE','1959-11-11','anne-marie.anis@orange.fr'),(93,0,16,'2014-10-11 00:00:00','2014-10-11 00:00:00',0,'GUERIN ','Marie-Cécile','F','19 rue des cloudis',85740,'L\'ÉPINE','1944-05-23','mariececileguerin@yahoo.fr'),(94,0,16,'2014-10-11 00:00:00','2014-10-11 00:00:00',0,'FAVROU ','Brigitte','F','29, impasse Abbé Grégoire',85000,'LA ROCHE SUR YON','1958-03-17','brigitte.barritaud@sfr.fr'),(95,0,16,'2014-10-11 00:00:00','2014-10-11 00:00:00',0,'JAUD ','Séverine','F','Les Terrasses',85000,'LA ROCHE SUR YON','1973-12-22','severine.jaud@free.fr'),(96,0,16,'2014-10-11 00:00:00','2014-10-11 00:00:00',0,'LALY ','Marie-José','F','11 impasse raphael',44200,'NANTES','1952-07-07',''),(97,0,16,'2014-10-11 00:00:00','2014-10-11 00:00:00',0,'PONTOIRE ','Sylvianne','F','1 allée des belettes',49450,'ST MACAIRE','1975-09-14','stephasyl@aol.com'),(98,0,16,'2014-10-11 00:00:00','2014-10-11 00:00:00',0,'GILBERT ','Carole','F','35 le val du petit lay',85500,'ST PAUL EN PAREDS','1969-07-21','benoitpasquier@wanadoo.fr'),(99,0,16,'2014-10-11 00:00:00','2014-10-11 00:00:00',0,'CHAUVET ','Françoise','F','18 ter rue Branly',44620,'LA MONTAGNE','1965-12-09','christophe.chauvet120@orange.fr'),(132,0,18,'2014-10-25 00:00:00','2014-11-01 00:00:00',0,'FERNANDES DE ALMEIDA','Maylis','F','15, rue Ignace Franois Bibal',64500,'SAINT JEAN DE LUZ','1996-06-04','mayllis64@hotmail.fr'),(131,0,18,'2014-10-25 00:00:00','2014-11-01 00:00:00',0,'CESSAC','Marianne','F','7, avenue de Barges',64000,'PAU','1996-02-18','marianne.cessac@orange.fr'),(130,0,18,'2014-10-25 00:00:00','2014-11-01 00:00:00',0,'URRUTIA','Estitxu','F','42, rue MUNHOA',64122,'URRUGNE','1997-09-12','cathyurrutia@orange.fr'),(129,0,18,'2014-10-25 00:00:00','2014-11-01 00:00:00',0,'DUHALDE','Lorea','F','Maison Lur Xuri Bidean',64250,'LOUHOSSOA','1997-10-07','lorea-mail@orange.fr')
The table "adresses" contain 1484629 rows.
NSERT INTO `adresses` VALUES (1,'2021-06-23 01:34:21','2023-07-12 09:01:57',NULL,1,'ST','22','RUE','OBERKAMPF',NULL,NULL,NULL,'75011',NULL,'PARIS','75056','11','75','FR','adagio@fscf.asso.fr',NULL,'0143385057',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'https://www.fscf.asso.fr/',NULL,NULL,NULL,'{\"twitter\": \"https://twitter.com/laFSCF\", \"facebook\": \"https://www.facebook.com/laFSCF\"}',NULL)
(36,'2021-06-23 06:00:00','2021-11-25 15:34:42',NULL,561818,'ST',NULL,NULL,'113 bd Emile Zola',NULL,NULL,NULL,'54520',NULL,'Laxou','54304','44','54','FR',NULL,NULL,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'2021-06-23 06:00:00','2021-11-25 15:34:42',NULL,561819,'ST',NULL,NULL,'65 rue Bellecombe',NULL,NULL,NULL,'69006',NULL,'Lyon','69123','84','69','FR','fscf.lyonnais@9online.fr',NULL,'0472740921',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'2021-06-23 06:00:00','2021-06-23 06:00:00',NULL,561820,'ST',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','00000',NULL,NULL,'FR',NULL,NULL,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'2021-06-23 06:00:00','2021-06-23 06:00:00',NULL,561821,'ST',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','00000',NULL,NULL,'FR',NULL,NULL,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'2021-06-23 06:00:00','2021-11-25 15:34:42',NULL,561822,'ST',NULL,NULL,'Maison des Sports','1240 rue de Bergeresse',NULL,NULL,'45160',NULL,'Olivet','45232','24','45','FR',NULL,NULL,'0238692429',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'2021-06-23 06:00:00','2021-11-25 15:34:42',NULL,561823,'ST',NULL,NULL,'Maison des Sports','44 rue R. Rolland BP 90312',NULL,NULL,'44103',NULL,'44103','00000',NULL,NULL,'FR','fscf.paysdelaloire@wanadoo.fr',NULL,'0240586162',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,'2021-06-23 06:00:00','2021-06-23 06:00:00',NULL,561824,'ST',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','00000',NULL,NULL,'FR',NULL,NULL,'',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'2021-06-23 06:00:00','2021-11-25 15:34:42',NULL,561825,'ST',NULL,NULL,'277 Chemin du Vallon de l\'Oriol',NULL,NULL,NULL,'13007',NULL,'Marseille','13055','93','13','FR','fscf.liguepaca@cegetel.net',NULL,'0491523281',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'2021-06-23 06:00:00','2021-11-25 15:34:42',NULL,561826,'ST',NULL,NULL,'84 rue de Flandre','BP 40',NULL,NULL,'60190',NULL,'Blincourt','60078','32','60','FR','cdoise.fscf@wanadoo.fr',NULL,'0344419663',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,'2021-06-23 06:00:00','2021-11-25 15:34:42',NULL,561827,'ST',NULL,NULL,'3 Place de la Mairie','La Bourgeoisie',NULL,NULL,'86240',NULL,'Iteuil','86113','75','86','FR','fscfpoitouchar@aliceadsl.fr',NULL,'0549381169',NULL,NULL,'0609213389',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
The table "preinsc_personnes_imports_personnes" contain 33011 rows.
NSERT INTO `preinsc_personnes_imports_personnes` VALUES (1,'2022-01-21 13:51:18','2022-01-21 13:52:50',7,1254914,1,'{\"nom\": \"ADRIANO CATALDO\", \"photo\": null, \"prenom\": \"Thais\", \"civilite\": \"M\", \"adresse-tel\": null, \"nationalite\": null, \"adresse-mail\": \"jeremy.adriano1504@gmail.com\", \"adresse-pays\": null, \"code-adherent\": null, \"nom-naissance\": null, \"adresse-mobile\": null, \"lieu-naissance\": null, \"adresse-commune\": null, \"adresse-batiment\": null, \"adresse-escalier\": null, \"adresse-lieu-dit\": null, \"adresse-nom-voie\": null, \"adresse-num-voie\": null, \"adresse-type-voie\": null, \"commune-naissance\": null, \"date-de-naissance\": \"15/04/2010\", \"pays-de-naissance\": null, \"adresse-code-insee\": null, \"adresse-code-postal\": null, \"autorisation-legale\": false, \"departement-naissance\": null, \"autorisation-offre-com\": false, \"conditions-utilisation\": false, \"representant-legal-nom\": null, \"autorisation-newsletter\": false, \"representant-legal-mail\": null, \"representant-legal-prenom\": null, \"representant-legal-civilite\": \"M\", \"representant-legal-telephone\": null, \"autorisation-offre-com-autres\": false}','{\"nom\": \"ADRIANO CATALDO\", \"photo\": null, \"prenom\": \"Thais\", \"civilite\": \"Mme(Madame)\", \"adresse-tel\": null, \"nationalite\": null, \"adresse-mail\": \"jeremy.adriano1504@gmail.com\", \"adresse-pays\": null, \"code-adherent\": null, \"nom-naissance\": null, \"adresse-mobile\": null, \"lieu-naissance\": null, \"adresse-commune\": null, \"adresse-batiment\": null, \"adresse-escalier\": null, \"adresse-lieu-dit\": null, \"adresse-nom-voie\": null, \"adresse-num-voie\": null, \"adresse-type-voie\": null, \"commune-naissance\": null, \"date-de-naissance\": \"15/04/2010\", \"pays-de-naissance\": null, \"adresse-code-insee\": null, \"adresse-code-postal\": null, \"autorisation-legale\": null, \"departement-naissance\": null, \"autorisation-offre-com\": null, \"conditions-utilisation\": null, \"representant-legal-nom\": null, \"autorisation-newsletter\": null, \"representant-legal-mail\": null, \"representant-legal-prenom\": null, \"representant-legal-civilite\": null, \"representant-legal-telephone\": null, \"autorisation-offre-com-autres\": null}','[]','{\"adresse-mail\": \"jeremy.adriano1504@gmail.com\", \"autorisation-legale\": 0, \"autorisation-offre-com\": false, \"conditions-utilisation\": 0, \"autorisation-newsletter\": false, \"autorisation-offre-com-autres\": 0}','26ea8d1b05d44ccb3551e98c02282273'),
(5,'2022-01-21 13:51:18','2022-01-21 13:57:47',7,1300065,1,'{\"nom\": \"FACQUEUR\", \"photo\": null, \"prenom\": \"JORDAN\", \"civilite\": \"M\", \"adresse-tel\": null, \"nationalite\": null, \"adresse-mail\": \"oxana_rdn@yahoo.com\", \"adresse-pays\": null, \"code-adherent\": null, \"nom-naissance\": null, \"adresse-mobile\": null, \"lieu-naissance\": null, \"adresse-commune\": null, \"adresse-batiment\": null, \"adresse-escalier\": null, \"adresse-lieu-dit\": null, \"adresse-nom-voie\": null, \"adresse-num-voie\": null, \"adresse-type-voie\": null, \"commune-naissance\": null, \"date-de-naissance\": \"16/06/2008\", \"pays-de-naissance\": null, \"adresse-code-insee\": null, \"adresse-code-postal\": null, \"autorisation-legale\": false, \"departement-naissance\": null, \"autorisation-offre-com\": false, \"conditions-utilisation\": false, \"representant-legal-nom\": null, \"autorisation-newsletter\": false, \"representant-legal-mail\": null, \"representant-legal-prenom\": null, \"representant-legal-civilite\": \"M\", \"representant-legal-telephone\": null, \"autorisation-offre-com-autres\": false}','{\"nom\": \"FACQUEUR\", \"photo\": null, \"prenom\": \"JORDAN\", \"civilite\": \"M (Monsieur)\", \"adresse-tel\": null, \"nationalite\": null, \"adresse-mail\": \"oxana_rdn@yahoo.com\", \"adresse-pays\": null, \"code-adherent\": null, \"nom-naissance\": null, \"adresse-mobile\": null, \"lieu-naissance\": null, \"adresse-commune\": null, \"adresse-batiment\": null, \"adresse-escalier\": null, \"adresse-lieu-dit\": null, \"adresse-nom-voie\": null, \"adresse-num-voie\": null, \"adresse-type-voie\": null, \"commune-naissance\": null, \"date-de-naissance\": \"16/06/2008\", \"pays-de-naissance\": null, \"adresse-code-insee\": null, \"adresse-code-postal\": null, \"autorisation-legale\": null, \"departement-naissance\": null, \"autorisation-offre-com\": null, \"conditions-utilisation\": null, \"representant-legal-nom\": null, \"autorisation-newsletter\": null, \"representant-legal-mail\": null, \"representant-legal-prenom\": null, \"representant-legal-civilite\": null, \"representant-legal-telephone\": null, \"autorisation-offre-com-autres\": null}','[]','{\"autorisation-legale\": 0, \"autorisation-offre-com\": false, \"conditions-utilisation\": 0, \"autorisation-newsletter\": false, \"autorisation-offre-com-autres\": 0}','35fd1342a0db6c5ee976ace21a360099')
The table "personnes_representants_legaux" contain 300702 rows.
INSERT INTO `personnes_representants_legaux` VALUES (1,79620,'LEBRETON','CHRISTINE','0642490996','bruno.beaudouin0461@orange.fr',NULL,'PRI'),(2,1294047,'Petit','Delphine','06 61 89 69 15','petit.d2507@gmail.com',NULL,'PRI'),(3,148015,'MILLIER','LUDOVIC','0612464283','millier.ludovic@free.fr',NULL,'PRI'),,
(69,1294231,'LEGRAND','Audrey','0615526641','audreylegrand@laposte.net','Mme','PRI'),(70,613186,'ADAM','SANDRINE','06 88 00 08 22','adamhutt@orange.fr',NULL,'PRI'),(71,1294236,'YAPI','OLGA','0664059968','olga_kaela@hotmail.fr',NULL,'PRI'),(72,1294242,'ANDRE','VIRGINIE','0749696350','cvirginie.lea87@gmail.com',NULL,'PRI'),(73,1294248,'petre','marina','0687077547','marinazambelli@gmail.com',NULL,'PRI'),(74,1294249,'PELISSIER','PHILIPPE','0620301085','pelissierphilippe@hotmail.fr',NULL,'PRI'),(75,1294253,'benjelloun','anonyme','0637222821','benjellounzouhair@yahoo.fr',NULL,'PRI'),(76,614453,'le MOAL','Pascale','0661754888','pascale.billard-le-moal@wanadoo.fr',NULL,'PRI'),(77,1294255,'D\'ONOFRIO','laurent','06 25 54 37 43','stefroyon@yahoo.fr',NULL,'PRI'),(78,619318,'GARCIA','Ana','0385914609','ana.garcia@orange.fr',NULL,'PRI'),(79,1294302,'KWAN KOC HONG','SOLENE','0611097154','keyshikkh@msn.com',NULL,'PRI'),(80,624458,'danion','louise','06 87 66 29 25','familledanion@orange.fr',NULL,'PRI'),(81,1294322,'CHELET','MICKAEL','0642215402','carla.paz.api@gmail.com',NULL,'PRI'),(82,625534,'DECOLOGNE','Delphine','0636064301','gymaplicences@gmail.com',NULL,'PRI'),(83,1294331,'CAVIL','FRANK','0665226989','loicia.lancelot@sfr.fr',NULL,'PRI'),(85,1294353,'LOUESDON','LAETITIA','067191275','laetitia.louesdon@hotmail.fr',NULL,'PRI'),(86,630610,'Francois','MAgali','0607343466','magali.francois59@gmail.com',NULL,'PRI'),(87,1294362,'Larquier','Bruno','0777994400','bruno.larquier-laplace@orange.fr',NULL,'PRI'),(89,1294385,'LEMOINE','AURORE','0687528848','auroma56@hotmail.fr',NULL,'PRI'),(93,632174,'CHAUX','Catherine','06 41 14 60 16','catherinechaux@orange.fr',NULL,'PRI'),(94,632178,'MILESI','Gérald','06 84 78 02 56','geraldcecile@sfr.fr',NULL,'PRI'),(95,1294389,'LIZE','CHARLOTTE','0662544228','charlotte.lize56690@gmail.com',NULL,'PRI'),(97,1294406,'FOURDRAIN','NICOLAS','0682433649','sabrinadesiage74@gmail.com',NULL,'PRI'),(98,1294408,'JOUVE','ISABELLE','06 77 84 00 39','isabelle.jouve42@free.fr',NULL,'PRI'),(99,632601,'Veillard','Patricia','fannyveillard@gmail.com','0600000001',NULL,'PRI'),(101,1294441,'DEVROUX','Jean','06 40 73 89 01','chrisetambre@aol.com',NULL,'PRI')
The table "personne" contain 1334442 rows.
INSERT INTO `personne` VALUES (1,'Physique','LicenciéMigré','','','','AVIGAD','ELINOR','1999-08-16','F','','','','Rue eydoux','',13006,'MARSEILLE',NULL,'','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2006-05-21 00:00:00','',0,1,0,'','','','',''),(2,'Physique','LicenciéMigré','0','','','ODLAN','AZIADE','1999-01-08','F','','','','6 Rue Eydoux','',13006,'MARSEILLE',NULL,'FRANCE','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2006-02-24 00:00:00','',0,1,0,'','','','',''),(3,'Physique','LicenciéMigré','0000009689','','','DENIS','AURORE','1986-12-22','F','','','','2/73 RUE GERNES RIEUX','',59113,'SECLIN','59560','FRANCE','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2005-01-25 00:00:00','',0,1,0,'','','','',''),
(27,'Physique','LicenciéMigré','0000500582','','','MOUGNERES','CAROLE','1966-02-13','F','','','','14 RUE AOUQUE','',40180,'OEYRELUY','40207','','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2006-02-06 00:00:00','',0,1,0,'','','','',''),(28,'Physique','LicenciéMigré','0000500583','','','POTTIER','LEO','1998-11-20','M','','','','ALLEE DE STALINES','',40140,'SOUSTONS','40310','','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2006-11-27 14:51:40','',0,1,0,'','','','',''),(29,'Physique','LicenciéMigré','0000500584','','','PHILIPART','ESTER','1999-05-06','F','','','2','ALLEE DE PASSECAN','',40140,'SOUSTONS','40310','','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2006-12-18 15:56:39','',0,1,0,'','','','',''),(30,'Physique','LicenciéMigré','0000500585','','','MONSARRAT','GILLES','1985-10-16','M','','','','43 BD HIPPOLYTE SINTAS','',40100,'DAX','40088','','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2006-02-06 00:00:00','',0,1,0,'','','','',''),(31,'Physique','LicenciéMigré','0000500586','','','PAQUERO','PAUL','1984-08-05','M','','','','26 RUE JEAN LE BON','',40100,'DAX','40088','','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2006-02-06 00:00:00','',0,1,0,'','','','',''),(32,'Physique','LicenciéMigré','0000500587','','','QUESNOT','ANAIS','1984-09-02','F','','','','12 RUE PASCAL DUPRAT','',40990,'SAINT PAUL LES DAX',NULL,'','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2006-02-06 00:00:00','',0,1,0,'','','','',''),(33,'Physique','LicenciéMigré','0000500588','','','BRAYER','EMILIE','1981-01-12','F','','','','31 AVENUE VICTOR HUGO','',40100,'DAX','40088','','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2006-02-06 00:00:00','',0,1,0,'','','','',''),(34,'Physique','LicenciéMigré','0000500589','','','CORSEZ','CELINE','1976-04-14','F','','','','27 RUE PIERRE BENOIT','',40100,'DAX','40088','','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2006-02-06 00:00:00','',0,1,0,'','','','',''),(35,'Physique','LicenciéMigré','0000500590','','','PANTEIX','STEPHANIE','1976-01-18','F','','','','36 ROUTE D\'ASPREMONT','',40100,'DAX','40088','','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2006-02-06 00:00:00','',0,1,0,'','','','',''),(36,'Physique','LicenciéMigré','0000500591','','','BOUTEILLE','VICTOR','2002-03-13','M','','','','168 AVENUE GEORGES CLEMENCEAU','',40100,'DAX','40088','','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2006-02-06 00:00:00','',0,1,0,'','','','',''),(37,'Physique','LicenciéMigré','0000500592','','','CALU','AINHOA','2002-01-29','F','','','','22 RUE DES FAUVETTES','',40100,'DAX','40088','','','','','','','','','','','0000-00-00','0000-00-00',0,0,0,'','2006-02-06 00:00:00','',0,1,0,'','','','',''),(38,'Physique','LicenciéMigré','0000500593','','M','CAZAUX','THOMAS','2001-01-05','M','','','5','RUE CHARLES DESPIAU','',40100,'DAX','40088','FRANCE','','','','','thomas.cazaux40@gmail.com','','','','','0000-00-00','0000-00-00',0,0,0,'','2018-10-03 18:24:52','',0,2,0,'','','','','')
The table "commandes_lignes" contain 1741273 rows.
INSERT INTO `commandes_lignes` VALUES (1371663,'2024-09-18 11:04:28','2024-09-18 11:04:28',385710,'LIC','Prise de licence CA - Sports Collectifs 2025 - Mme SERBOURDIN Axelle',97,NULL,13.50,'ELicence\\Core\\Models\\Licence',3612715,1419996,0,NULL,'LIC','{\"mouvement_code\":\"LIC\",\"licence_id\":3612715,\"personne_id\":1435659,\"compta_id\":1283,\"structure_id\":563090,\"libelle\":\"Prise de licence CA - Sports Collectifs 2025 - Mme SERBOURDIN Axelle\",\"devise\":\"EUR\",\"saison\":2025,\"debit\":13.5}',NULL),(1371664,'2024-09-18 11:04:28','2024-09-18 11:04:28',385710,NULL,'Cotisation Régionale CA - Sports Collectifs 2025 - Mme SERBOURDIN Axelle',97,NULL,1.50,'ELicence\\Core\\Models\\Licence',3612715,1419997,0,NULL,'CTLLIG','{\"mouvement_code\":\"CTLLIG\",\"licence_id\":3612715,\"personne_id\":1435659,\"compta_id\":1283,\"structure_id\":563090,\"libelle\":\"Cotisation R\\u00e9gionale CA - Sports Collectifs 2025 - Mme SERBOURDIN Axelle\",\"devise\":\"EUR\",\"saison\":2025,\"debit\":1.5,\"mutation_id\":null}',NULL),(1371665,'2024-09-18 11:04:28','2024-09-18 11:04:28',385710,NULL,'Cotisation Départementale CA - Sports Collectifs 2025 - Mme SERBOURDIN Axelle',97,NULL,20.50,'ELicence\\Core\\Models\\Licence',3612715,1419998,0,NULL,'CTLDEP','{\"mouvement_code\":\"CTLDEP\",\"licence_id\":3612715,\"personne_id\":1435659,\"compta_id\":1283,\"structure_id\":563090,\"libelle\":\"Cotisation D\\u00e9partementale CA - Sports Collectifs 2025 - Mme SERBOURDIN Axelle\",\"devise\":\"EUR\",\"saison\":2025,\"debit\":20.5,\"mutation_id\":null}',NULL),(1371666,'2024-09-18 11:04:59','2024-09-18 11:04:59',385711,'LIC','Prise de licence CL - Activités en loisir 2025 - Mme ANCEL Aude-Armandine',100,NULL,10.00,'ELicence\\Core\\Models\\Licence',3612716,1419999,0,NULL,'LIC','{\"mouvement_code\":\"LIC\",\"licence_id\":36127
The table "felixlicencie" contain 45684 rows.
INSERT INTO `felixlicencie` VALUES (45424,'0459303135','GABORET','ELISABETH','21/02/1981','0450004','2','2','09/10/1993','1','LE CLOU','','45500','ST GONDON','25/11/1993','','1','0','0','25/11/1993','','25/11/1993','1994','\r\n'),
(45446,'0899300021','FUENTES','JESSICA','29/06/1979','0890003','2','2','','1','','','','','21/09/1993','','2','','','21/09/1993','279512','','\r\n',''),(45447,'0899300022','ARNOUD','LYDIE','16/07/1979','0890003','2','2','','1','','','','','21/09/1993','','2','','','21/09/1993','279513','','\r\n',''),(45448,'0899300023','FONTAINE','CAROLINE','19/04/1981','0890003','2','2','','1','5 IMPASSE PAUL FORT','','16800','SOYAUX','21/09/1993','','2','','','21/09/1993','279514','','\r\n',''),(45449,'0899300024','FONTAINE','CECILE','19/03/1983','0890003','2','2','','1','','','','','21/09/1993','','2','','','21/09/1993','279515','','\r\n',''),(45450,'0899300025','MAGNE','JOSIANE','26/12/1940','0890003','3','2','','1','1 ALLEE ROUAULT','','89200','AVALLON','21/09/1993','','2','','','21/09/1993','279516','','\r\n',''),(45451,'0899300026','ARNOUD','PASCALE','03/08/1957','0890003','3','2','','1','','','','','21/09/1993','','2','','','21/09/1993','279517','','\r\n',''),(45452,'0899300027','SAGET','ISABELLE','16/04/1975','0890010','2','2','08/10/1993','1','les Michaults','','89240','POURRAIN','01/12/1993','','1','','','21/09/1993','279518','01/12/1993','1994',''),(45453,'0899300028','BALTAZART','SYLVIE','21/04/1969','0890010','2','2','08/10/1993','1','Les Bonnaults','','89240','POURRAIN','13/01/1994','','1','','','21/09/1993','279519','13/01/1994','1994',''),(45454,'0899300029','FAUSSOT','SEVERINE','25/10/1973','0890013','2','2','','1','Chemin des Cordeliers','','89700','TONNERRE','21/09/1993','','2','','','21/09/1993','279525','','\r\n',''),(45455,'0899300030','MATTIUSSI','KAREN','17/04/1978','0890013','2','2','','1','21 RUE CAMILLE DORMOIS','','89700','TONNERRE','21/09/1993','','2','','','21/09/1993','279529\r\n','','',''),(45456,'0899300031','DIDIER','ANGELIQUE','10/07/1982','0890013','2','2','','1','Rue de Louvois','','89700','TONNERRE','21/09/1993','','2','','','21/09/1993','279536\r\n','','',''),(45457,'0899300032','OTTONDO','DEBORAH','01/09/1982','0890013','2','2','','1','2 RUE DE VOULAVINEE','','89700','VEZINNES','21/09/1993','','2','','','21/09/1993','279538\r\n','','',''),(45458,'0899300033','DEQUEKER','CHARLOTTE','01/11/1982','0890013','2','2','','1','4, rue Georges Henri Carre','','89700','TONNERRE','21/09/1993','','2','','','21/09/1993','279539\r\n','','','')