08-01-2025, 04:02 PM
Hello, Today i'm selling the database (full sql dump not scrap) of the Fédération Française de Roller & Skateboard.
Offer a price in PM.
Only MM
Sample :
The table "preinsc_personnes_imports_personnes" contain 37253 rows.
INSERT INTO `preinsc_personnes_imports_personnes` VALUES (28279,'2023-09-30 21:38:45','2023-10-24 22:13:27',5145,302130,1,'{\"date\": \"2023-09-23T18:37:13.8610488+02:00\", \"pays\": \"FR\", \"commune\": null, \"civilite\": \"M\", \"lastname\": \"Serrano\", \"firstname\": \"Noah\", \"item-name\": \"Autre moyen de paiement\", \"telephone\": null, \"complement\": null, \"discipline\": \" Roller Freestyle \", \"code-postal\": \"72290\", \"payer-email\": \"aurore-girard@wanadoo.fr\", \"type-de-voie\": \"CHE\", \"payer-country\": \"FRA\", \"nom-de-la-voie\": \"des enclos\", \"numero-de-voie\": \"10\", \"payer-lastname\": \"Serrano\", \"droits-a-limage\": \"Je donne mon accord pour que le club utilise mon image pour sa communication \", \"payer-firstname\": \"Aurore\", \"photo-didentite\": \"https://www.helloasso.com/documents/documents_users_souscriptions/20230923_174118-d3b8e39fc1c84a49ad104dc91b0fe334.jpg\", \"type-de-licence\": \" Compétition\", \"nom-de-naissance\": \"Serrano\", \"telephone-mobile\": \"0659245878\", \"payer-dateofbirth\": \"2023-09-23T18:37:00+02:00\", \"email-de-ladherent\": \"aurore-girard@wanadoo.fr\", \"etes-vous-deja-licencie\": \"Oui\", \"nationalite-de-ladherent\": \"FR\", \"problemes-de-sante-connus\": \"Non\", \"inscription-dans-le-groupe\": \"Freestyle\", \"statuts-et-reglement-du-club\": \"Je ou son représentant légal accepte les statuts et le règlement du club\", \"doit-a-limage-reseaux-sociaux\": \"Je refuse que des photos de moi apparaissent sur les réseaux sociaux du club\", \"date-de-naissance-de-ladherent\": \"07/07/2007\", \"pays-de-naissance-de-ladherent\": \"250\", \"ville-de-naissance-de-ladherent\": \"LE MANS\", \"certificat-medical-ou-attestation\": \"https://www.helloasso.com/documents/documents_users_souscriptions/questionnaire noah-0584a5f73bbb438d8fd565343e3e2d8f.pdf\", \"taille-du-tee-shirt-du-club-offert\": \"M\", \"souhaite-obtenir-une-attestation-dadhesion\": \"Oui\", \"numero-de-licence-obligatoire-si-deja-licenciee\": \"311938\", \"nom-du-tuteur-legal-obligatoire-si-adherent-mineur\": \"Serrano\", \"email-du-tuteur-legal-obligatoire-si-adherent-mineur\": \"aurore-girard@wanadoo.fr\", \"prenom-du-tuteur-legal-obligatoire-si-adherent-mineur\": \"Aurore\", \"telephone-du-tuteur-legal-obligatoire-si-adherent-mineur\": \"0659245878\", \"personne-a-prevenir-en-cas-durgence-identite-et-telephone\": \"Serrano Aurore 0659245878\", \"nom-du-medecin-non-obligatoire-si-pas-de-certificat-fourni\": null, \"date-du-certificat-medical-non-obligatoire-si-pas-de-certificat\": null, \"mail-du-deuxieme-tuteur-legal-si-vous-souhaitez-quil-recoive-egalement-les-informations-mails\": null, \"telephone-du-deuxieme-tuteur-legal-si-vous-souhaitez-quil-recoive-egalement-les-informations-sms\": \"0664410472\", \"je-ou-son-representant-legal-donne-mon-consentement-a-la-reception-par-voie-electronique-doffres-commerciales\": false, \"garanties-responsabilite-civile-dont-je-beneficie-par-lintermediaire-de-ma-licence-voir-notice-page-precedente\": \"Je (ou son représentant légal) déclare avoir pris connaissance, des garanties responsabilité civile \", \"je-ou-son-representant-legal-donne-mon-consentement-a-la-reception-par-voie-electronique-de-newsletters-et-dinformations-federales\": false, \"protection-des-donnees-personnelles-pour-la-souscription-a-une-licence-aupres-de-la-federation-francaise-de-roller-et-skateboard-voir-informations-page-precedente\": true, \"collecte-et-traitement-de-mes-donnees-dans-les-conditions-de-la-charte-dans-la-poursuite-des-finalites-de-loutil-de-gestion-de-licences-a-defaut-le-service-de-licence-dematerialisee-ne-me-sera-pas-accessible\": true, \"droit-a-limage-jautorise-le-club-la-federation-ou-ses-liguescomites-a-utiliser-sur-ses-supports-de-communication-ma-photo-didentite-inseree-sur-la-licence-a-des-fins-exclusives-de-promotion-de-ses-activites-et-a-des-fins-non-commerciales\": false, \"risques-encourus-pouvant-porter-atteinte-a-mon-integrite-physique-lors-de-la-pratique-de-ma-discipline-et-en-consequence-linteret-que-presente-la-souscription-dun-contrat-dassurance-individuelle-de-personnes-couvrant-les-dommages-corporels\": \"Je (ou son représentant légal) déclare en avoir pris connaissance des garanties individuelles et assistance\"}','{\"date\": \"2023-09-23T18:37:13.8610488+02:00\", \"pays\": \"FRANCE\", \"commune\": \"Ballon-Saint-Mars\", \"civilite\": \"Monsieur\", \"lastname\": \"Serrano\", \"https://www.helloasso.com/documents/documents_users_souscriptions/img20230930172604-a71240681e8b4c59951cd5a9952e6d90.jpg\", \"informations-relatives-a-la-sante-et-aux-allergies\": \"Aucune\", \"personne-a-contacter-en-cas-durgence-nom-telephone\": \"0619487888\", \"profil-facebook-pour-ajout-sur-les-groupes-de-la-ligue\": \"Arnaud BELLINGER\", \"rib-pour-les-remboursements-et-participations-au-frais-de-transport\": \"FR76 1027 8027 1500 0442 8980 116\", \"photo-didentite-format-pris-en-charge-jpeg-png-gif-bmp-taille-maximum-8mo\": \"https://www.helloasso.com/documents/documents_users_souscriptions/img_7112-fr passeport-35x45 mm-8a1e6a440e9446f88172d0c3e9f76f0b.jpg\", \"certificat-medical-ou-attestation-qs-sport-lien-en-premiere-page-dinscription\": \"https://www.helloasso.com/documents/documents_users_souscriptions/img20230930172616-04cf9f8897c54142b9461aa18d28d746.jpg\"}',
The table "personnes" contain 577061 rows.
INSERT INTO `personnes` VALUES (11826,'2010-09-11 07:21:24','2024-09-02 18:02:41','123762',NULL,'A','M','MAILLET','Yannick','M','1977-03-09','CHOLET','250',NULL,'','FR',NULL,'FR',0,NULL,'11826_316605_photo_id.png','2024-09-02',0,'2016-11-12 13:58:08',NULL,NULL,NULL,0,0,1,1,0,'{\"numero\": \"49\", \"pseudo\": \"CHARAL\", \"matricule\": \"\", \"numeroPdga\": \"\", \"numero_carte_pro_encadrant\": \"\", \"honorabilite_status_arbitre\": false, \"honorabilite_status_dirigeant\": false, \"honorabilite_status_encadrant\": false}','2018-12-02',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL)
(12656,'2010-09-11 07:20:57','2021-06-29 15:07:59','058312',NULL,'A','Mme','COULOMB','Dominique','F','1966-12-14','','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(12657,'2010-09-11 07:21:24','2021-06-29 15:07:59','041928',NULL,'A','M','MILLOT','Emmanuel','M','1990-03-22','','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(12658,'2010-09-11 07:21:19','2021-06-29 15:07:59','025544',NULL,'A','Mme','LE LANN','Sandra','F','1994-08-18','','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(12659,'2010-09-11 07:21:02','2021-06-29 15:07:59','107464',NULL,'A','Mme','DANTCIKIAN','Romane','F','1996-04-23','','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(12660,'2010-09-11 07:21:24','2021-06-29 15:07:59','140232',NULL,'A','M','MAYELLE','Thibault','M','1988-08-09','','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(12661,'2010-09-11 07:20:57','2021-06-29 15:07:59','156616',NULL,'A','M','COLOMB','Jean Pierre','M','1956-10-08','','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(12662,'2010-09-11 07:21:24','2021-06-29 15:07:59','173000',NULL,'A','Mme','MARTIN','Chloe','F','1999-03-17','NIORT','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(12663,'2010-09-11 07:21:18','2021-06-29 15:07:59','156617',NULL,'A','Mme','KIEFER','Lucile','F','2000-03-28','','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,0,'2017-09-14 16:36:10',NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(12664,'2010-09-11 07:21:30','2021-06-29 15:07:59','074697',NULL,'A','M','PETIT','Benoit','M','1987-11-02','','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(12665,'2010-09-11 07:21:02','2021-06-29 15:07:59','058313',NULL,'A','M','DUCRET','Franck','M','1983-09-03','','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(12666,'2010-09-11 07:21:30','2021-06-29 15:07:59','041929',NULL,'A','Mme','PIGNET','France','F','1957-01-21','','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(12667,'2010-09-11 07:21:24','2021-06-29 15:07:59','123849',NULL,'A','M','MOURAO','Guillaume','M','1991-11-16','','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(12668,'2010-09-11 07:21:19','2021-06-29 15:07:59','025545',NULL,'A','Mme','LE LANN','Corinne','F','1969-09-14','','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(12669,'2010-09-11 07:21:10','2021-06-29 15:07:59','107465',NULL,'A','Mme','GROLLIER','Fanny','F','1998-06-05','','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
The table "adresses" contain 588251 rows.
INSERT INTO `adresses` VALUES (600758,'2024-11-08 09:04:57','2024-11-08 09:04:57',587340,NULL,'PR','8','AVE','jehan de chelles',NULL,NULL,NULL,'77500',NULL,'CHELLES','77108','11','77','FR','lagadic@univ.paris1.fr',NULL,NULL,NULL,NULL,'0624066119',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
(600760,'2024-11-08 09:08:57','2024-11-08 09:08:57',587342,NULL,'PR',NULL,'SANS',NULL,NULL,NULL,NULL,'12330',NULL,'MARCILLAC-VALLON','12138','76','12','FR','avignonmuriel12@orange.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(600761,'2024-11-08 09:11:39','2024-11-08 09:11:39',587343,NULL,'PR','7','RUE','de la talandiere',NULL,NULL,NULL,'77410',NULL,'CLAYE-SOUILLY','77118','11','77','FR','martinaud@gmail.com',NULL,NULL,NULL,NULL,'0651759823',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(600762,'2024-11-08 09:15:15','2024-11-08 09:15:15',587344,NULL,'PR','7','RUE','de la talandiere',NULL,NULL,NULL,'77410',NULL,'CLAYE-SOUILLY','77118','11','77','FR','martinaud@gmail.com',NULL,NULL,NULL,NULL,'0651759823',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(600763,'2024-11-08 09:18:05','2024-11-08 09:19:58',587345,NULL,'PR','56','RUE','Marcel talabot',NULL,NULL,NULL,'87220',NULL,'FEYTIAT','87065','75','87','FR','aurelia.becker@gmail.com','aurelia.becker@gmail.com','0673312900',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(600764,'2024-11-08 09:18:30','2024-11-08 09:18:30',587346,NULL,'PR','11','AVE','du canal',NULL,NULL,NULL,'77500',NULL,'CHELLES','77108','11','77','FR','nicole.maikisch@outlook.fr',NULL,NULL,NULL,NULL,'0660223315',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(600765,'2024-11-08 09:23:20','2024-11-08 09:23:20',587347,NULL,'PR','18','RUE','Pierre DESBOIS',NULL,NULL,NULL,'18230',NULL,'SAINT-DOULCHARD','18205','24','18','FR','touchet.cedric@laposte.net',NULL,NULL,NULL,NULL,'0761784107',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(600766,'2024-11-08 09:25:47','2024-11-08 09:25:47',587348,NULL,'PR','28','RUE','Henry Avril',NULL,NULL,NULL,'22970',NULL,'PLOUMAGOAR','22225','53','22','FR','nini222009@hotmail.fr',NULL,'0617961690',NULL,NULL,NULL,NULL,NULL
The table "commandes" contain 2380161 rows.
INSERT INTO `commandes` VALUES (466185,'0000465790',407642,'ELicence\\Core\\Models\\Structure','Prise de licence Educateur sportif 2025 - 359669 M POMMEPUY Maxime',1579,'LIC',45.38,'EUR','P',1579,'P',NULL,'2024-11-28 17:24:38','2024-11-28 16:24:38','2024-11-28 16:24:38',1,NULL,0)
(466224,'0000465829',407681,'ELicence\\Core\\Models\\Structure','Achat de assurance journalière : Roller Day 1 jour - 01/12/2024 00:00\n - 02/12/2024 00:00 - 00928 - 593956 Mme AKBLY Inaya',1063,'LIJ',1.80,'EUR','P',1063,'P',NULL,'2024-11-28 19:58:44','2024-11-28 18:58:44','2024-11-28 18:58:45',1,NULL,0),(466225,'0000465830',407682,'ELicence\\Core\\Models\\Structure','Achat de assurance journalière : Roller Day 1 jour - 01/12/2024 00:00\n - 02/12/2024 00:00 - 00928 - 593957 M DIYAMONA Enzo',1063,'LIJ',1.80,'EUR','P',1063,'P',NULL,'2024-11-28 20:01:23','2024-11-28 19:01:23','2024-11-28 19:01:23',1,NULL,0),(466226,'0000465831',407683,'ELicence\\Core\\Models\\Structure','Achat de assurance journalière : Roller Day 1 jour - 01/12/2024 00:00\n - 02/12/2024 00:00 - 00928 - 593958 Mme BREBANT Marie',1063,'LIJ',1.80,'EUR','P',1063,'P',NULL,'2024-11-28 20:04:28','2024-11-28 19:04:28','2024-11-28 19:04:28',1,NULL,0),(466227,'0000465832',407684,'ELicence\\Core\\Models\\Structure','Achat de assurance journalière : Roller Day 1 jour - 01/12/2024 00:00\n - 02/12/2024 00:00 - 00928 - 593959 Mme DE LESELEUC DE KEROUARA Solene',1063,'LIJ',1.80,'EUR','P',1063,'P',NULL,'2024-11-28 20:09:40','2024-11-28 19:09:40','2024-11-28 19:09:40',1,NULL,0),(466228,'0000465833',407685,'ELicence\\Core\\Models\\Structure','Prise de licence Compétition 2025 - 465245 Mme GUERIN Emma',697,'LIC',46.83,'EUR','P',697,'P',NULL,'2024-11-28 20:10:14','2024-11-28 19:10:14','2024-11-28 19:10:15',1,NULL,0),(466229,'0000465834',407686,'ELicence\\Core\\Models\\Structure','Prise de licence Compétition 2025 - 465236 Mme KNITTEL Lola',697,'LIC',25.53,'EUR','P',697,'P',NULL,'2024-11-28 20:12:55','2024-11-28 19:12:55','2024-11-28 19:12:56',1,NULL,0),(466230,'0000465835',407687,'ELicence\\Core\\Models\\Structure','Achat de assurance journalière : Roller Day 1 jour - 01/12/2024 00:00\n - 02/12/2024 00:00 - 00928 - 593960 M BATTEN William',1063,'LIJ',1.80,'EUR','P',1063,'P',NULL,'2024-11-28 20:13:05','2024-11-28 19:13:05','2024-11-28 19:13:05',1,NULL,0),(466231,'0000465836',407688,'ELicence\\Core\\Models\\Structure','Achat de assurance journalière : Roller Day 1 jour - 01/12/2024 00:00\n - 02/12/2024 00:00 - 00928 - 593961 Mme BREBANT Julie',1063,'LIJ',1.80,'EUR','P',1063,'P',NULL,'2024-11-28 20:15:27','2024-11-28 19:15:27','2024-11-28 19:15:28',1,NULL,0),(466232,'0000465837',407689,'ELicence\\Core\\Models\\Structure','Prise de licence Compétition 2025 - 593962 M PATRAS Jules',1128,'LIC',25.53,'EUR','P',1128,'P',NULL,'2024-11-28 20:18:13','2024-11-28 19:18:13','2024-11-28 19:18:14',1,NULL,0),(466233,'0000465838',407690,'ELicence\\Core\\Models\\Structure','Prise de licence Officiel de compétition 2025 - 436640 M FROMENT Antoine',1861,'LIC',0.00,'EUR','P',1861,'P',NULL,'2024-11-28 20:21:43','2024-11-28 19:21:43','2024-11-28 19:21:44',1,NULL,0),(466234,'0000465839',407691,'ELicence\\Core\\Models\\Structure','Prise de licence Compétition 2025 - 481489 Mme GILLES Lola',697,'LIC',46.83,'EUR','P',697,'P',NULL,'2024-11-28 20:22:20','2024-11-28 19:22:20','2024-11-28 19:22:21',1,NULL,0),(466235,'0000465840',407692,'ELicence\\Core\\Models\\Structure','Engagement de l\'équipe E0909 - E- APR 63 CLERMONT FERRAND ROLLER SKATE CLUB 03 - AURA - REGIONALE 1',619,'ENG',0.00,'EUR','P',619,'P',NULL,'2024-11-28 20:22:41','2024-11-28 19:22:41','2024-11-28 19:22:42',1,NULL,0),(466236,'0000465841',408121,'ELicence\\Core\\Models\\Personne','Inscription sur la manifestation : Compétition Jean Paul The Boss',412345,'ENCIF1E',25.00,'EUR','P',71909,'CB',2544152,'2024-12-01 18:16:52','2024-11-28 19:24:52','2024-12-01 17:16:53',1,NULL,0),(466237,'0000465842',407693,'ELicence\\Core\\Models\\Structure','Prise de licence Compétition 2025 - 533812 Mme LEPRIVEY
The table "commandes_lignes" contain 1907140 rows.
NSERT INTO `commandes_lignes` VALUES (1,1,'AFF','Réaffiliation Fédérale 00920 - ROLLER CLUB DE BOURGES',246,121.65,'ELicence\\Core\\Models\\Affiliation',15113,'2018-08-20 14:12:07','2018-08-20 14:12:07',1,1,NULL,'RAFF','{\"mouvement_code\":\"RAFF\",\"compta_id\":1055,\"structure_id\":1055,\"libelle\":\"Prise d\'affiliation, r\\u00e9affiliation 2019\",\"devise\":\"EUR\",\"saison\":2019,\"debit\":\"121.65\"}',NULL,NULL)
(3,1,'PIA','Assurance IA Non Pratiquant - Dirigeant 2019 - M REQUIEM Alain',251,0.36,'ELicence\\Core\\Models\\Licence',1200000,'2018-08-20 14:12:07','2018-08-20 14:12:07',3,1,NULL,'PIA','{\"mouvement_code\":\"PIA\",\"licence_id\":1200000,\"personne_id\":327996,\"compta_id\":1055,\"structure_id\":1055,\"libelle\":\"Assurance IA Non Pratiquant - Dirigeant 2019 - M REQUIEM Alain\",\"devise\":\"EUR\",\"saison\":2019,\"debit\":0.36}',NULL,NULL),(4,1,'LIC','Prise de licence Non Pratiquant - Dirigeant 2019 - Mme MICHON Sylvaine',251,35.97,'ELicence\\Core\\Models\\Licence',1200001,'2018-08-20 14:12:07','2018-08-20 14:12:07',4,1,NULL,'LIC','{\"mouvement_code\":\"LIC\",\"licence_id\":1200001,\"personne_id\":372665,\"compta_id\":1055,\"structure_id\":1055,\"libelle\":\"Prise de licence Non Pratiquant - Dirigeant 2019 - Mme MICHON
The table "users" contain 67034 rows.
INSERT INTO `users` VALUES (36930,'453124','$2y$10$iafFGZ8.qv8LsLvXWJygF.VADgN1sEg8c/tU7OaJa2Qw5txrAu3Cm',448364,1,NULL,'2020-12-04 15:14:10','2020-12-04 15:15:08',0),(36931,'343416','$2y$10$Oy4c7LL24uxPgkBt.DazGesyLJEVBqvzt09H4w3u/f.KdOM5FWTxO',334324,1,NULL,'2020-12-04 17:49:48','2020-12-04 17:50:12',0),
(36953,'268867','$2y$10$HIqUAGgOqYrMZPNbpJiw1.yCvblCXTpm5x7Ch4uncp1GOSJzS4QcW',256676,1,NULL,'2020-12-07 09:10:15','2020-12-07 09:10:28',0),(36954,'490242','$2y$10$WHxp3ezi42/QeGzkrbHbneKqnduBHUxHoOEIDRJesXwPF75TgwW3m',485800,1,NULL,'2020-12-07 09:24:19','2020-12-07 09:25:08',0),(36955,'490243','$2y$10$PHdvKlwboJ4brz0e38GUoeFPYFgQabZbAONQasqQp53mtJBVMhfEC',485801,1,NULL,'2020-12-07 10:10:25','2020-12-07 10:10:38',0),(36956,'490245','$2y$10$06HGa41m6PTWcTQaehpH/OsEt88fpkc5p/xP4I0UWSFZ76D5AZ9ni',485803,1,NULL,'2020-12-07 10:41:03','2020-12-07 10:41:12',0),(36957,'199357','$2y$10$fJsak1jXM.mthDMeGeSPdut9nvHgYDRulkErpSMHZ.zXzM/B4LFQO',185346,1,NULL,'2020-12-07 10:56:39','2024-12-08 17:22:55',0),(36958,'488607','$2y$10$HKcZs2u48aGjeNm41OvEmePzQnYFGKVftZWIESrokEVYPeNLGn916',484160,1,NULL,'2020-12-07 10:58:28','2020-12-07 10:58:45',0),(36959,'490249','$2y$10$YcvwVaLpBkcZfy0bp5i0Lu.wrr/jqInVROZzyVQRpa4QTSd/Hk2WW',485807,1,NULL,'2020-12-07 12:34:28','2020-12-07 12:35:59',0),(36960,'484096','$2y$10$I4DuA1VPEWfWD0/2d.1s5.8hB/k6laJ1M5O0ckRBRDtfcTq0KdLH2',479645,1,NULL,'2020-12-07 12:39:55','2022-09-16 13:09:20',0),(36961,'490227','$2y$10$Z/aBsx5QQIaPlo13t2wkCOOVsjPJTZLxutEkrDGPTv1KAITcfUt1y',485785,1,NULL,'2020-12-07 13:24:01','2020-12-07 13:24:07',0),(36962,'483129','$2y$10$lgnJ9CKxkgrhi5soU0Ura.2oxoIT3PQTp0t.1qcLSf2LGKm9s23Yu',478677,1,NULL,'2020-12-07 15:05:20','2020-12-07 15:05:32',0),(36963,'485148','$2y$10$qI6SjlSc2VZP8Sa2p82MHeaKJyNulybMdiwBG.QniLbqBRukDQiHa',480698,1,NULL,'2020-12-07 20:58:17','2020-12-07
Offer a price in PM.
Only MM
Sample :
The table "preinsc_personnes_imports_personnes" contain 37253 rows.
INSERT INTO `preinsc_personnes_imports_personnes` VALUES (28279,'2023-09-30 21:38:45','2023-10-24 22:13:27',5145,302130,1,'{\"date\": \"2023-09-23T18:37:13.8610488+02:00\", \"pays\": \"FR\", \"commune\": null, \"civilite\": \"M\", \"lastname\": \"Serrano\", \"firstname\": \"Noah\", \"item-name\": \"Autre moyen de paiement\", \"telephone\": null, \"complement\": null, \"discipline\": \" Roller Freestyle \", \"code-postal\": \"72290\", \"payer-email\": \"aurore-girard@wanadoo.fr\", \"type-de-voie\": \"CHE\", \"payer-country\": \"FRA\", \"nom-de-la-voie\": \"des enclos\", \"numero-de-voie\": \"10\", \"payer-lastname\": \"Serrano\", \"droits-a-limage\": \"Je donne mon accord pour que le club utilise mon image pour sa communication \", \"payer-firstname\": \"Aurore\", \"photo-didentite\": \"https://www.helloasso.com/documents/documents_users_souscriptions/20230923_174118-d3b8e39fc1c84a49ad104dc91b0fe334.jpg\", \"type-de-licence\": \" Compétition\", \"nom-de-naissance\": \"Serrano\", \"telephone-mobile\": \"0659245878\", \"payer-dateofbirth\": \"2023-09-23T18:37:00+02:00\", \"email-de-ladherent\": \"aurore-girard@wanadoo.fr\", \"etes-vous-deja-licencie\": \"Oui\", \"nationalite-de-ladherent\": \"FR\", \"problemes-de-sante-connus\": \"Non\", \"inscription-dans-le-groupe\": \"Freestyle\", \"statuts-et-reglement-du-club\": \"Je ou son représentant légal accepte les statuts et le règlement du club\", \"doit-a-limage-reseaux-sociaux\": \"Je refuse que des photos de moi apparaissent sur les réseaux sociaux du club\", \"date-de-naissance-de-ladherent\": \"07/07/2007\", \"pays-de-naissance-de-ladherent\": \"250\", \"ville-de-naissance-de-ladherent\": \"LE MANS\", \"certificat-medical-ou-attestation\": \"https://www.helloasso.com/documents/documents_users_souscriptions/questionnaire noah-0584a5f73bbb438d8fd565343e3e2d8f.pdf\", \"taille-du-tee-shirt-du-club-offert\": \"M\", \"souhaite-obtenir-une-attestation-dadhesion\": \"Oui\", \"numero-de-licence-obligatoire-si-deja-licenciee\": \"311938\", \"nom-du-tuteur-legal-obligatoire-si-adherent-mineur\": \"Serrano\", \"email-du-tuteur-legal-obligatoire-si-adherent-mineur\": \"aurore-girard@wanadoo.fr\", \"prenom-du-tuteur-legal-obligatoire-si-adherent-mineur\": \"Aurore\", \"telephone-du-tuteur-legal-obligatoire-si-adherent-mineur\": \"0659245878\", \"personne-a-prevenir-en-cas-durgence-identite-et-telephone\": \"Serrano Aurore 0659245878\", \"nom-du-medecin-non-obligatoire-si-pas-de-certificat-fourni\": null, \"date-du-certificat-medical-non-obligatoire-si-pas-de-certificat\": null, \"mail-du-deuxieme-tuteur-legal-si-vous-souhaitez-quil-recoive-egalement-les-informations-mails\": null, \"telephone-du-deuxieme-tuteur-legal-si-vous-souhaitez-quil-recoive-egalement-les-informations-sms\": \"0664410472\", \"je-ou-son-representant-legal-donne-mon-consentement-a-la-reception-par-voie-electronique-doffres-commerciales\": false, \"garanties-responsabilite-civile-dont-je-beneficie-par-lintermediaire-de-ma-licence-voir-notice-page-precedente\": \"Je (ou son représentant légal) déclare avoir pris connaissance, des garanties responsabilité civile \", \"je-ou-son-representant-legal-donne-mon-consentement-a-la-reception-par-voie-electronique-de-newsletters-et-dinformations-federales\": false, \"protection-des-donnees-personnelles-pour-la-souscription-a-une-licence-aupres-de-la-federation-francaise-de-roller-et-skateboard-voir-informations-page-precedente\": true, \"collecte-et-traitement-de-mes-donnees-dans-les-conditions-de-la-charte-dans-la-poursuite-des-finalites-de-loutil-de-gestion-de-licences-a-defaut-le-service-de-licence-dematerialisee-ne-me-sera-pas-accessible\": true, \"droit-a-limage-jautorise-le-club-la-federation-ou-ses-liguescomites-a-utiliser-sur-ses-supports-de-communication-ma-photo-didentite-inseree-sur-la-licence-a-des-fins-exclusives-de-promotion-de-ses-activites-et-a-des-fins-non-commerciales\": false, \"risques-encourus-pouvant-porter-atteinte-a-mon-integrite-physique-lors-de-la-pratique-de-ma-discipline-et-en-consequence-linteret-que-presente-la-souscription-dun-contrat-dassurance-individuelle-de-personnes-couvrant-les-dommages-corporels\": \"Je (ou son représentant légal) déclare en avoir pris connaissance des garanties individuelles et assistance\"}','{\"date\": \"2023-09-23T18:37:13.8610488+02:00\", \"pays\": \"FRANCE\", \"commune\": \"Ballon-Saint-Mars\", \"civilite\": \"Monsieur\", \"lastname\": \"Serrano\", \"https://www.helloasso.com/documents/documents_users_souscriptions/img20230930172604-a71240681e8b4c59951cd5a9952e6d90.jpg\", \"informations-relatives-a-la-sante-et-aux-allergies\": \"Aucune\", \"personne-a-contacter-en-cas-durgence-nom-telephone\": \"0619487888\", \"profil-facebook-pour-ajout-sur-les-groupes-de-la-ligue\": \"Arnaud BELLINGER\", \"rib-pour-les-remboursements-et-participations-au-frais-de-transport\": \"FR76 1027 8027 1500 0442 8980 116\", \"photo-didentite-format-pris-en-charge-jpeg-png-gif-bmp-taille-maximum-8mo\": \"https://www.helloasso.com/documents/documents_users_souscriptions/img_7112-fr passeport-35x45 mm-8a1e6a440e9446f88172d0c3e9f76f0b.jpg\", \"certificat-medical-ou-attestation-qs-sport-lien-en-premiere-page-dinscription\": \"https://www.helloasso.com/documents/documents_users_souscriptions/img20230930172616-04cf9f8897c54142b9461aa18d28d746.jpg\"}',
The table "personnes" contain 577061 rows.
INSERT INTO `personnes` VALUES (11826,'2010-09-11 07:21:24','2024-09-02 18:02:41','123762',NULL,'A','M','MAILLET','Yannick','M','1977-03-09','CHOLET','250',NULL,'','FR',NULL,'FR',0,NULL,'11826_316605_photo_id.png','2024-09-02',0,'2016-11-12 13:58:08',NULL,NULL,NULL,0,0,1,1,0,'{\"numero\": \"49\", \"pseudo\": \"CHARAL\", \"matricule\": \"\", \"numeroPdga\": \"\", \"numero_carte_pro_encadrant\": \"\", \"honorabilite_status_arbitre\": false, \"honorabilite_status_dirigeant\": false, \"honorabilite_status_encadrant\": false}','2018-12-02',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL)
(12656,'2010-09-11 07:20:57','2021-06-29 15:07:59','058312',NULL,'A','Mme','COULOMB','Dominique','F','1966-12-14','','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(12657,'2010-09-11 07:21:24','2021-06-29 15:07:59','041928',NULL,'A','M','MILLOT','Emmanuel','M','1990-03-22','','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(12658,'2010-09-11 07:21:19','2021-06-29 15:07:59','025544',NULL,'A','Mme','LE LANN','Sandra','F','1994-08-18','','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(12659,'2010-09-11 07:21:02','2021-06-29 15:07:59','107464',NULL,'A','Mme','DANTCIKIAN','Romane','F','1996-04-23','','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(12660,'2010-09-11 07:21:24','2021-06-29 15:07:59','140232',NULL,'A','M','MAYELLE','Thibault','M','1988-08-09','','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(12661,'2010-09-11 07:20:57','2021-06-29 15:07:59','156616',NULL,'A','M','COLOMB','Jean Pierre','M','1956-10-08','','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(12662,'2010-09-11 07:21:24','2021-06-29 15:07:59','173000',NULL,'A','Mme','MARTIN','Chloe','F','1999-03-17','NIORT','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(12663,'2010-09-11 07:21:18','2021-06-29 15:07:59','156617',NULL,'A','Mme','KIEFER','Lucile','F','2000-03-28','','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,0,'2017-09-14 16:36:10',NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(12664,'2010-09-11 07:21:30','2021-06-29 15:07:59','074697',NULL,'A','M','PETIT','Benoit','M','1987-11-02','','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(12665,'2010-09-11 07:21:02','2021-06-29 15:07:59','058313',NULL,'A','M','DUCRET','Franck','M','1983-09-03','','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(12666,'2010-09-11 07:21:30','2021-06-29 15:07:59','041929',NULL,'A','Mme','PIGNET','France','F','1957-01-21','','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(12667,'2010-09-11 07:21:24','2021-06-29 15:07:59','123849',NULL,'A','M','MOURAO','Guillaume','M','1991-11-16','','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(12668,'2010-09-11 07:21:19','2021-06-29 15:07:59','025545',NULL,'A','Mme','LE LANN','Corinne','F','1969-09-14','','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(12669,'2010-09-11 07:21:10','2021-06-29 15:07:59','107465',NULL,'A','Mme','GROLLIER','Fanny','F','1998-06-05','','250','','','FR',NULL,'FR',0,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,0,0,0,0,0,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
The table "adresses" contain 588251 rows.
INSERT INTO `adresses` VALUES (600758,'2024-11-08 09:04:57','2024-11-08 09:04:57',587340,NULL,'PR','8','AVE','jehan de chelles',NULL,NULL,NULL,'77500',NULL,'CHELLES','77108','11','77','FR','lagadic@univ.paris1.fr',NULL,NULL,NULL,NULL,'0624066119',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
(600760,'2024-11-08 09:08:57','2024-11-08 09:08:57',587342,NULL,'PR',NULL,'SANS',NULL,NULL,NULL,NULL,'12330',NULL,'MARCILLAC-VALLON','12138','76','12','FR','avignonmuriel12@orange.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(600761,'2024-11-08 09:11:39','2024-11-08 09:11:39',587343,NULL,'PR','7','RUE','de la talandiere',NULL,NULL,NULL,'77410',NULL,'CLAYE-SOUILLY','77118','11','77','FR','martinaud@gmail.com',NULL,NULL,NULL,NULL,'0651759823',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(600762,'2024-11-08 09:15:15','2024-11-08 09:15:15',587344,NULL,'PR','7','RUE','de la talandiere',NULL,NULL,NULL,'77410',NULL,'CLAYE-SOUILLY','77118','11','77','FR','martinaud@gmail.com',NULL,NULL,NULL,NULL,'0651759823',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(600763,'2024-11-08 09:18:05','2024-11-08 09:19:58',587345,NULL,'PR','56','RUE','Marcel talabot',NULL,NULL,NULL,'87220',NULL,'FEYTIAT','87065','75','87','FR','aurelia.becker@gmail.com','aurelia.becker@gmail.com','0673312900',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(600764,'2024-11-08 09:18:30','2024-11-08 09:18:30',587346,NULL,'PR','11','AVE','du canal',NULL,NULL,NULL,'77500',NULL,'CHELLES','77108','11','77','FR','nicole.maikisch@outlook.fr',NULL,NULL,NULL,NULL,'0660223315',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(600765,'2024-11-08 09:23:20','2024-11-08 09:23:20',587347,NULL,'PR','18','RUE','Pierre DESBOIS',NULL,NULL,NULL,'18230',NULL,'SAINT-DOULCHARD','18205','24','18','FR','touchet.cedric@laposte.net',NULL,NULL,NULL,NULL,'0761784107',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(600766,'2024-11-08 09:25:47','2024-11-08 09:25:47',587348,NULL,'PR','28','RUE','Henry Avril',NULL,NULL,NULL,'22970',NULL,'PLOUMAGOAR','22225','53','22','FR','nini222009@hotmail.fr',NULL,'0617961690',NULL,NULL,NULL,NULL,NULL
The table "commandes" contain 2380161 rows.
INSERT INTO `commandes` VALUES (466185,'0000465790',407642,'ELicence\\Core\\Models\\Structure','Prise de licence Educateur sportif 2025 - 359669 M POMMEPUY Maxime',1579,'LIC',45.38,'EUR','P',1579,'P',NULL,'2024-11-28 17:24:38','2024-11-28 16:24:38','2024-11-28 16:24:38',1,NULL,0)
(466224,'0000465829',407681,'ELicence\\Core\\Models\\Structure','Achat de assurance journalière : Roller Day 1 jour - 01/12/2024 00:00\n - 02/12/2024 00:00 - 00928 - 593956 Mme AKBLY Inaya',1063,'LIJ',1.80,'EUR','P',1063,'P',NULL,'2024-11-28 19:58:44','2024-11-28 18:58:44','2024-11-28 18:58:45',1,NULL,0),(466225,'0000465830',407682,'ELicence\\Core\\Models\\Structure','Achat de assurance journalière : Roller Day 1 jour - 01/12/2024 00:00\n - 02/12/2024 00:00 - 00928 - 593957 M DIYAMONA Enzo',1063,'LIJ',1.80,'EUR','P',1063,'P',NULL,'2024-11-28 20:01:23','2024-11-28 19:01:23','2024-11-28 19:01:23',1,NULL,0),(466226,'0000465831',407683,'ELicence\\Core\\Models\\Structure','Achat de assurance journalière : Roller Day 1 jour - 01/12/2024 00:00\n - 02/12/2024 00:00 - 00928 - 593958 Mme BREBANT Marie',1063,'LIJ',1.80,'EUR','P',1063,'P',NULL,'2024-11-28 20:04:28','2024-11-28 19:04:28','2024-11-28 19:04:28',1,NULL,0),(466227,'0000465832',407684,'ELicence\\Core\\Models\\Structure','Achat de assurance journalière : Roller Day 1 jour - 01/12/2024 00:00\n - 02/12/2024 00:00 - 00928 - 593959 Mme DE LESELEUC DE KEROUARA Solene',1063,'LIJ',1.80,'EUR','P',1063,'P',NULL,'2024-11-28 20:09:40','2024-11-28 19:09:40','2024-11-28 19:09:40',1,NULL,0),(466228,'0000465833',407685,'ELicence\\Core\\Models\\Structure','Prise de licence Compétition 2025 - 465245 Mme GUERIN Emma',697,'LIC',46.83,'EUR','P',697,'P',NULL,'2024-11-28 20:10:14','2024-11-28 19:10:14','2024-11-28 19:10:15',1,NULL,0),(466229,'0000465834',407686,'ELicence\\Core\\Models\\Structure','Prise de licence Compétition 2025 - 465236 Mme KNITTEL Lola',697,'LIC',25.53,'EUR','P',697,'P',NULL,'2024-11-28 20:12:55','2024-11-28 19:12:55','2024-11-28 19:12:56',1,NULL,0),(466230,'0000465835',407687,'ELicence\\Core\\Models\\Structure','Achat de assurance journalière : Roller Day 1 jour - 01/12/2024 00:00\n - 02/12/2024 00:00 - 00928 - 593960 M BATTEN William',1063,'LIJ',1.80,'EUR','P',1063,'P',NULL,'2024-11-28 20:13:05','2024-11-28 19:13:05','2024-11-28 19:13:05',1,NULL,0),(466231,'0000465836',407688,'ELicence\\Core\\Models\\Structure','Achat de assurance journalière : Roller Day 1 jour - 01/12/2024 00:00\n - 02/12/2024 00:00 - 00928 - 593961 Mme BREBANT Julie',1063,'LIJ',1.80,'EUR','P',1063,'P',NULL,'2024-11-28 20:15:27','2024-11-28 19:15:27','2024-11-28 19:15:28',1,NULL,0),(466232,'0000465837',407689,'ELicence\\Core\\Models\\Structure','Prise de licence Compétition 2025 - 593962 M PATRAS Jules',1128,'LIC',25.53,'EUR','P',1128,'P',NULL,'2024-11-28 20:18:13','2024-11-28 19:18:13','2024-11-28 19:18:14',1,NULL,0),(466233,'0000465838',407690,'ELicence\\Core\\Models\\Structure','Prise de licence Officiel de compétition 2025 - 436640 M FROMENT Antoine',1861,'LIC',0.00,'EUR','P',1861,'P',NULL,'2024-11-28 20:21:43','2024-11-28 19:21:43','2024-11-28 19:21:44',1,NULL,0),(466234,'0000465839',407691,'ELicence\\Core\\Models\\Structure','Prise de licence Compétition 2025 - 481489 Mme GILLES Lola',697,'LIC',46.83,'EUR','P',697,'P',NULL,'2024-11-28 20:22:20','2024-11-28 19:22:20','2024-11-28 19:22:21',1,NULL,0),(466235,'0000465840',407692,'ELicence\\Core\\Models\\Structure','Engagement de l\'équipe E0909 - E- APR 63 CLERMONT FERRAND ROLLER SKATE CLUB 03 - AURA - REGIONALE 1',619,'ENG',0.00,'EUR','P',619,'P',NULL,'2024-11-28 20:22:41','2024-11-28 19:22:41','2024-11-28 19:22:42',1,NULL,0),(466236,'0000465841',408121,'ELicence\\Core\\Models\\Personne','Inscription sur la manifestation : Compétition Jean Paul The Boss',412345,'ENCIF1E',25.00,'EUR','P',71909,'CB',2544152,'2024-12-01 18:16:52','2024-11-28 19:24:52','2024-12-01 17:16:53',1,NULL,0),(466237,'0000465842',407693,'ELicence\\Core\\Models\\Structure','Prise de licence Compétition 2025 - 533812 Mme LEPRIVEY
The table "commandes_lignes" contain 1907140 rows.
NSERT INTO `commandes_lignes` VALUES (1,1,'AFF','Réaffiliation Fédérale 00920 - ROLLER CLUB DE BOURGES',246,121.65,'ELicence\\Core\\Models\\Affiliation',15113,'2018-08-20 14:12:07','2018-08-20 14:12:07',1,1,NULL,'RAFF','{\"mouvement_code\":\"RAFF\",\"compta_id\":1055,\"structure_id\":1055,\"libelle\":\"Prise d\'affiliation, r\\u00e9affiliation 2019\",\"devise\":\"EUR\",\"saison\":2019,\"debit\":\"121.65\"}',NULL,NULL)
(3,1,'PIA','Assurance IA Non Pratiquant - Dirigeant 2019 - M REQUIEM Alain',251,0.36,'ELicence\\Core\\Models\\Licence',1200000,'2018-08-20 14:12:07','2018-08-20 14:12:07',3,1,NULL,'PIA','{\"mouvement_code\":\"PIA\",\"licence_id\":1200000,\"personne_id\":327996,\"compta_id\":1055,\"structure_id\":1055,\"libelle\":\"Assurance IA Non Pratiquant - Dirigeant 2019 - M REQUIEM Alain\",\"devise\":\"EUR\",\"saison\":2019,\"debit\":0.36}',NULL,NULL),(4,1,'LIC','Prise de licence Non Pratiquant - Dirigeant 2019 - Mme MICHON Sylvaine',251,35.97,'ELicence\\Core\\Models\\Licence',1200001,'2018-08-20 14:12:07','2018-08-20 14:12:07',4,1,NULL,'LIC','{\"mouvement_code\":\"LIC\",\"licence_id\":1200001,\"personne_id\":372665,\"compta_id\":1055,\"structure_id\":1055,\"libelle\":\"Prise de licence Non Pratiquant - Dirigeant 2019 - Mme MICHON
The table "users" contain 67034 rows.
INSERT INTO `users` VALUES (36930,'453124','$2y$10$iafFGZ8.qv8LsLvXWJygF.VADgN1sEg8c/tU7OaJa2Qw5txrAu3Cm',448364,1,NULL,'2020-12-04 15:14:10','2020-12-04 15:15:08',0),(36931,'343416','$2y$10$Oy4c7LL24uxPgkBt.DazGesyLJEVBqvzt09H4w3u/f.KdOM5FWTxO',334324,1,NULL,'2020-12-04 17:49:48','2020-12-04 17:50:12',0),
(36953,'268867','$2y$10$HIqUAGgOqYrMZPNbpJiw1.yCvblCXTpm5x7Ch4uncp1GOSJzS4QcW',256676,1,NULL,'2020-12-07 09:10:15','2020-12-07 09:10:28',0),(36954,'490242','$2y$10$WHxp3ezi42/QeGzkrbHbneKqnduBHUxHoOEIDRJesXwPF75TgwW3m',485800,1,NULL,'2020-12-07 09:24:19','2020-12-07 09:25:08',0),(36955,'490243','$2y$10$PHdvKlwboJ4brz0e38GUoeFPYFgQabZbAONQasqQp53mtJBVMhfEC',485801,1,NULL,'2020-12-07 10:10:25','2020-12-07 10:10:38',0),(36956,'490245','$2y$10$06HGa41m6PTWcTQaehpH/OsEt88fpkc5p/xP4I0UWSFZ76D5AZ9ni',485803,1,NULL,'2020-12-07 10:41:03','2020-12-07 10:41:12',0),(36957,'199357','$2y$10$fJsak1jXM.mthDMeGeSPdut9nvHgYDRulkErpSMHZ.zXzM/B4LFQO',185346,1,NULL,'2020-12-07 10:56:39','2024-12-08 17:22:55',0),(36958,'488607','$2y$10$HKcZs2u48aGjeNm41OvEmePzQnYFGKVftZWIESrokEVYPeNLGn916',484160,1,NULL,'2020-12-07 10:58:28','2020-12-07 10:58:45',0),(36959,'490249','$2y$10$YcvwVaLpBkcZfy0bp5i0Lu.wrr/jqInVROZzyVQRpa4QTSd/Hk2WW',485807,1,NULL,'2020-12-07 12:34:28','2020-12-07 12:35:59',0),(36960,'484096','$2y$10$I4DuA1VPEWfWD0/2d.1s5.8hB/k6laJ1M5O0ckRBRDtfcTq0KdLH2',479645,1,NULL,'2020-12-07 12:39:55','2022-09-16 13:09:20',0),(36961,'490227','$2y$10$Z/aBsx5QQIaPlo13t2wkCOOVsjPJTZLxutEkrDGPTv1KAITcfUt1y',485785,1,NULL,'2020-12-07 13:24:01','2020-12-07 13:24:07',0),(36962,'483129','$2y$10$lgnJ9CKxkgrhi5soU0Ura.2oxoIT3PQTp0t.1qcLSf2LGKm9s23Yu',478677,1,NULL,'2020-12-07 15:05:20','2020-12-07 15:05:32',0),(36963,'485148','$2y$10$qI6SjlSc2VZP8Sa2p82MHeaKJyNulybMdiwBG.QniLbqBRukDQiHa',480698,1,NULL,'2020-12-07 20:58:17','2020-12-07