INSERT INTO `ADHERENTS` (`id_adhrent`,`nom`,`prenom`,`adresse`,`ville`,`CP`,`mail`,`nb_coopte`,`validation_medical`,`date_inscription`) VALUES (1,'Stokes','Allistair','Appartement 640-2286 Proin Ave','Roselies','7291','aliquet.odio@maurisMorbinon.co.uk',5,'non','25-12-16');
INSERT INTO `ADHERENTS` (`id_adhrent`,`nom`,`prenom`,`adresse`,`ville`,`CP`,`mail`,`nb_coopte`,`validation_medical`,`date_inscription`) VALUES (2,'Lyons','Amir','685-1763 Neque Ave','Shawinigan','68229','Cras.eu@vestibulumloremsit.co.uk',7,'oui','19-12-17');
INSERT INTO `ADHERENTS` (`id_adhrent`,`nom`,`prenom`,`adresse`,`ville`,`CP`,`mail`,`nb_coopte`,`validation_medical`,`date_inscription`) VALUES (3,'Richard','Kessie','676-2894 Lorem Impasse','Mezzana','74517','nisi.Cum.sociis@etpede.ca',7,'oui','20-11-17');
INSERT INTO `ADHERENTS` (`id_adhrent`,`nom`,`prenom`,`adresse`,`ville`,`CP`,`mail`,`nb_coopte`,`validation_medical`,`date_inscription`) VALUES (4,'Foley','Xanthus','Appartement 597-3133 Magna Rue','Coldstream','59127','sagittis.augue@vitaediam.edu',6,'oui','15-05-17');
INSERT INTO `ADHERENTS` (`id_adhrent`,`nom`,`prenom`,`adresse`,`ville`,`CP`,`mail`,`nb_coopte`,`validation_medical`,`date_inscription`) VALUES (5,'Gilbert','Rahim','CP 255, 6960 Etiam Av.','San Giovanni Suergiu','826342','orci@arcuNuncmauris.com',7,'non','03-06-16');
INSERT INTO `ADHERENTS` (`id_adhrent`,`nom`,`prenom`,`adresse`,`ville`,`CP`,`mail`,`nb_coopte`,`validation_medical`,`date_inscription`) VALUES (6,'Hernandez','Jada','Appartement 716-4860 Amet Route','San Miguel','009616','Aenean.euismod.mauris@nisi.net',1,'oui','24-11-16');
INSERT INTO `ADHERENTS` (`id_adhrent`,`nom`,`prenom`,`adresse`,`ville`,`CP`,`mail`,`nb_coopte`,`validation_medical`,`date_inscription`) VALUES (7,'Cochran','Brooke','709-966 Quisque Rd.','Raurkela Civil Township','5533','penatibus@velitjusto.edu',7,'oui','30-05-17');
INSERT INTO `ADHERENTS` (`id_adhrent`,`nom`,`prenom`,`adresse`,`ville`,`CP`,`mail`,`nb_coopte`,`validation_medical`,`date_inscription`) VALUES (8,'Glass','Kirby','910-1184 Lacus Chemin','Boise','92545','feugiat.Lorem@pharetra.org',8,'oui','21-03-17');
INSERT INTO `ADHERENTS` (`id_adhrent`,`nom`,`prenom`,`adresse`,`ville`,`CP`,`mail`,`nb_coopte`,`validation_medical`,`date_inscription`) VALUES (9,'Marquez','Pearl','CP 971, 6676 Semper, Impasse','Cauquenes','03662','euismod.et.commodo@molestietellusAenean.edu',8,'non','19-09-17');
INSERT INTO `ADHERENTS` (`id_adhrent`,`nom`,`prenom`,`adresse`,`ville`,`CP`,`mail`,`nb_coopte`,`validation_medical`,`date_inscription`) VALUES (10,'Collins','Beverly','970-6831 Egestas. Avenue','Sachs Harbour','1230','sem.ut@magnisdis.co.uk',8,'non','13-03-18');