UID:--094458-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505100944' ) UID:--094458-- UPDATE `tier_att` SET `id_work`='259',`att3`='Alice',`att1`='BASS',`att8`='non_défini',`att12`='bass.alice@wanadoo.fr',`att14`='31 rue Aristide Briand 68000 COLMAR',`att7`='68000',`att17`='COLMAR',`att18`='France',`att5`='+33669289628',`attf102`='20250510',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250510',`attdatmod`='202505100944',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3077') AND (id_type = '80') LIMIT 1 UID:--094458-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3077','202505100944','202505100944' ) UID:--094458-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='31 rue Aristide Briand 68000 COLMAR',`lig4`='68000',`lig5`='COLMAR',`lig6`='France',`ligdatmod`='202505100944',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3077') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1550') LIMIT 1 UID:--094458-- UPDATE `tier_att` SET `id_work`='259',`att3`='Alice',`att1`='BASS',`att8`='non_défini',`att12`='bass.alice@wanadoo.fr',`att14`='31 rue Aristide Briand 68000 COLMAR',`att7`='68000',`att17`='COLMAR',`att18`='France',`att5`='+33669289628',`attf102`='20250510',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250510',`att19`='48.067349',`att20`='7.356884',`attf100`='1',`attdatmod`='202505100944',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3077') AND (id_type = '80') LIMIT 1 UID:--094458-- UPDATE `tier_att` SET `id_work`='259',`att3`='Alice',`att1`='BASS',`att8`='non_défini',`att12`='bass.alice@wanadoo.fr',`att14`='31 rue Aristide Briand 68000 COLMAR',`att7`='68000',`att17`='COLMAR',`att18`='France',`att5`='+33669289628',`attf102`='20250510',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250510',`att19`='48.067349',`att20`='7.356884',`attf100`='1',`attdatmod`='202505100944',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3077') AND (id_type = '80') LIMIT 1 UID:--094458-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505100944' ) UID:--094458-- UPDATE `tier_att` SET `id_work`='367',`att2`='BASS',`att3`='Alice',`att5`='+33669289628',`att6`='bass.alice@wanadoo.fr',`att8`='3077',`att10`='[IDMYUSER]',`attdatmod`='202505100944',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3078') AND (id_type = '149') LIMIT 1 UID:--094458-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505100944' ) UID:--094458-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-',`att2`='3077',`attf100`='20250510',`att8`='1550',`att6`='[IDMYUSER]',`att9`='3078',`att3`='§toiture§',`attdatmod`='202505100944',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '325') AND (id_type = '148') LIMIT 1 UID:--094458-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-BASS',`att2`='3077',`attf100`='20250510',`att8`='1550',`att6`='[IDMYUSER]',`att9`='3078',`att3`='§toiture§',`attdatmod`='202505100944',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '325') AND (id_type = '148') LIMIT 1 UID:--094458-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-BASS',`att2`='3077',`attf100`='20250510',`att8`='1550',`att6`='[IDMYUSER]',`att9`='3078',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505100944',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '325') AND (id_type = '148') LIMIT 1 UID:--094458-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-BASS',`att2`='3077',`attf100`='20250510',`att8`='1550',`att6`='0',`att9`='3078',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505100944',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '325') AND (id_type = '148') LIMIT 1 UID:--094458-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250510','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-BASS','\r\n\r\nNouvelle opportunite\r\n\r\n\r\n\r\n\r\n \r\n \r\n \r\n
\r\n\r\n
\r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n\r\n
\r\n\r\n

\r\n Nouvelle opportunité - OPP-BASS

\r\n\r\n

\r\n Bonjour Exteco, (Mail envoyé au franchiseur lors d\'une création de nouvelle opportunité depuis l\'api lead)

\r\n Une nouvelle opportunité a été enregistrée, vous pouvez aller la consulter avec le bouton ci-dessous.

\r\n Cordialement,


\r\n\r\n \r\n \r\n \r\n \r\n \r\n
\r\n \r\n \r\n \r\n \r\n
\r\n Consulter l\'opportunité\r\n
\r\n
\r\n
\r\n \r\n
\r\n
\r\n \r\n\r\n
\r\n
','','0','v2017b' ) UID:--094458-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '216') LIMIT 1 UID:--094458--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0 UID:--094500-- UPDATE `tier_att` SET `id_work`='367',`att2`='BASS',`att3`='Alice',`att5`='+33669289628',`att6`='bass.alice@wanadoo.fr',`att8`='3077',`att10`='[IDMYUSER]',`att4`='+33669289628',`attdatmod`='202505100945',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3078') AND (id_type = '149') LIMIT 1 UID:--094500-- UPDATE `tier_att` SET `id_work`='259',`att3`='Alice',`att1`='BASS',`att8`='non_défini',`att12`='bass.alice@wanadoo.fr',`att14`='31 rue Aristide Briand 68000 COLMAR',`att7`='68000',`att17`='COLMAR',`att18`='France',`att5`='+33669289628',`attf102`='20250510',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250510',`att19`='48.067349',`att20`='7.356884',`attf100`='1',`attdatmod`='202505100945',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3077') AND (id_type = '80') LIMIT 1 UID:--094500-- UPDATE `tier_att` SET `id_work`='259',`att3`='Alice',`att1`='BASS',`att8`='non_défini',`att12`='bass.alice@wanadoo.fr',`att14`='31 rue Aristide Briand 68000 COLMAR',`att7`='68000',`att17`='COLMAR',`att18`='France',`att5`='+33669289628',`attf102`='20250510',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250510',`att19`='48.067349',`att20`='7.356884',`attf100`='1',`attdatmod`='202505100945',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3077') AND (id_type = '80') LIMIT 1 UID:--094500-- UPDATE `tier_att` SET `id_work`='259',`att3`='Alice',`att1`='BASS',`att8`='non_défini',`att12`='bass.alice@wanadoo.fr',`att14`='31 rue Aristide Briand 68000 COLMAR',`att7`='68000',`att17`='COLMAR',`att18`='France',`att5`='+33669289628',`attf102`='20250510',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250510',`att19`='48.067349',`att20`='7.356884',`attf100`='1',`att6`='+33669289628',`attdatmod`='202505100945',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3077') AND (id_type = '80') LIMIT 1 UID:--094500-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-BASS',`att2`='3077',`attf100`='20250510',`att8`='1550',`att6`='0',`att9`='3078',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505100945',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '325') AND (id_type = '148') LIMIT 1 UID:--101510-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505101015' ) UID:--101510-- UPDATE `tier_att` SET `id_work`='259',`att3`='Mathieu',`att1`='DILLENSCHNEIDER',`att8`='non_défini',`att12`='mathieu.dillen@gmail.com',`att14`='10 Rue Jean Freysz',`att7`='67113',`att17`='Blaesheim',`att18`='France',`att5`='0630684114',`attf102`='20250510',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250510',`attdatmod`='202505101015',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3079') AND (id_type = '80') LIMIT 1 UID:--101511-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3079','202505101015','202505101015' ) UID:--101511-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='10 Rue Jean Freysz',`lig4`='67113',`lig5`='Blaesheim',`lig6`='France',`ligdatmod`='202505101015',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3079') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1551') LIMIT 1 UID:--101511-- UPDATE `tier_att` SET `id_work`='259',`att3`='Mathieu',`att1`='DILLENSCHNEIDER',`att8`='non_défini',`att12`='mathieu.dillen@gmail.com',`att14`='10 Rue Jean Freysz',`att7`='67113',`att17`='Blaesheim',`att18`='France',`att5`='0630684114',`attf102`='20250510',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250510',`att19`='48.503923',`att20`='7.609392',`attf100`='1',`attdatmod`='202505101015',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3079') AND (id_type = '80') LIMIT 1 UID:--101511-- UPDATE `tier_att` SET `id_work`='259',`att3`='Mathieu',`att1`='DILLENSCHNEIDER',`att8`='non_défini',`att12`='mathieu.dillen@gmail.com',`att14`='10 Rue Jean Freysz',`att7`='67113',`att17`='Blaesheim',`att18`='France',`att5`='0630684114',`attf102`='20250510',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250510',`att19`='48.503923',`att20`='7.609392',`attf100`='1',`attdatmod`='202505101015',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3079') AND (id_type = '80') LIMIT 1 UID:--101511-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505101015' ) UID:--101511-- UPDATE `tier_att` SET `id_work`='367',`att2`='DILLENSCHNEIDER',`att3`='Mathieu',`att5`='0630684114',`att6`='mathieu.dillen@gmail.com',`att8`='3079',`att10`='[IDMYUSER]',`attdatmod`='202505101015',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3080') AND (id_type = '149') LIMIT 1 UID:--101511-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505101015' ) UID:--101511-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-',`att2`='3079',`attf100`='20250510',`att8`='1551',`att6`='[IDMYUSER]',`att9`='3080',`att3`='§toiture§',`attdatmod`='202505101015',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '326') AND (id_type = '148') LIMIT 1 UID:--101511-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-DILLENSCHNEIDER',`att2`='3079',`attf100`='20250510',`att8`='1551',`att6`='[IDMYUSER]',`att9`='3080',`att3`='§toiture§',`attdatmod`='202505101015',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '326') AND (id_type = '148') LIMIT 1 UID:--101511-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-DILLENSCHNEIDER',`att2`='3079',`attf100`='20250510',`att8`='1551',`att6`='[IDMYUSER]',`att9`='3080',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505101015',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '326') AND (id_type = '148') LIMIT 1 UID:--101511-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-DILLENSCHNEIDER',`att2`='3079',`attf100`='20250510',`att8`='1551',`att6`='0',`att9`='3080',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505101015',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '326') AND (id_type = '148') LIMIT 1 UID:--101511-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250510','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-DILLENSCHNEIDER','\r\n\r\nNouvelle opportunite\r\n\r\n\r\n\r\n\r\n \r\n \r\n \r\n
\r\n\r\n
\r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n\r\n
\r\n\r\n

\r\n Nouvelle opportunité - OPP-DILLENSCHNEIDER

\r\n\r\n

\r\n Bonjour Exteco, (Mail envoyé au franchiseur lors d\'une création de nouvelle opportunité depuis l\'api lead)

\r\n Une nouvelle opportunité a été enregistrée, vous pouvez aller la consulter avec le bouton ci-dessous.

\r\n Cordialement,


\r\n\r\n \r\n \r\n \r\n \r\n \r\n
\r\n \r\n \r\n \r\n \r\n
\r\n Consulter l\'opportunité\r\n
\r\n
\r\n
\r\n \r\n
\r\n
\r\n \r\n\r\n
\r\n
','','0','v2017b' ) UID:--101511-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '217') LIMIT 1 UID:--101511--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0 UID:--101511-- UPDATE `tier_att` SET `id_work`='367',`att2`='DILLENSCHNEIDER',`att3`='Mathieu',`att5`='0630684114',`att6`='mathieu.dillen@gmail.com',`att8`='3079',`att10`='[IDMYUSER]',`att4`='0630684114',`attdatmod`='202505101015',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3080') AND (id_type = '149') LIMIT 1 UID:--101511-- UPDATE `tier_att` SET `id_work`='259',`att3`='Mathieu',`att1`='DILLENSCHNEIDER',`att8`='non_défini',`att12`='mathieu.dillen@gmail.com',`att14`='10 Rue Jean Freysz',`att7`='67113',`att17`='Blaesheim',`att18`='France',`att5`='0630684114',`attf102`='20250510',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250510',`att19`='48.503923',`att20`='7.609392',`attf100`='1',`attdatmod`='202505101015',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3079') AND (id_type = '80') LIMIT 1 UID:--101511-- UPDATE `tier_att` SET `id_work`='259',`att3`='Mathieu',`att1`='DILLENSCHNEIDER',`att8`='non_défini',`att12`='mathieu.dillen@gmail.com',`att14`='10 Rue Jean Freysz',`att7`='67113',`att17`='Blaesheim',`att18`='France',`att5`='0630684114',`attf102`='20250510',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250510',`att19`='48.503923',`att20`='7.609392',`attf100`='1',`attdatmod`='202505101015',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3079') AND (id_type = '80') LIMIT 1 UID:--101511-- UPDATE `tier_att` SET `id_work`='259',`att3`='Mathieu',`att1`='DILLENSCHNEIDER',`att8`='non_défini',`att12`='mathieu.dillen@gmail.com',`att14`='10 Rue Jean Freysz',`att7`='67113',`att17`='Blaesheim',`att18`='France',`att5`='0630684114',`attf102`='20250510',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250510',`att19`='48.503923',`att20`='7.609392',`attf100`='1',`att6`='0630684114',`attdatmod`='202505101015',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3079') AND (id_type = '80') LIMIT 1 UID:--101511-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-DILLENSCHNEIDER',`att2`='3079',`attf100`='20250510',`att8`='1551',`att6`='0',`att9`='3080',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505101015',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '326') AND (id_type = '148') LIMIT 1 UID:--125147--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm WHERE pm.id_base=1 AND pm.id_base=pdm.id_base AND pm.id_menu=pdm.id_menu AND pdm.droit>0 AND pdm.id_role IN (89) ORDER BY pm.ordre UID:--125147--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:10--125308--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm WHERE pm.id_base=1 AND pm.id_base=pdm.id_base AND pm.id_menu=pdm.id_menu AND pdm.droit>0 AND pdm.id_role IN (89) ORDER BY pm.ordre UID:10--125308--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:10--125316--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm WHERE pm.id_base=1 AND pm.id_base=pdm.id_base AND pm.id_menu=pdm.id_menu AND pdm.droit>0 AND pdm.id_role IN (89) ORDER BY pm.ordre UID:10--125316--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--192729--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm WHERE pm.id_base=1 AND pm.id_base=pdm.id_base AND pm.id_menu=pdm.id_menu AND pdm.droit>0 AND pdm.id_role IN (89) ORDER BY pm.ordre UID:--192729--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--222132--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm WHERE pm.id_base=1 AND pm.id_base=pdm.id_base AND pm.id_menu=pdm.id_menu AND pdm.droit>0 AND pdm.id_role IN (89) ORDER BY pm.ordre UID:--222132--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre