UID:--023716--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:--023716--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:9--024123--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:9--024123--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:9--025647--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:9--025647--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:9--025705--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:9--025705--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:9--025711--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:9--025711--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--092305-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505170923' ) UID:--092305-- UPDATE `tier_att` SET `id_work`='259',`att3`='Clement',`att1`='Mayoux',`att8`='non_défini',`att12`='clementmayoux@gmail.com',`att14`='8 Rue de la Ceriseraie',`att7`='57480',`att17`='Hunting',`att18`='France',`att5`='0643302995',`attf102`='20250517',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250517',`attdatmod`='202505170923',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3172') AND (id_type = '80') LIMIT 1 UID:--092305-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3172','202505170923','202505170923' ) UID:--092305-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='8 Rue de la Ceriseraie',`lig4`='57480',`lig5`='Hunting',`lig6`='France',`ligdatmod`='202505170923',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3172') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1598') LIMIT 1 UID:--092305-- UPDATE `tier_att` SET `id_work`='259',`att3`='Clement',`att1`='Mayoux',`att8`='non_défini',`att12`='clementmayoux@gmail.com',`att14`='8 Rue de la Ceriseraie',`att7`='57480',`att17`='Hunting',`att18`='France',`att5`='0643302995',`attf102`='20250517',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250517',`att19`='49.418468',`att20`='6.325498',`attf100`='1',`attdatmod`='202505170923',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3172') AND (id_type = '80') LIMIT 1 UID:--092305-- UPDATE `tier_att` SET `id_work`='259',`att3`='Clement',`att1`='Mayoux',`att8`='non_défini',`att12`='clementmayoux@gmail.com',`att14`='8 Rue de la Ceriseraie',`att7`='57480',`att17`='Hunting',`att18`='France',`att5`='0643302995',`attf102`='20250517',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250517',`att19`='49.418468',`att20`='6.325498',`attf100`='1',`attdatmod`='202505170923',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3172') AND (id_type = '80') LIMIT 1 UID:--092305-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505170923' ) UID:--092305-- UPDATE `tier_att` SET `id_work`='367',`att2`='Mayoux',`att3`='Clement',`att5`='0643302995',`att6`='clementmayoux@gmail.com',`att8`='3172',`att10`='[IDMYUSER]',`attdatmod`='202505170923',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3173') AND (id_type = '149') LIMIT 1 UID:--092305-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505170923' ) UID:--092305-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-',`att2`='3172',`att90`='Je souhaiterais un devis pour un nettoyage de devant de maison en pavé (env 50m2) + terrasse en pierre naturelle (env 25m2) + toiture.',`attf100`='20250517',`att8`='1598',`att6`='[IDMYUSER]',`att9`='3173',`att3`='§autres§',`attdatmod`='202505170923',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '466') AND (id_type = '148') LIMIT 1 UID:--092305-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Mayoux',`att2`='3172',`att90`='Je souhaiterais un devis pour un nettoyage de devant de maison en pavé (env 50m2) + terrasse en pierre naturelle (env 25m2) + toiture.',`attf100`='20250517',`att8`='1598',`att6`='[IDMYUSER]',`att9`='3173',`att3`='§autres§',`attdatmod`='202505170923',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '466') AND (id_type = '148') LIMIT 1 UID:--092305-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Mayoux',`att2`='3172',`att90`='Je souhaiterais un devis pour un nettoyage de devant de maison en pavé (env 50m2) + terrasse en pierre naturelle (env 25m2) + toiture.',`attf100`='20250517',`att8`='1598',`att6`='[IDMYUSER]',`att9`='3173',`att3`='§autres§',`att5`='',`att10`='non_défini',`attdatmod`='202505170923',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '466') AND (id_type = '148') LIMIT 1 UID:--092305-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Mayoux',`att2`='3172',`att90`='Je souhaiterais un devis pour un nettoyage de devant de maison en pavé (env 50m2) + terrasse en pierre naturelle (env 25m2) + toiture.',`attf100`='20250517',`att8`='1598',`att6`='0',`att9`='3173',`att3`='§autres§',`att5`='',`att10`='non_défini',`attdatmod`='202505170923',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '466') AND (id_type = '148') LIMIT 1 UID:--092306-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250517','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Mayoux','\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-Mayoux

\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:--092306-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '336') LIMIT 1 UID:--092306--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:--092306-- UPDATE `tier_att` SET `id_work`='367',`att2`='Mayoux',`att3`='Clement',`att5`='0643302995',`att6`='clementmayoux@gmail.com',`att8`='3172',`att10`='[IDMYUSER]',`att4`='0643302995',`attdatmod`='202505170923',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3173') AND (id_type = '149') LIMIT 1 UID:--092306-- UPDATE `tier_att` SET `id_work`='259',`att3`='Clement',`att1`='Mayoux',`att8`='non_défini',`att12`='clementmayoux@gmail.com',`att14`='8 Rue de la Ceriseraie',`att7`='57480',`att17`='Hunting',`att18`='France',`att5`='0643302995',`attf102`='20250517',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250517',`att19`='49.418468',`att20`='6.325498',`attf100`='1',`attdatmod`='202505170923',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3172') AND (id_type = '80') LIMIT 1 UID:--092306-- UPDATE `tier_att` SET `id_work`='259',`att3`='Clement',`att1`='Mayoux',`att8`='non_défini',`att12`='clementmayoux@gmail.com',`att14`='8 Rue de la Ceriseraie',`att7`='57480',`att17`='Hunting',`att18`='France',`att5`='0643302995',`attf102`='20250517',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250517',`att19`='49.418468',`att20`='6.325498',`attf100`='1',`attdatmod`='202505170923',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3172') AND (id_type = '80') LIMIT 1 UID:--092306-- UPDATE `tier_att` SET `id_work`='259',`att3`='Clement',`att1`='Mayoux',`att8`='non_défini',`att12`='clementmayoux@gmail.com',`att14`='8 Rue de la Ceriseraie',`att7`='57480',`att17`='Hunting',`att18`='France',`att5`='0643302995',`attf102`='20250517',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250517',`att19`='49.418468',`att20`='6.325498',`attf100`='1',`att6`='0643302995',`attdatmod`='202505170923',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3172') AND (id_type = '80') LIMIT 1 UID:--092306-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Mayoux',`att2`='3172',`att90`='Je souhaiterais un devis pour un nettoyage de devant de maison en pavé (env 50m2) + terrasse en pierre naturelle (env 25m2) + toiture.',`attf100`='20250517',`att8`='1598',`att6`='0',`att9`='3173',`att3`='§autres§',`att5`='',`att10`='non_défini',`attdatmod`='202505170923',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '466') AND (id_type = '148') LIMIT 1 UID:--095444--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:--095444--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--130357--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:--130357--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--134734--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:--134734--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--134827-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505171348' ) UID:--134827-- UPDATE `tier_att` SET `id_work`='259',`att3`='Alexandra',`att1`='Barletta',`att8`='non_défini',`att12`='a.barletta@outlook.fr',`att14`='92B Avenue De Strasbourg',`att7`='57070',`att17`='Metz',`att18`='France',`att5`='0687065324',`attf102`='20250517',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250517',`attdatmod`='202505171348',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3174') AND (id_type = '80') LIMIT 1 UID:--134827-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3174','202505171348','202505171348' ) UID:--134827-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='92B Avenue De Strasbourg',`lig4`='57070',`lig5`='Metz',`lig6`='France',`ligdatmod`='202505171348',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3174') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1599') LIMIT 1 UID:--134827-- UPDATE `tier_att` SET `id_work`='259',`att3`='Alexandra',`att1`='Barletta',`att8`='non_défini',`att12`='a.barletta@outlook.fr',`att14`='92B Avenue De Strasbourg',`att7`='57070',`att17`='Metz',`att18`='France',`att5`='0687065324',`attf102`='20250517',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250517',`att19`='49.112342',`att20`='6.195944',`attf100`='1',`attdatmod`='202505171348',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3174') AND (id_type = '80') LIMIT 1 UID:--134827-- UPDATE `tier_att` SET `id_work`='259',`att3`='Alexandra',`att1`='Barletta',`att8`='non_défini',`att12`='a.barletta@outlook.fr',`att14`='92B Avenue De Strasbourg',`att7`='57070',`att17`='Metz',`att18`='France',`att5`='0687065324',`attf102`='20250517',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250517',`att19`='49.112342',`att20`='6.195944',`attf100`='1',`attdatmod`='202505171348',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3174') AND (id_type = '80') LIMIT 1 UID:--134827-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505171348' ) UID:--134827-- UPDATE `tier_att` SET `id_work`='367',`att2`='Barletta',`att3`='Alexandra',`att5`='0687065324',`att6`='a.barletta@outlook.fr',`att8`='3174',`att10`='[IDMYUSER]',`attdatmod`='202505171348',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3175') AND (id_type = '149') LIMIT 1 UID:--134827-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505171348' ) UID:--134827-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-',`att2`='3174',`att90`='Bonjour,\r\nJe souhaiterais faire réaliser le nettoyage d’une terrasse de 36m2. \r\nCordialement',`attf100`='20250517',`att8`='1599',`att6`='[IDMYUSER]',`att9`='3175',`att3`='§terrasse§',`attdatmod`='202505171348',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '467') AND (id_type = '148') LIMIT 1 UID:--134827-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Barletta',`att2`='3174',`att90`='Bonjour,\r\nJe souhaiterais faire réaliser le nettoyage d’une terrasse de 36m2. \r\nCordialement',`attf100`='20250517',`att8`='1599',`att6`='[IDMYUSER]',`att9`='3175',`att3`='§terrasse§',`attdatmod`='202505171348',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '467') AND (id_type = '148') LIMIT 1 UID:--134827-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Barletta',`att2`='3174',`att90`='Bonjour,\r\nJe souhaiterais faire réaliser le nettoyage d’une terrasse de 36m2. \r\nCordialement',`attf100`='20250517',`att8`='1599',`att6`='[IDMYUSER]',`att9`='3175',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505171348',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '467') AND (id_type = '148') LIMIT 1 UID:--134827-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Barletta',`att2`='3174',`att90`='Bonjour,\r\nJe souhaiterais faire réaliser le nettoyage d’une terrasse de 36m2. \r\nCordialement',`attf100`='20250517',`att8`='1599',`att6`='0',`att9`='3175',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505171348',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '467') AND (id_type = '148') LIMIT 1 UID:--134827-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250517','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Barletta','\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-Barletta

\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:--134827-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '337') LIMIT 1 UID:--134827--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:--134827-- UPDATE `tier_att` SET `id_work`='367',`att2`='Barletta',`att3`='Alexandra',`att5`='0687065324',`att6`='a.barletta@outlook.fr',`att8`='3174',`att10`='[IDMYUSER]',`att4`='0687065324',`attdatmod`='202505171348',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3175') AND (id_type = '149') LIMIT 1 UID:--134827-- UPDATE `tier_att` SET `id_work`='259',`att3`='Alexandra',`att1`='Barletta',`att8`='non_défini',`att12`='a.barletta@outlook.fr',`att14`='92B Avenue De Strasbourg',`att7`='57070',`att17`='Metz',`att18`='France',`att5`='0687065324',`attf102`='20250517',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250517',`att19`='49.112342',`att20`='6.195944',`attf100`='1',`attdatmod`='202505171348',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3174') AND (id_type = '80') LIMIT 1 UID:--134827-- UPDATE `tier_att` SET `id_work`='259',`att3`='Alexandra',`att1`='Barletta',`att8`='non_défini',`att12`='a.barletta@outlook.fr',`att14`='92B Avenue De Strasbourg',`att7`='57070',`att17`='Metz',`att18`='France',`att5`='0687065324',`attf102`='20250517',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250517',`att19`='49.112342',`att20`='6.195944',`attf100`='1',`attdatmod`='202505171348',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3174') AND (id_type = '80') LIMIT 1 UID:--134827-- UPDATE `tier_att` SET `id_work`='259',`att3`='Alexandra',`att1`='Barletta',`att8`='non_défini',`att12`='a.barletta@outlook.fr',`att14`='92B Avenue De Strasbourg',`att7`='57070',`att17`='Metz',`att18`='France',`att5`='0687065324',`attf102`='20250517',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250517',`att19`='49.112342',`att20`='6.195944',`attf100`='1',`att6`='0687065324',`attdatmod`='202505171348',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3174') AND (id_type = '80') LIMIT 1 UID:--134827-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Barletta',`att2`='3174',`att90`='Bonjour,\r\nJe souhaiterais faire réaliser le nettoyage d’une terrasse de 36m2. \r\nCordialement',`attf100`='20250517',`att8`='1599',`att6`='0',`att9`='3175',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505171348',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '467') AND (id_type = '148') LIMIT 1 UID:--142656--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:--142656--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--145408-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505171454' ) UID:--145408-- UPDATE `tier_att` SET `id_work`='259',`att3`='Christel',`att1`='Diehl',`att8`='non_défini',`att12`='christel.diehl@univ-lorraine.fr',`att14`='12 rue Alphonse de Lamartine',`att7`='54410',`att17`='Laneuveville-devant-Nancy',`att18`='France',`att5`='0681880952',`attf102`='20250517',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250517',`attdatmod`='202505171454',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3176') AND (id_type = '80') LIMIT 1 UID:--145408-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3176','202505171454','202505171454' ) UID:--145408-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='12 rue Alphonse de Lamartine',`lig4`='54410',`lig5`='Laneuveville-devant-Nancy',`lig6`='France',`ligdatmod`='202505171454',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3176') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1600') LIMIT 1 UID:--145408-- UPDATE `tier_att` SET `id_work`='259',`att3`='Christel',`att1`='Diehl',`att8`='non_défini',`att12`='christel.diehl@univ-lorraine.fr',`att14`='12 rue Alphonse de Lamartine',`att7`='54410',`att17`='Laneuveville-devant-Nancy',`att18`='France',`att5`='0681880952',`attf102`='20250517',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250517',`att19`='48.655029',`att20`='6.214798',`attf100`='1',`attdatmod`='202505171454',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3176') AND (id_type = '80') LIMIT 1 UID:--145408-- UPDATE `tier_att` SET `id_work`='259',`att3`='Christel',`att1`='Diehl',`att8`='non_défini',`att12`='christel.diehl@univ-lorraine.fr',`att14`='12 rue Alphonse de Lamartine',`att7`='54410',`att17`='Laneuveville-devant-Nancy',`att18`='France',`att5`='0681880952',`attf102`='20250517',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250517',`att19`='48.655029',`att20`='6.214798',`attf100`='1',`attdatmod`='202505171454',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3176') AND (id_type = '80') LIMIT 1 UID:--145408-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505171454' ) UID:--145408-- UPDATE `tier_att` SET `id_work`='367',`att2`='Diehl',`att3`='Christel',`att5`='0681880952',`att6`='christel.diehl@univ-lorraine.fr',`att8`='3176',`att10`='[IDMYUSER]',`attdatmod`='202505171454',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3177') AND (id_type = '149') LIMIT 1 UID:--145408-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505171454' ) UID:--145408-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-',`att2`='3176',`attf100`='20250517',`att8`='1600',`att6`='[IDMYUSER]',`att9`='3177',`att3`='§terrasse§',`attdatmod`='202505171454',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '468') AND (id_type = '148') LIMIT 1 UID:--145408-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Diehl',`att2`='3176',`attf100`='20250517',`att8`='1600',`att6`='[IDMYUSER]',`att9`='3177',`att3`='§terrasse§',`attdatmod`='202505171454',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '468') AND (id_type = '148') LIMIT 1 UID:--145408-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Diehl',`att2`='3176',`attf100`='20250517',`att8`='1600',`att6`='[IDMYUSER]',`att9`='3177',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505171454',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '468') AND (id_type = '148') LIMIT 1 UID:--145408-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Diehl',`att2`='3176',`attf100`='20250517',`att8`='1600',`att6`='0',`att9`='3177',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505171454',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '468') AND (id_type = '148') LIMIT 1 UID:--145408-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250517','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Diehl','\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-Diehl

\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:--145408-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '338') LIMIT 1 UID:--145408--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:--145408-- UPDATE `tier_att` SET `id_work`='367',`att2`='Diehl',`att3`='Christel',`att5`='0681880952',`att6`='christel.diehl@univ-lorraine.fr',`att8`='3176',`att10`='[IDMYUSER]',`att4`='0681880952',`attdatmod`='202505171454',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3177') AND (id_type = '149') LIMIT 1 UID:--145408-- UPDATE `tier_att` SET `id_work`='259',`att3`='Christel',`att1`='Diehl',`att8`='non_défini',`att12`='christel.diehl@univ-lorraine.fr',`att14`='12 rue Alphonse de Lamartine',`att7`='54410',`att17`='Laneuveville-devant-Nancy',`att18`='France',`att5`='0681880952',`attf102`='20250517',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250517',`att19`='48.655029',`att20`='6.214798',`attf100`='1',`attdatmod`='202505171454',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3176') AND (id_type = '80') LIMIT 1 UID:--145408-- UPDATE `tier_att` SET `id_work`='259',`att3`='Christel',`att1`='Diehl',`att8`='non_défini',`att12`='christel.diehl@univ-lorraine.fr',`att14`='12 rue Alphonse de Lamartine',`att7`='54410',`att17`='Laneuveville-devant-Nancy',`att18`='France',`att5`='0681880952',`attf102`='20250517',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250517',`att19`='48.655029',`att20`='6.214798',`attf100`='1',`attdatmod`='202505171454',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3176') AND (id_type = '80') LIMIT 1 UID:--145408-- UPDATE `tier_att` SET `id_work`='259',`att3`='Christel',`att1`='Diehl',`att8`='non_défini',`att12`='christel.diehl@univ-lorraine.fr',`att14`='12 rue Alphonse de Lamartine',`att7`='54410',`att17`='Laneuveville-devant-Nancy',`att18`='France',`att5`='0681880952',`attf102`='20250517',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250517',`att19`='48.655029',`att20`='6.214798',`attf100`='1',`att6`='0681880952',`attdatmod`='202505171454',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3176') AND (id_type = '80') LIMIT 1 UID:--145408-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Diehl',`att2`='3176',`attf100`='20250517',`att8`='1600',`att6`='0',`att9`='3177',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505171454',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '468') AND (id_type = '148') LIMIT 1 UID:--153840--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:--153840--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--173218--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:--173218--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:10--173827--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--173827--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--212952-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505172129' ) UID:--212952-- UPDATE `tier_att` SET `id_work`='259',`att3`='Alain',`att1`='Aubry',`att8`='non_défini',`att12`='alainaubry@a2pfrance.fr',`att14`='8 Lotissement les Grands Clos, Éloyes, France',`att7`='88510',`att17`='Éloyes',`att18`='France',`att5`='0636365612',`attf102`='20250517',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250517',`attdatmod`='202505172129',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3178') AND (id_type = '80') LIMIT 1 UID:--212952-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3178','202505172129','202505172129' ) UID:--212952-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='8 Lotissement les Grands Clos, Éloyes, France',`lig4`='88510',`lig5`='Éloyes',`lig6`='France',`ligdatmod`='202505172129',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3178') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1601') LIMIT 1 UID:--212952-- UPDATE `tier_att` SET `id_work`='259',`att3`='Alain',`att1`='Aubry',`att8`='non_défini',`att12`='alainaubry@a2pfrance.fr',`att14`='8 Lotissement les Grands Clos, Éloyes, France',`att7`='88510',`att17`='Éloyes',`att18`='France',`att5`='0636365612',`attf102`='20250517',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250517',`att19`='48.09643',`att20`='6.612007',`attf100`='1',`attdatmod`='202505172129',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3178') AND (id_type = '80') LIMIT 1 UID:--212952-- UPDATE `tier_att` SET `id_work`='259',`att3`='Alain',`att1`='Aubry',`att8`='non_défini',`att12`='alainaubry@a2pfrance.fr',`att14`='8 Lotissement les Grands Clos, Éloyes, France',`att7`='88510',`att17`='Éloyes',`att18`='France',`att5`='0636365612',`attf102`='20250517',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250517',`att19`='48.09643',`att20`='6.612007',`attf100`='1',`attdatmod`='202505172129',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3178') AND (id_type = '80') LIMIT 1 UID:--212952-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505172129' ) UID:--212952-- UPDATE `tier_att` SET `id_work`='367',`att2`='Aubry',`att3`='Alain',`att5`='0636365612',`att6`='alainaubry@a2pfrance.fr',`att8`='3178',`att10`='[IDMYUSER]',`attdatmod`='202505172129',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3179') AND (id_type = '149') LIMIT 1 UID:--212952-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505172129' ) UID:--212952-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-',`att2`='3178',`att90`='Démoulage nettoyage toit',`attf100`='20250517',`att8`='1601',`att6`='[IDMYUSER]',`att9`='3179',`att3`='§toiture§',`attdatmod`='202505172129',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '469') AND (id_type = '148') LIMIT 1 UID:--212952-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Aubry',`att2`='3178',`att90`='Démoulage nettoyage toit',`attf100`='20250517',`att8`='1601',`att6`='[IDMYUSER]',`att9`='3179',`att3`='§toiture§',`attdatmod`='202505172129',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '469') AND (id_type = '148') LIMIT 1 UID:--212952-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Aubry',`att2`='3178',`att90`='Démoulage nettoyage toit',`attf100`='20250517',`att8`='1601',`att6`='[IDMYUSER]',`att9`='3179',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505172129',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '469') AND (id_type = '148') LIMIT 1 UID:--212952-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Aubry',`att2`='3178',`att90`='Démoulage nettoyage toit',`attf100`='20250517',`att8`='1601',`att6`='0',`att9`='3179',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505172129',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '469') AND (id_type = '148') LIMIT 1 UID:--212952-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250517','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Aubry','\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-Aubry

\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:--212952-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '341') LIMIT 1 UID:--212952--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:--212952-- UPDATE `tier_att` SET `id_work`='367',`att2`='Aubry',`att3`='Alain',`att5`='0636365612',`att6`='alainaubry@a2pfrance.fr',`att8`='3178',`att10`='[IDMYUSER]',`att4`='0636365612',`attdatmod`='202505172129',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3179') AND (id_type = '149') LIMIT 1 UID:--212952-- UPDATE `tier_att` SET `id_work`='259',`att3`='Alain',`att1`='Aubry',`att8`='non_défini',`att12`='alainaubry@a2pfrance.fr',`att14`='8 Lotissement les Grands Clos, Éloyes, France',`att7`='88510',`att17`='Éloyes',`att18`='France',`att5`='0636365612',`attf102`='20250517',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250517',`att19`='48.09643',`att20`='6.612007',`attf100`='1',`attdatmod`='202505172129',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3178') AND (id_type = '80') LIMIT 1 UID:--212952-- UPDATE `tier_att` SET `id_work`='259',`att3`='Alain',`att1`='Aubry',`att8`='non_défini',`att12`='alainaubry@a2pfrance.fr',`att14`='8 Lotissement les Grands Clos, Éloyes, France',`att7`='88510',`att17`='Éloyes',`att18`='France',`att5`='0636365612',`attf102`='20250517',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250517',`att19`='48.09643',`att20`='6.612007',`attf100`='1',`attdatmod`='202505172129',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3178') AND (id_type = '80') LIMIT 1 UID:--212952-- UPDATE `tier_att` SET `id_work`='259',`att3`='Alain',`att1`='Aubry',`att8`='non_défini',`att12`='alainaubry@a2pfrance.fr',`att14`='8 Lotissement les Grands Clos, Éloyes, France',`att7`='88510',`att17`='Éloyes',`att18`='France',`att5`='0636365612',`attf102`='20250517',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250517',`att19`='48.09643',`att20`='6.612007',`attf100`='1',`att6`='0636365612',`attdatmod`='202505172129',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3178') AND (id_type = '80') LIMIT 1 UID:--212952-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Aubry',`att2`='3178',`att90`='Démoulage nettoyage toit',`attf100`='20250517',`att8`='1601',`att6`='0',`att9`='3179',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505172129',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '469') AND (id_type = '148') LIMIT 1