zenmobile france - Printable Version

Code:
INSERT INTO `infos` (`ID`, `Nom`, `Prenom`, `Civilite`, `Ville`, `Code_Postal`, `Adresse`, `Tel1`, `Mail`, `Date_Naissance`, `Commentaire`, `Date_de_Collect`, `Source_Site`, `Fichier_NHY_Chaud`, `Fichier_NHY_Froid`, `Deja_Exporter`, `Qualification`, `Departement`, `IDTAB`, `Mutuelle_CHAUD`, `Mutuelle_FROID`, `Fournisseurs`, `Dernier_Appel`, `Serveur`, `Equipe`, `Nouveau`) VALUES

('2,03E+15', 'nejjari', 'assia', 'Mme', 'paris', '75017', '17 boulevard bessieres, batiment a2', '616668648', 'assia.nejjari80@outlook.fr', '1980-05-20', '', '01/12/2021', 'https://demande-prime-fin-annee.votre-participation.com/', 1, 0, 0, 'In Queue', 'DEP75', 1, 0, 0, 'WebRivage', '2023-02-03', 'kpc.b', '', 0),

('2,33E+14', 'pagnier', 'manon', 'Mme', 'pusey', '70000', '7 rue gustave courtois', '777829104', 'manon.pagnier@outlook.fr', '1997-07-11', '', '01/12/2021', 'https://velo-electrique-au-choix.plein2kdo.com/', 1, 0, 1, 'Argumenté', 'DEP70', 2, 0, 0, 'WebRivage', '2022-01-07', 'oritelmobile', 'ACTUDATA ZEN', 0),

('2,53E+14', 'raoaufi', 'sounia', 'Mme', 'nice', '6300', 'boulevard louis braille', '646920775', 'sousoutounsia06@hotmail.fr', '1982-11-01', '', '01/12/2021', 'https://formulaire-cheque-alimentaire.votre-participation.com/', 1, 0, 0, 'Non argumenté', 'DEP06', 3, 0, 0, 'WebRivage', '2023-02-22', 'kpc.b', 'PREVIANCE', 0),

('2,93E+15', 'lebdiri', 'sabiha', 'Mme', 'mont st aignan', '76130', '37 rue du marechal juin, residence du bois monet log 346', '753890342', 'sabihalebdiri@gmail.com', '1995-03-22', '', '01/12/2021', 'https://demande-prime-fin-annee.votre-participation.com/', 1, 0, 1, 'S_NRP', 'DEP76', 4, 0, 0, 'WebRivage', '2022-08-29', 'zensante2mobile', '', 0),

('2,13E+15', 'Lorillier', 'Sacha', 'Mr', 'rennes', '35000', '23 rue de la visitation', '782892346', 'sacha.lorillier@gmail.com', '1999-09-06', '', '01/12/2021', 'https://oled-attrapez-les-tous.plein2kdo.com/', 1, 0, 0, 'In Queue', 'DEP35', 5, 0, 0, 'WebRivage', '2023-02-17', 'kpc.b', '', 0),

('2,73E+14', 'Dehmane', 'Nadia', 'Mme', 'serres', '5700', '29 rue henri peuzin', '622221438', 'ndehmane@yahoo.fr', '1969-10-08', '', '01/12/2021', 'https://rester-jeune.plein2kdo.com/', 1, 0, 0, 'Answering Machine', 'DEP05', 6, 0, 0, 'WebRivage', '2023-02-21', 'kpc.b', '', 0),

('2,73E+15', 'Thirion', 'Jessica', 'Mme', 'dreux', '28100', '44 rue saint denis', '644266881', 'miss280001@live.fr', '1990-04-07', '', '01/12/2021', 'https://parfums-pour-hommes.1jour1envie.com/', 1, 0, 1, 'S_REPONDEUR', 'DEP28', 7, 0, 0, 'WebRivage', '2022-09-24', 'zensante2mobile', '', 0),

('2,33E+15', 'FIGIEL', 'Audrey', 'Mme', 'nevers', '58000', '4 rue du 8 mai 1945, 513', '662745944', 'daday58@outlook.fr', '1977-08-02', '', '01/12/2021', 'https://demande-prime-fin-annee.votre-participation.com/', 1, 0, 0, 'Non argumenté', 'DEP58', 8, 0, 0, 'WebRivage', '2023-02-09', 'kpc.b', 'PREVIANCE', 0),

('2,63E+15', 'dumas-lawless', 'claire', 'Mme', 'fargues st hilaire', '33370', '11 residence le tertre des forges', '613310569', 'claire.dumas20@hotmail.fr', '1972-04-20', '', '01/12/2021', 'https://velo-electrique-au-choix.plein2kdo.com/', 1, 0, 0, 'Answering Machine', 'DEP33', 9, 0, 0, 'WebRivage', '2023-02-03', 'kpc.b', '', 0),

('2,93E+15', 'Lebel', 'Elodie', 'Mme', 'hirson', '2500', '26 parc brisset', '683594038', 'lebelelodie21@gmail.com', '1987-09-18', '', '01/12/2021', 'https://prime-eco-energie.votre-participation.com/', 1, 0, 1, '', 'DEP02', 10, 0, 0, 'WebRivage', '0000-00-00', '', '', 0),

('2,13E+14', 'hubach', 'daniel', 'Mr', 'strasbourg', '67100', '138 avenue de colmar', '777045040', 'hubach67100@gmail.com', '1959-07-12', '02/14/2023 15:32:11: TECH.B (190) xfered dispos from: 0Equipe_A (315) to: 0backup (314) | 02/14/2023 15:09:24: [auto] turned off from 0 Voice Broadcasts and 1 Campaigns | 02/14/2023 15:09:24: 1DANIEL ZEN1 removed all future calls via Custom Calls Off | 02/14/2023 15:09:23: 1DANIEL ZEN1 marked contact as Non argumenté | 02/14/2023 15:07:54: Initiated a predictive call from Q: 0Equipe_A |', '01/12/2021', 'https://paquet-tablette-noel.plein2kdo.com/', 1, 0, 0, 'Non argumenté', 'DEP67', 11, 0, 0, 'WebRivage', '2023-02-14', 'kpc.b', 'NHY KPC', 0),

('2,23E+15', 'Trumeau', 'Mickaël', 'Mr', 'caudry', '59540', '66 rue gambetta', '648051185', 'mickael.trumeau@live.fr', '1996-12-11', '02/15/2023 14:55:31: KPC.B@GMAIL.COM (46) xfered all from: 0Equipe_A (322) to: 0backup (321) | 02/15/2023 13:10:36: TECH.B (190) xfered all from: 0Equipe_A (322) to: 0Equipe_A (322) | 02/15/2023 13:09:44: Initiated a predictive call from Q: 0Equipe_A | 02/15/2023 12:01:18: Added to Campaign: 0Equipe_A |', '01/12/2021', 'https://formulaire-inscription-5.1jour1envie.com/', 1, 0, 0, 'In Queue', 'DEP59', 12, 0, 0, 'WebRivage', '2023-02-15', 'kpc.b', '', 0),

('2,73E+15', 'currat', 'virginie', 'Mme', 'ceyzeriat', '1250', '18 chemin des billets', '672247324', 'lvda01@hotmail.fr', '1974-08-13', '', '01/12/2021', 'https://colis-assortiment-gateaux.1jour1envie.com/', 1, 0, 0, 'Answering Machine', 'DEP01', 13, 0, 0, 'WebRivage', '2023-02-09', 'kpc.b', '', 0),

('2,43E+14', 'Dos santos', 'Julie', 'Mme', 'tarnos', '40220', '11 rue des palombes', '610149375', 'july_ny_6@hotmail.fr', '1988-09-06', '', '01/12/2021', 'https://cuisinez.specialgastronomie.com/', 1, 0, 1, 'Argumenté', 'DEP40', 14, 0, 0, 'WebRivage', '2022-01-05', 'oritelmobile', 'PREVIANCE', 0),

('2,43E+15', 'ahamadi', 'nahida', 'Mme', 'loudeac', '22600', '34 rue anatole le braz, residence', '623632164', 'ahamadinahida@gmail.com', '2002-03-05', '', '01/12/2021', 'https://decouverte-smartphone.plein2kdo.com/', 1, 0, 1, '', 'DEP22', 15, 0, 0, 'WebRivage', '0000-00-00', '', '', 0),

('2,83E+15', 'Chhuth', 'Sonia', 'Mme', 'frontignan', '34110', 'avenue pierre curie', '695602250', 'taissane@gmail.com', '1981-09-05', '', '01/12/2021', 'https://avent-de-luxe.plein2kdo.com/', 1, 0, 1, '', 'DEP34', 16, 0, 0, 'WebRivage', '0000-00-00', 'zensante2mobile', '', 0),

('2,13E+15', 'Dubois', 'Melissa', 'Mme', 'calonne ricouart', '62470', '4 rue de blangy', '786609911', 'melissagaetan22102016@gmail.com', '1996-03-08', '', '01/12/2021', 'https://echantillons1.1jour1envie.com/', 1, 0, 1, 'Non argumenté', 'DEP62', 17, 0, 0, 'WebRivage', '0000-00-00', 'kavkom', '', 0),

('2,03E+15', 'dalenc', 'loïc', 'Mr', 'pamiers', '9100', '31 rue henri dunant', '755634612', 'loakhb@gmail.com', '1993-01-31', '', '01/12/2021', 'https://velo-electrique-au-choix.plein2kdo.com/', 1, 0, 1, 'Argumenté', 'DEP09', 18, 0, 0, 'WebRivage', '0000-00-00', 'kavkom', '', 0),

('2,53E+15', 'Martin', 'Brigitte', 'Mme', 'bain de bretagne', '35470', '13 impasse des cannas', '632212241', 'brigitte35470@gmail.com', '1957-09-23', '', '01/12/2021', 'https://weekend-chateau.specialgastronomie.com/', 1, 0, 0, 'REPONDEUR', 'DEP35', 19, 0, 0, 'WebRivage', '0000-00-00', 'kavkom', '', 0),

('2,03E+15', 'Seynaeve', 'Mélanie', 'Mme', 'ronchin', '59790', '4 rue gounod', '619113588', 'seynaevemelanie@yahoo.fr', '1980-01-29', '01/31/2023 15:31:54: KPC.B@GMAIL.COM (46) xfered dispos from: 0Equipe_A (272) to: 0backup (271) | 01/31/2023 13:11:53: [auto] turned off from 0 Voice Broadcasts and 1 Campaigns | 01/31/2023 13:11:53: 1MAGALIE ZEN1 removed all future calls via Custom Calls Off | 01/31/2023 13:11:53: 1MAGALIE ZEN1 marked contact as Non argumenté | 01/31/2023 13:11:00: Initiated a predictive call from Q: 0Equipe_A |', '01/12/2021', 'https://carte-cadeau-loisir-creatif.plein2kdo.com/', 1, 0, 0, 'Non argumenté', 'DEP59', 20, 0, 0, 'WebRivage', '2023-01-31', 'kpc.b', 'NHY KPC', 0),

('2,33E+14', 'zrelli', 'rachida', 'Mme', 'lyon', '69007', '48 rue du repos', '621650227', 'zrelli.rachida@gmail.com', '1980-07-18', '', '01/12/2021', 'https://demande-prime-fin-annee.votre-participation.com/', 1, 0, 0, 'Answering Machine', 'DEP69', 21, 0, 0, 'WebRivage', '2023-02-28', 'kpc.b', '', 0),

('2,63E+15', 'Guinet', 'Estelle', 'Mme', 'bully les mines', '62160', '14 rue fernand marche', '658190558', 'esguinet@laposte.net', '1982-03-25', '', '01/12/2021', 'https://la-plus-belle-s-est-vous.plein2kdo.com/', 1, 0, 0, 'PAS DE REPONSE', 'DEP62', 22, 0, 0, 'WebRivage', '2023-02-03', 'kpc.b', '', 0),

('', 'Demouveaux', 'Delphine', 'Mme', 'Anstaing', '59152', '31 Rue Steclebout', '688348913', 'sydneydd@hotmail.fr', '1975-06-07', '', '06/02/2023 12:43', '', 1, 0, 0, 'Carrier Error', 'DEP59', 184750406, 0, 0, 'Tagadamedia', '2023-02-07', 'kpc.b', '', 0),

('2,43E+15', 'Aissiou', 'Maryse', 'Mme', 'alencon', '61000', '3 rue joseph onfray', '773029868', 'maryse.aissiou41@gmail.com', '1967-08-01', '01/13/2023 11:39:49: KPC.B@GMAIL.COM (46) xfered dispos from: 0Equipe_A (226) to: 0backup (225) | 01/13/2023 11:37:46: [auto] turned off from 0 Voice Broadcasts and 1 Campaigns | 01/13/2023 11:37:46: 1 ELSA removed all future calls via Custom Calls Off | 01/13/2023 11:37:46: 1 ELSA marked contact as Non argumenté | 01/13/2023 11:37:09: Initiated a predictive call from Q: 0Equipe_A |', '01/12/2021', 'https://formulaire-cheque-alimentaire.votre-participation.com/', 1, 0, 1, 'Non argumenté', 'DEP61', 23, 0, 0, 'WebRivage', '2023-01-13', 'kpc.b', '', 0),

('2,83E+14', 'cholley', 'denis', 'Mr', 'sausset les pins', '13960', 'avenue lariano, residence les embruns', '628254410', 'cholldens88@gmail.com', '1958-09-09', '', '01/12/2021', 'https://carte-essence.plein2kdo.com/', 1, 0, 0, 'Answering Machine', 'DEP13', 24, 0, 0, 'WebRivage', '2023-02-01', 'kpc.b', '', 0),

('2,23E+15', 'Etcheverry', 'Severine', 'Mme', 'virelade', '33720', '1 lotissement des bauers', '673186951', 'solineetcheverry@hotmail.fr', '1983-10-25', '', '01/12/2021', 'https://echantillons1.1jour1envie.com/', 1, 0, 1, 'S_INJOIGNABLE', 'DEP33', 25, 0, 0, 'WebRivage', '2022-09-24', 'zensante2mobile', '', 0),

('2,33E+15', 'clowez', 'floriane', 'Mme', 'ste gemme', '17250', '15 rue de la garenne', '638528530', 'clowezfloriane51@gmail.com', '1964-03-13', '', '01/12/2021', 'https://demande-prime-fin-annee.votre-participation.com/', 1, 0, 1, 'S_REPONDEUR', 'DEP17', 26, 0, 0, 'WebRivage', '2022-10-05', 'zenrabat', '', 0),

('2,03E+15', 'savic', 'zoran', 'Mr', 'bayonne', '64100', 'chemin de mounede', '678186435', 'zrnsvc946@gmail.com', '1951-05-18', '', '01/12/2021', 'https://starcash.plein2kdo.com/', 1, 0, 1, 'Non argumenté', 'DEP64', 27, 0, 0, 'WebRivage', '2022-10-03', 'zenrabat', 'MUTUELLE', 0),

('2,13E+15', 'Ledet', 'Dylan', 'Mr', 'calais', '62100', '11 rue des salines', '615561604', 'matteolavie0@gmail.com', '2001-01-26', '20001', '01/12/2021', 'https://vive-noel.plein2kdo.com/', 1, 0, 1, 'Rappel', 'DEP62', 28, 0, 0, 'WebRivage', '2022-05-18', 'zensante2mobile', 'NHY ORITEL', 0),

('2,23E+15', 'matili', 'zoubida', 'Mme', 'sevran', '93270', '8 allee francis garnier', '768319328', 'zoubidamatili@gmail.com', '1971-05-22', '', '01/12/2021', 'https://demande-prime-fin-annee.votre-participation.com/', 1, 0, 1, 'Answering Machine', 'DEP93', 29, 0, 0, 'WebRivage', '2023-01-13', 'kpc.b', '', 0),

('2,73E+15', 'Trayaud', 'Martine', 'Mme', 'gueret', '23000', '12 rue marc bloch, lotissement ferme braconne', '643071438', 'trayaud_martine@orange.fr', '1954-11-20', '', '01/12/2021', 'https://quiz-musique.plein2kdo.com/', 1, 0, 0, 'REPONDEUR', 'DEP23', 30, 0, 0, 'WebRivage', '0000-00-00', 'kavkom', '', 0),

('2,93E+15', 'bouda', 'yanis', 'Mr', 'le havre', '76620', '38 rue tristan bernard', '744538580', 'yanisbouda08@gmail.com', '1992-08-06', '', '01/12/2021', 'https://starcash.plein2kdo.com/', 1, 0, 0, 'Non argumenté', 'DEP76', 31, 0, 0, 'WebRivage', '2023-02-22', 'kpc.b', 'PREVIANCE', 0),

('2,13E+15', 'Gourdin', 'Christine', 'Mme', 'donneville', '31450', '9 allee du languedoc', '679407142', '1968kiki31@gmail.com', '1968-04-28', '02/15/2023 14:55:31: KPC.B@GMAIL.COM (46) xfered all from: 0Equipe_A (322) to: 0backup (321) | 02/15/2023 13:22:40: Initiated a predictive call from Q: 0Equipe_A | 02/15/2023 13:10:36: TECH.B (190) xfered all from: 0Equipe_A (322) to: 0Equipe_A (322) | 02/15/2023 11:44:30: Initiated a predictive call from Q: 0Equipe_A | 02/15/2023 11:30:10: TECH.B (190) xfered all from: 0Equipe_A (322) to: 0Equipe_A (322) |', '01/12/2021', 'https://calendrier-avent-hp.plein2kdo.com/', 1, 0, 0, 'In Queue', 'DEP31', 32, 0, 0, 'WebRivage', '2023-02-15', 'kpc.b', '', 0),