07-31-2025, 02:40 PM
Hello, Today i'm selling the database (full sql dump not scrap) of the Fédération Française de Force.
Offer a price in PM.
Only MM
Sample :
The table "adresses" contain 61936 rows.
INSERT INTO `adresses` VALUES (52867,'2023-09-11 20:09:14','2023-09-11 20:09:14',50670,NULL,'PR',NULL,'SANS',NULL,NULL,NULL,NULL,'57500',NULL,'SAINT-AVOLD','57606','44','57','FR','theo.aitsia@gmail.com',NULL,'0603402390',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52868,'2023-09-11 21:04:39','2023-09-11 21:04:39',50671,NULL,'PR',NULL,'SANS',NULL,NULL,NULL,NULL,'67117',NULL,'QUATZENHEIM','
(52876,'2023-09-12 10:06:22','2023-09-12 10:06:22',50679,NULL,'PR',NULL,'SANS',NULL,NULL,NULL,NULL,'33620',NULL,'CÉZAC','33123','75','33','FR','contact@teamff33.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52877,'2023-09-12 10:08:11','2023-09-12 10:08:11',50680,NULL,'PR',NULL,'SANS',NULL,NULL,NULL,NULL,'33240',NULL,'SAINT-ANDRÉ-DE-CUBZAC','33366','75','33','FR','contact@teamff33.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52878,'2023-09-12 10:09:14','2023-09-12 10:09:14',50681,NULL,'PR',NULL,'SANS',NULL,NULL,NULL,NULL,'33240',NULL,'SAINT-ANDRÉ-DE- 10:20:17',50685,NULL,'PR',NULL,'SANS',NULL,NULL,NULL,NULL,'33390',NULL,'BERSON','33047','75','33','FR','contact@teamff33.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52883,'2023-09-12 10:27:47','2023-09-12 10:27:47',50686,NULL,'PR',NULL,'SANS',NULL,NULL,NULL,NULL,'81600',NULL,'TÉCOU','81294','76','81','FR','jousselme.c@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52884,'2023-09-12 10:30:36','2024-12-04 18:20:44',50687,NULL,'PR','7','ALL','DES BOULEAUX',NULL,NULL,NULL,'51800',NULL,'SAINTE-MENEHOULD','51507','44','51','FR','Ethanhuyet8@gmail.com','Ethanhuyet7@gmail.com','0667781150',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52885,'2023-09-12 11:11:17','2023-09-12 11:11:17',NULL,NULL,'MAN',NULL,'RUE','DU 8 MAI','Gymnase du Parc de Londres',NULL,NULL,
(44848,'2022-04-04 12:40:54','2022-09-23 12:38:29',43256,NULL,'PR','15','RUE','hondet',NULL,NULL,NULL,'13004',NULL,'MARSEILLE','13055','93','13','FR','khalil.hajal110@gmail.com',NULL,'0762640780',NULL,NULL,'0762640780',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
The table "commandes_lignes" contain 100289 rows.
INSERT INTO `commandes_lignes` VALUES (63162,'2023-11-08 08:34:46','2023-11-08 08:34:46',32559,'PIA','Assurance IA Loisir 2023 - Mme FINO Josette',39,NULL,0.35,'ELicence\\Core\\Models\\Licence',157522,70514,0,NULL,'PIA','{\"mouvement_code\":\"PIA\",\"licence_id\":157522,\"personne_id\":45014,\"compta_id\":344,\"structure_id\":344,\"libelle\":\"Assurance IA Loisir 2023 - Mme FINO Josette\",\"devise\":\"EUR\",\"saison\":2023,\"debit\":0.35}',NULL)
The table "commandes_paiements_logs" contain 15899 rows.
INSERT INTO `commandes_paiements_logs` VALUES (2241,'2023-04-28 23:30:35','2023-04-28 23:30:35','20230428232822','00','23539','004290','[23410]','5','77.205.40.43','Mozilla/5.0 (iPhone; CPU iPhone OS 16_1_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.1 Mobile/15E148 Safari/604.1','GET','49840e7298f94b5d87ac7a41a303edbc','{\"vads_tid\": \"001\", \"signature\": \"e39fdbb5c55393e70c6f8740159a8d2a5648e769\", \"vads_amount\": \"500\", \"vads_result\": \"00\", \"vads_cust_id\": \"048539\", \"vads_pays_ip\": \"FR\", \"vads_site_id\": \"23868048\", \"vads_version\": \"V2\", \"vads_ctx_mode\": \"PRODUCTION\", \"vads_currency\": \"978\", \"vads_language\": \"fr\", \"vads_order_id\": \"23539\", \"vads_trans_id\": \"004290\", \"vads_auth_mode\": \"FULL\", \"vads_bank_code\": \"17807\", \"vads_cust_name\": \"Theo LEDEUX\", \"vads_bank_label\": \"Banque Populaire Occitane\",
\"vads_threeds_cavvAlgorithm\": null, \"vads_effective_creation_date\": \"20230429055339\", \"vads_initial_issuer_transaction_identifier\": \"1310220084488825\"}'),(2250,'2023-04-29 06:20:06','2023-04-29 06:20:06','20230429061918','00','23544','004305','[23415]','5','194.50.38.6','Lyra-Network Agent','POST','59e42583d1e349608d9670db66c934a0','{\"vads_tid\": \"001\", \"signature\": \"6fbf87015724ac03e884fc67da03ecdd133ff316\", \"vads_hash\": \"914f15b8b6bee2073e626f40f832ecc025af87c0c9b7e60f765286d86a1ec0c8\", \"vads_amount\": \"500\", \"vads_result\": \"00\", \"vads_cust_id\": \"037938\", \"vads_pays_ip\": \"FR\", \"vads_site_id\": \"23868048\", \"vads_version\": \"V2\", \"vads_ctx_mode\": \"PRODUCTION\", \"vads_currency\": \"978\", \"vads_language\": \"fr\", \"vads_order_id\": \"23544\", \"vads_trans_id\": \"004305\", \"vads_auth_mode\": \"FULL\", \"vads_bank_code\": \"13306\", \"vads_cust_name\": \"Sourbets MAXIME\", \"vads_bank_label\": \"Caisse régionale de crédit agricole mutuel d\'Aquitaine\", \"vads_card_brand\": \"CB\", \"vads_cust_email\": \"sourbets.maxime@gmail.com\", \"vads_trans_date\": \"20230429061918\", \"vads_trans_uuid\": \"59e42583d1e349608d9670db66c934a0\", \"vads_action_mode\": \"INTERACTIVE\", \"vads_auth_number\": \"809170\", \"vads_auth_result\": \"00\", \"vads_card_nature\": \"CONSUMER\", \"vads_card_number\": \"453314XXXXXX6386\", \"vads_cust_status\": \"PRIVATE\", \"vads_expiry_year\": \"2025\", \"vads_page_action\": \"PAYMENT\", \"vads_payment_src\": \"EC\", \"vads_threeds_eci\": \"05\", \"vads_threeds_xid\": null, \"vads_bank_product\": \"F\", \"vads_card_country\": \"FR\", \"vads_expiry_month\": \"10\", \"vads_extra_result\": null, \"vads_threeds_cavv\": \"AAgACCCSBAAAI2JQhZIEAAAAAAA=\", \"vads_trans_status\": \"AUTHORISED\", \"vads_capture_delay\": \"0\", \"vads_contract_used\": \"3122295\", \"vads_url_check_src\": \"PAY\", \"vads_cust_last_name\": \"MAXIME\", \"vads_operation_type\": \"DEBIT\", \"vads_payment_config\": \"SINGLE\", \"vads_threeds_status\": \"Y\", \"vads_cust_first_name\": \"Sourbets\", \"vads_cust_legal_name\": null, \"vads_occurrence_type\": \"UNITAIRE\", \"vads_sequence_number\": \"1\", \"vads_validation_mode\": \"0\", \"vads_warranty_result\": \"YES\", \"vads_acquirer_network\": \"CB\", \"vads_brand_management\": \"{\\\"userChoice\\\":false,\\\"brandList\\\":\\\"CB|VISA\\\",\\\"brand\\\":\\\"CB\\\"}\", \"vads_effective_amount\": \"500\", \"vads_threeds_enrolled\": \"Y\", \"vads_presentation_date\": \"20230429061918\", \"vads_threeds_auth_type\": \"CHALLENGE\", \"vads_effective_currency\": \"978\", \"vads_threeds_error_code\": null, \"vads_threeds_sign_valid\": null, \"vads_payment_certificate\": \"a5dac0ae3d51574a6c87b249734be70d83794259\", \"vads_threeds_exit_status\": \"10\", \"vads_archival_reference_id\": \"L11900430501\", \"vads_card_product_category\": \"CREDIT\", \"vads_threeds_cavvAlgorithm\": null, \"vads_effective_creation_date\": \"20230429061918\", \"vads_initial_issuer_transaction_identifier\": \"10640E4262313649\"}'),(2251,'2023-04-29 06:20:16','2023-04-29 06:20:16','20230429061918','00','23544','004305','[23415]','5','176.156.236.252','Mozilla/5.0 (Linux; Android 13; Pixel 6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Mobile Safari/537.36','GET','59e42583d1e349608d9670db66c934a0','{\"vads_tid\": \"001\", \"signature\": \"3673fdb13aed809f67f736cda7ea640851e33de1\", \"vads_amount\": \"500\", \"vads_result\": \"00\", \"vads_cust_id\": \"037938\", \"vads_pays_ip\": \"FR\", \"vads_site_id\": \"23868048\", \"vads_version\": \"V2\", \"vads_ctx_mode\": \"PRODUCTION\", \"vads_currency\": \"978\", \"vads_language\": \"fr\", \"vads_order_id\": \"23544\", \"vads_trans_id\": \"004305\", \"vads_auth_mode\": \"FULL\", \"vads_bank_code\": \"13306\", \"vads_cust_name\": \"Sourbets MAXIME\", \"vads_bank_label\": \"Caisse régionale de crédit agricole mutuel d\'Aquitaine\", \"vads_card_brand\": \"CB\", \"vads_cust_email\": \"sourbets.maxime@gmail.com\", \"vads_trans_date\": \"20230429061918\",
The table "personnes" contain 64512 rows.
INSERT INTO `personnes` VALUES (38569,'2020-10-05 13:01:28','2024-10-24 08:42:54','038486',NULL,'A','M','MURCY','Jonathan','M','2002-08-23',NULL,'250',NULL,'','FR',NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,1,1,'{\"numero\": \"\", \"pseudo\": \"\", \"matricule\": \"\", \"numeroPdga\": \"\", \"numero_carte_pro_encadrant\": \"\", \"honorabilite_status_arbitre\": false, \"honorabilite_status_dirigeant\": false, \"honorabilite_status_encadrant\": false}','2020-10-05',NULL,NULL,NULL,35,'34',15969,'
(38603,'2020-10-06 09:47:59','2022-08-04 06:46:39','038519',NULL,'A','M','GENEIX','Valerie','M','1968-12-03',NULL,'250',NULL,'','FR',NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,'{\"numero\": \"\", \"pseudo\": \"\", \"matricule\": \"\", \"numero_carte_pro_encadrant\": \"\"}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','fb2a18f5-9f03-458a-98aa-8cb88e3f152c',0,NULL),(38604,'2020-10-06 09:49:10','2024-10-24 08:42:54','038520',NULL,'A','Mme','PAL','Sovannphaktra','F','1991-04-24',NULL,'250',NULL,NULL,'FR',NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'{\"numero\": \"\", \"pseudo\": \"\", \"matricule\": \"\", \"numeroPdga\": \"\", \"numero_carte_pro_encadrant\": \"\", \"honorabilite_status_arbitre\": false, \"honorabilite_status_dirigeant\": false, \"honorabilite_status_encadrant\": false}','2020-10-06',NULL,NULL,NULL,79,'78',38209,'78646',NULL,'649e2a05-5a7a-4875-8c99-100a6979d17c',0,NULL),(38605,'2020-10-06 10:48:53','2024-11-14 09:20:01','038521',NULL,'I','Mme','MILLECAMPS','Kelly','F','1998-07-25',NULL,NULL,NULL,'','FR',NULL,NULL,0,NULL,0,NULL,'DpQ26KqHYqM7wk1isECaNHqFQUUIDvnoeovyt0sQ.jpeg',NULL,NULL,NULL,NULL,0,0,1,1,0,'{\"numero\": \"\", \"pseudo\": \"\", \"matricule\": \"\", \"numeroPdga\": \"\", \"numero_carte_pro_encadrant\": \"\"}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'97d4b1e2-e2d2-46cb-8c94-094e2f180ab0',0,NULL),(38606,'2020-10-06 12:11:30','2024-10-24 08:42:54','038522',NULL,'A','M','OUDART','Antoine','M','1999-04-07',NULL,'250',NULL,NULL,'FR',NULL,NULL,0,NULL,0,NULL,'38606_779953_photo_id.png',NULL,NULL,NULL,NULL,1,0,1,1,0,'{\"numero\": \"\", \"pseudo\": \"\", \"matricule\": \"\", \"numeroPdga\": \"\", \"numero_carte_pro_encadrant\": \"\", \"honorabilite_status_arbitre\": false, \"honorabilite_status_dirigeant\": false, \"honorabilite_status_encadrant\": false}','2020-10-06',NULL,NULL,NULL,60,'59',27659,'59350',NULL,'b090eedd-e32c-4f4a-abdd-ade8727861e3',0,NULL),(38607,'2020-10-06 12:15:48','2023-09-17 18:00:54','038523',NULL,'A','M','MALONGA','Christian','M','1981-11-11',NULL,'250',NULL,'','FR',NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,1,0,'{\"numero\": \"\", \"pseudo\": \"\", \"matricule\": \"\", \"numeroPdga\": \"\", \"numero_carte_pro_encadrant\": \"\", \"honorabilite_status_arbitre\": false, \"honorabilite_status_dirigeant\": false, \"honorabilite_status_encadrant\": false}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'bf550b22-f002-4e0d-9209-260969637684',0,NULL),(38608,'2020-10-06 12:26:27','2022-08-04 06:46:39','038524',NULL,'A','Mme','AUDEBERT','Anais','F','1997-01-24',NULL,'250',NULL,'','FR',NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,0,'{\"numero\": \"\", \"pseudo\": \"\", \"matricule\": \"\", \"numero_carte_pro_encadrant\": \"\"}',NULL,NULL,NULL,NULL,NULL,'',NULL,'',NULL,'2c5d5e09-2dcb-42cc-87d0-45cf7a38ae1f',0,NULL),(38609,'2020-10-06 12:31:40','2022-08-04 06:46:39','038525',NULL,'A','M','DUPUY','Adrien','M','1997-11-14',NULL,'250',NULL,'','FR',NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,0,'{\"numero\": \"\", \"pseudo\": \"\", \"matricule\": \"\", \"numero_carte_pro_encadrant\": \"\"}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','1ba87f73-438f-4a78-a0b5-5413eb647f36',0,NULL),(38610,'2020-10-06 12:45:29','2022-08-04 06:46:39','038526',NULL,'A','Mme','HARDY','Laurycia','F','2000-10-10',NULL,'250',NULL,'','FR',NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,0,'{\"numero\": \"\", \"pseudo\": \"\", \"matricule\": \"\", \"numero_carte_pro_encadrant\": \"\"}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','6c4d13b5-60fc-4110-b846-8296803645d5',0,NULL),(38611,'2020-10-06 12:51:34','2022-08-04 06:46:39','038527',NULL,'A','M','HILLAIRET','Bryan','M','1997-03-27',NULL,'250',NULL,'','FR',NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,0,'{\"numero\": \"\", \"pseudo\": \"\", \"matricule\": \"\", \"numero_carte_pro_encadrant\": \"\"}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','8d53e488-ec13-4d2a-a7d1-ae1c9a959463',0,NULL),(38612,'2020-10-06 14:26:26','2024-10-24 08:42:54','038528',NULL,'A','Mme','LORENZON','Margaux','F','1999-12-14',NULL,'250',NULL,'','FR',NULL,NULL,0,NULL,0,NULL,'38612_387175_photo_id.png',NULL,NULL,NULL,NULL,1,0,1,1,1,'{\"numero\": \"\", \"pseudo\": \"\", \"matricule\": \"\", \"numeroPdga\": \"\", \"numero_carte_pro_encadrant\": \"\", \"honorabilite_status_arbitre\": false, \"honorabilite_status_dirigeant\": false, \"honorabilite_status_encadrant\": false}','2021-11-04',NULL,NULL,NULL,94,'93',42937,'93007',NULL,'513ec1d4-eb14-4981-96df-ad8bda8e0de7',0,NULL),(38613,'2020-10-06 14:50:40','2024-10-24 08:42:54','038529',NULL,'A','M','DUGUÉ','Kévin','M','1990-11-15',NULL,'250',NULL,'','FR',NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,1,1,'{\"numero\": \"\", \"pseudo\": \"\", \"matricule\": \"\", \"numero_carte_pro_encadrant\": \"\"}','2020-10-10',NULL,NULL,NULL,59,'58',27147,'58194',NULL,'4a425d01-ef68-46ba-be70-74a4e70eb091',0,NULL),(38614,'2020-10-06 18:38:54','2024-10-24 08:42:54','038530',NULL,'A','Mme','COMPAN','Thea','F','1996-03-25',NULL,'250',NULL,'','FR',NULL,NULL,0,NULL,0,NULL,'jKzUIhQjdS91cmqcq8JjOkx1miL0fgxv8JsKBNOw.jpeg',NULL,NULL,NULL,NULL,1,0,1,1,0,'{\"numero\": \"\", \"pseudo\": \"\", \"matricule\": \"\", \"numero_carte_pro_encadrant\": \"\"}','2020-10-06',NULL,NULL,NULL,31,'30',13883,'
Offer a price in PM.
Only MM
Sample :
The table "adresses" contain 61936 rows.
INSERT INTO `adresses` VALUES (52867,'2023-09-11 20:09:14','2023-09-11 20:09:14',50670,NULL,'PR',NULL,'SANS',NULL,NULL,NULL,NULL,'57500',NULL,'SAINT-AVOLD','57606','44','57','FR','theo.aitsia@gmail.com',NULL,'0603402390',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52868,'2023-09-11 21:04:39','2023-09-11 21:04:39',50671,NULL,'PR',NULL,'SANS',NULL,NULL,NULL,NULL,'67117',NULL,'QUATZENHEIM','
(52876,'2023-09-12 10:06:22','2023-09-12 10:06:22',50679,NULL,'PR',NULL,'SANS',NULL,NULL,NULL,NULL,'33620',NULL,'CÉZAC','33123','75','33','FR','contact@teamff33.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52877,'2023-09-12 10:08:11','2023-09-12 10:08:11',50680,NULL,'PR',NULL,'SANS',NULL,NULL,NULL,NULL,'33240',NULL,'SAINT-ANDRÉ-DE-CUBZAC','33366','75','33','FR','contact@teamff33.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52878,'2023-09-12 10:09:14','2023-09-12 10:09:14',50681,NULL,'PR',NULL,'SANS',NULL,NULL,NULL,NULL,'33240',NULL,'SAINT-ANDRÉ-DE- 10:20:17',50685,NULL,'PR',NULL,'SANS',NULL,NULL,NULL,NULL,'33390',NULL,'BERSON','33047','75','33','FR','contact@teamff33.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52883,'2023-09-12 10:27:47','2023-09-12 10:27:47',50686,NULL,'PR',NULL,'SANS',NULL,NULL,NULL,NULL,'81600',NULL,'TÉCOU','81294','76','81','FR','jousselme.c@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52884,'2023-09-12 10:30:36','2024-12-04 18:20:44',50687,NULL,'PR','7','ALL','DES BOULEAUX',NULL,NULL,NULL,'51800',NULL,'SAINTE-MENEHOULD','51507','44','51','FR','Ethanhuyet8@gmail.com','Ethanhuyet7@gmail.com','0667781150',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52885,'2023-09-12 11:11:17','2023-09-12 11:11:17',NULL,NULL,'MAN',NULL,'RUE','DU 8 MAI','Gymnase du Parc de Londres',NULL,NULL,
(44848,'2022-04-04 12:40:54','2022-09-23 12:38:29',43256,NULL,'PR','15','RUE','hondet',NULL,NULL,NULL,'13004',NULL,'MARSEILLE','13055','93','13','FR','khalil.hajal110@gmail.com',NULL,'0762640780',NULL,NULL,'0762640780',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
The table "commandes_lignes" contain 100289 rows.
INSERT INTO `commandes_lignes` VALUES (63162,'2023-11-08 08:34:46','2023-11-08 08:34:46',32559,'PIA','Assurance IA Loisir 2023 - Mme FINO Josette',39,NULL,0.35,'ELicence\\Core\\Models\\Licence',157522,70514,0,NULL,'PIA','{\"mouvement_code\":\"PIA\",\"licence_id\":157522,\"personne_id\":45014,\"compta_id\":344,\"structure_id\":344,\"libelle\":\"Assurance IA Loisir 2023 - Mme FINO Josette\",\"devise\":\"EUR\",\"saison\":2023,\"debit\":0.35}',NULL)
The table "commandes_paiements_logs" contain 15899 rows.
INSERT INTO `commandes_paiements_logs` VALUES (2241,'2023-04-28 23:30:35','2023-04-28 23:30:35','20230428232822','00','23539','004290','[23410]','5','77.205.40.43','Mozilla/5.0 (iPhone; CPU iPhone OS 16_1_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.1 Mobile/15E148 Safari/604.1','GET','49840e7298f94b5d87ac7a41a303edbc','{\"vads_tid\": \"001\", \"signature\": \"e39fdbb5c55393e70c6f8740159a8d2a5648e769\", \"vads_amount\": \"500\", \"vads_result\": \"00\", \"vads_cust_id\": \"048539\", \"vads_pays_ip\": \"FR\", \"vads_site_id\": \"23868048\", \"vads_version\": \"V2\", \"vads_ctx_mode\": \"PRODUCTION\", \"vads_currency\": \"978\", \"vads_language\": \"fr\", \"vads_order_id\": \"23539\", \"vads_trans_id\": \"004290\", \"vads_auth_mode\": \"FULL\", \"vads_bank_code\": \"17807\", \"vads_cust_name\": \"Theo LEDEUX\", \"vads_bank_label\": \"Banque Populaire Occitane\",
\"vads_threeds_cavvAlgorithm\": null, \"vads_effective_creation_date\": \"20230429055339\", \"vads_initial_issuer_transaction_identifier\": \"1310220084488825\"}'),(2250,'2023-04-29 06:20:06','2023-04-29 06:20:06','20230429061918','00','23544','004305','[23415]','5','194.50.38.6','Lyra-Network Agent','POST','59e42583d1e349608d9670db66c934a0','{\"vads_tid\": \"001\", \"signature\": \"6fbf87015724ac03e884fc67da03ecdd133ff316\", \"vads_hash\": \"914f15b8b6bee2073e626f40f832ecc025af87c0c9b7e60f765286d86a1ec0c8\", \"vads_amount\": \"500\", \"vads_result\": \"00\", \"vads_cust_id\": \"037938\", \"vads_pays_ip\": \"FR\", \"vads_site_id\": \"23868048\", \"vads_version\": \"V2\", \"vads_ctx_mode\": \"PRODUCTION\", \"vads_currency\": \"978\", \"vads_language\": \"fr\", \"vads_order_id\": \"23544\", \"vads_trans_id\": \"004305\", \"vads_auth_mode\": \"FULL\", \"vads_bank_code\": \"13306\", \"vads_cust_name\": \"Sourbets MAXIME\", \"vads_bank_label\": \"Caisse régionale de crédit agricole mutuel d\'Aquitaine\", \"vads_card_brand\": \"CB\", \"vads_cust_email\": \"sourbets.maxime@gmail.com\", \"vads_trans_date\": \"20230429061918\", \"vads_trans_uuid\": \"59e42583d1e349608d9670db66c934a0\", \"vads_action_mode\": \"INTERACTIVE\", \"vads_auth_number\": \"809170\", \"vads_auth_result\": \"00\", \"vads_card_nature\": \"CONSUMER\", \"vads_card_number\": \"453314XXXXXX6386\", \"vads_cust_status\": \"PRIVATE\", \"vads_expiry_year\": \"2025\", \"vads_page_action\": \"PAYMENT\", \"vads_payment_src\": \"EC\", \"vads_threeds_eci\": \"05\", \"vads_threeds_xid\": null, \"vads_bank_product\": \"F\", \"vads_card_country\": \"FR\", \"vads_expiry_month\": \"10\", \"vads_extra_result\": null, \"vads_threeds_cavv\": \"AAgACCCSBAAAI2JQhZIEAAAAAAA=\", \"vads_trans_status\": \"AUTHORISED\", \"vads_capture_delay\": \"0\", \"vads_contract_used\": \"3122295\", \"vads_url_check_src\": \"PAY\", \"vads_cust_last_name\": \"MAXIME\", \"vads_operation_type\": \"DEBIT\", \"vads_payment_config\": \"SINGLE\", \"vads_threeds_status\": \"Y\", \"vads_cust_first_name\": \"Sourbets\", \"vads_cust_legal_name\": null, \"vads_occurrence_type\": \"UNITAIRE\", \"vads_sequence_number\": \"1\", \"vads_validation_mode\": \"0\", \"vads_warranty_result\": \"YES\", \"vads_acquirer_network\": \"CB\", \"vads_brand_management\": \"{\\\"userChoice\\\":false,\\\"brandList\\\":\\\"CB|VISA\\\",\\\"brand\\\":\\\"CB\\\"}\", \"vads_effective_amount\": \"500\", \"vads_threeds_enrolled\": \"Y\", \"vads_presentation_date\": \"20230429061918\", \"vads_threeds_auth_type\": \"CHALLENGE\", \"vads_effective_currency\": \"978\", \"vads_threeds_error_code\": null, \"vads_threeds_sign_valid\": null, \"vads_payment_certificate\": \"a5dac0ae3d51574a6c87b249734be70d83794259\", \"vads_threeds_exit_status\": \"10\", \"vads_archival_reference_id\": \"L11900430501\", \"vads_card_product_category\": \"CREDIT\", \"vads_threeds_cavvAlgorithm\": null, \"vads_effective_creation_date\": \"20230429061918\", \"vads_initial_issuer_transaction_identifier\": \"10640E4262313649\"}'),(2251,'2023-04-29 06:20:16','2023-04-29 06:20:16','20230429061918','00','23544','004305','[23415]','5','176.156.236.252','Mozilla/5.0 (Linux; Android 13; Pixel 6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Mobile Safari/537.36','GET','59e42583d1e349608d9670db66c934a0','{\"vads_tid\": \"001\", \"signature\": \"3673fdb13aed809f67f736cda7ea640851e33de1\", \"vads_amount\": \"500\", \"vads_result\": \"00\", \"vads_cust_id\": \"037938\", \"vads_pays_ip\": \"FR\", \"vads_site_id\": \"23868048\", \"vads_version\": \"V2\", \"vads_ctx_mode\": \"PRODUCTION\", \"vads_currency\": \"978\", \"vads_language\": \"fr\", \"vads_order_id\": \"23544\", \"vads_trans_id\": \"004305\", \"vads_auth_mode\": \"FULL\", \"vads_bank_code\": \"13306\", \"vads_cust_name\": \"Sourbets MAXIME\", \"vads_bank_label\": \"Caisse régionale de crédit agricole mutuel d\'Aquitaine\", \"vads_card_brand\": \"CB\", \"vads_cust_email\": \"sourbets.maxime@gmail.com\", \"vads_trans_date\": \"20230429061918\",
The table "personnes" contain 64512 rows.
INSERT INTO `personnes` VALUES (38569,'2020-10-05 13:01:28','2024-10-24 08:42:54','038486',NULL,'A','M','MURCY','Jonathan','M','2002-08-23',NULL,'250',NULL,'','FR',NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,1,1,'{\"numero\": \"\", \"pseudo\": \"\", \"matricule\": \"\", \"numeroPdga\": \"\", \"numero_carte_pro_encadrant\": \"\", \"honorabilite_status_arbitre\": false, \"honorabilite_status_dirigeant\": false, \"honorabilite_status_encadrant\": false}','2020-10-05',NULL,NULL,NULL,35,'34',15969,'
(38603,'2020-10-06 09:47:59','2022-08-04 06:46:39','038519',NULL,'A','M','GENEIX','Valerie','M','1968-12-03',NULL,'250',NULL,'','FR',NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,'{\"numero\": \"\", \"pseudo\": \"\", \"matricule\": \"\", \"numero_carte_pro_encadrant\": \"\"}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','fb2a18f5-9f03-458a-98aa-8cb88e3f152c',0,NULL),(38604,'2020-10-06 09:49:10','2024-10-24 08:42:54','038520',NULL,'A','Mme','PAL','Sovannphaktra','F','1991-04-24',NULL,'250',NULL,NULL,'FR',NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'{\"numero\": \"\", \"pseudo\": \"\", \"matricule\": \"\", \"numeroPdga\": \"\", \"numero_carte_pro_encadrant\": \"\", \"honorabilite_status_arbitre\": false, \"honorabilite_status_dirigeant\": false, \"honorabilite_status_encadrant\": false}','2020-10-06',NULL,NULL,NULL,79,'78',38209,'78646',NULL,'649e2a05-5a7a-4875-8c99-100a6979d17c',0,NULL),(38605,'2020-10-06 10:48:53','2024-11-14 09:20:01','038521',NULL,'I','Mme','MILLECAMPS','Kelly','F','1998-07-25',NULL,NULL,NULL,'','FR',NULL,NULL,0,NULL,0,NULL,'DpQ26KqHYqM7wk1isECaNHqFQUUIDvnoeovyt0sQ.jpeg',NULL,NULL,NULL,NULL,0,0,1,1,0,'{\"numero\": \"\", \"pseudo\": \"\", \"matricule\": \"\", \"numeroPdga\": \"\", \"numero_carte_pro_encadrant\": \"\"}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'97d4b1e2-e2d2-46cb-8c94-094e2f180ab0',0,NULL),(38606,'2020-10-06 12:11:30','2024-10-24 08:42:54','038522',NULL,'A','M','OUDART','Antoine','M','1999-04-07',NULL,'250',NULL,NULL,'FR',NULL,NULL,0,NULL,0,NULL,'38606_779953_photo_id.png',NULL,NULL,NULL,NULL,1,0,1,1,0,'{\"numero\": \"\", \"pseudo\": \"\", \"matricule\": \"\", \"numeroPdga\": \"\", \"numero_carte_pro_encadrant\": \"\", \"honorabilite_status_arbitre\": false, \"honorabilite_status_dirigeant\": false, \"honorabilite_status_encadrant\": false}','2020-10-06',NULL,NULL,NULL,60,'59',27659,'59350',NULL,'b090eedd-e32c-4f4a-abdd-ade8727861e3',0,NULL),(38607,'2020-10-06 12:15:48','2023-09-17 18:00:54','038523',NULL,'A','M','MALONGA','Christian','M','1981-11-11',NULL,'250',NULL,'','FR',NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,1,0,'{\"numero\": \"\", \"pseudo\": \"\", \"matricule\": \"\", \"numeroPdga\": \"\", \"numero_carte_pro_encadrant\": \"\", \"honorabilite_status_arbitre\": false, \"honorabilite_status_dirigeant\": false, \"honorabilite_status_encadrant\": false}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'bf550b22-f002-4e0d-9209-260969637684',0,NULL),(38608,'2020-10-06 12:26:27','2022-08-04 06:46:39','038524',NULL,'A','Mme','AUDEBERT','Anais','F','1997-01-24',NULL,'250',NULL,'','FR',NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,0,'{\"numero\": \"\", \"pseudo\": \"\", \"matricule\": \"\", \"numero_carte_pro_encadrant\": \"\"}',NULL,NULL,NULL,NULL,NULL,'',NULL,'',NULL,'2c5d5e09-2dcb-42cc-87d0-45cf7a38ae1f',0,NULL),(38609,'2020-10-06 12:31:40','2022-08-04 06:46:39','038525',NULL,'A','M','DUPUY','Adrien','M','1997-11-14',NULL,'250',NULL,'','FR',NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,0,'{\"numero\": \"\", \"pseudo\": \"\", \"matricule\": \"\", \"numero_carte_pro_encadrant\": \"\"}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','1ba87f73-438f-4a78-a0b5-5413eb647f36',0,NULL),(38610,'2020-10-06 12:45:29','2022-08-04 06:46:39','038526',NULL,'A','Mme','HARDY','Laurycia','F','2000-10-10',NULL,'250',NULL,'','FR',NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,0,'{\"numero\": \"\", \"pseudo\": \"\", \"matricule\": \"\", \"numero_carte_pro_encadrant\": \"\"}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','6c4d13b5-60fc-4110-b846-8296803645d5',0,NULL),(38611,'2020-10-06 12:51:34','2022-08-04 06:46:39','038527',NULL,'A','M','HILLAIRET','Bryan','M','1997-03-27',NULL,'250',NULL,'','FR',NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,0,'{\"numero\": \"\", \"pseudo\": \"\", \"matricule\": \"\", \"numero_carte_pro_encadrant\": \"\"}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','8d53e488-ec13-4d2a-a7d1-ae1c9a959463',0,NULL),(38612,'2020-10-06 14:26:26','2024-10-24 08:42:54','038528',NULL,'A','Mme','LORENZON','Margaux','F','1999-12-14',NULL,'250',NULL,'','FR',NULL,NULL,0,NULL,0,NULL,'38612_387175_photo_id.png',NULL,NULL,NULL,NULL,1,0,1,1,1,'{\"numero\": \"\", \"pseudo\": \"\", \"matricule\": \"\", \"numeroPdga\": \"\", \"numero_carte_pro_encadrant\": \"\", \"honorabilite_status_arbitre\": false, \"honorabilite_status_dirigeant\": false, \"honorabilite_status_encadrant\": false}','2021-11-04',NULL,NULL,NULL,94,'93',42937,'93007',NULL,'513ec1d4-eb14-4981-96df-ad8bda8e0de7',0,NULL),(38613,'2020-10-06 14:50:40','2024-10-24 08:42:54','038529',NULL,'A','M','DUGUÉ','Kévin','M','1990-11-15',NULL,'250',NULL,'','FR',NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,1,1,'{\"numero\": \"\", \"pseudo\": \"\", \"matricule\": \"\", \"numero_carte_pro_encadrant\": \"\"}','2020-10-10',NULL,NULL,NULL,59,'58',27147,'58194',NULL,'4a425d01-ef68-46ba-be70-74a4e70eb091',0,NULL),(38614,'2020-10-06 18:38:54','2024-10-24 08:42:54','038530',NULL,'A','Mme','COMPAN','Thea','F','1996-03-25',NULL,'250',NULL,'','FR',NULL,NULL,0,NULL,0,NULL,'jKzUIhQjdS91cmqcq8JjOkx1miL0fgxv8JsKBNOw.jpeg',NULL,NULL,NULL,NULL,1,0,1,1,0,'{\"numero\": \"\", \"pseudo\": \"\", \"matricule\": \"\", \"numero_carte_pro_encadrant\": \"\"}','2020-10-06',NULL,NULL,NULL,31,'30',13883,'