UID:--075953--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:--075954--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--082319-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505020823' ) UID:--082319-- UPDATE `tier_att` SET `id_work`='259',`att3`='Jonathan',`att1`='Klein',`att8`='non_défini',`att12`='klein.jonathan.57@gmail.com',`att21`='4',`att14`='48 rue principale',`att7`='57220',`att17`='Mégange',`att18`='France',`att5`='0652252739',`attf102`='20250502',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250502',`att24`='3',`attdatmod`='202505020823',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '2998') AND (id_type = '80') LIMIT 1 UID:--082319-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','2998','202505020823','202505020823' ) UID:--082319-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='48 rue principale',`lig4`='57220',`lig5`='Mégange',`lig6`='France',`ligdatmod`='202505020823',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '2998') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1513') LIMIT 1 UID:--082319-- UPDATE `tier_lig` SET `lig2`='259',`ligdatmod`='202505020823',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '6') LIMIT 1 UID:--082319-- UPDATE `tier_att` SET `id_work`='259',`att3`='Jonathan',`att1`='Klein',`att8`='non_défini',`att12`='klein.jonathan.57@gmail.com',`att21`='4',`att14`='48 rue principale',`att7`='57220',`att17`='Mégange',`att18`='France',`att5`='0652252739',`attf102`='20250502',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250502',`att24`='3',`att19`='49.217045',`att20`='6.434574',`att22`='CL-METZ-259',`attf100`='1',`attdatmod`='202505020823',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '2998') AND (id_type = '80') LIMIT 1 UID:--082319-- UPDATE `tier_att` SET `id_work`='259',`att3`='Jonathan',`att1`='Klein',`att8`='non_défini',`att12`='klein.jonathan.57@gmail.com',`att21`='4',`att14`='48 rue principale',`att7`='57220',`att17`='Mégange',`att18`='France',`att5`='0652252739',`attf102`='20250502',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250502',`att24`='3',`att19`='49.217045',`att20`='6.434574',`att22`='-1',`attf100`='1',`attdatmod`='202505020823',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '2998') AND (id_type = '80') LIMIT 1 UID:--082319-- UPDATE `tier_att` SET `id_work`='259',`att3`='Jonathan',`att1`='Klein',`att8`='non_défini',`att12`='klein.jonathan.57@gmail.com',`att21`='4',`att14`='48 rue principale',`att7`='57220',`att17`='Mégange',`att18`='France',`att5`='0652252739',`attf102`='20250502',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250502',`att24`='3',`att19`='49.217045',`att20`='6.434574',`att22`='-1',`attf100`='1',`attdatmod`='202505020823',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '2998') AND (id_type = '80') LIMIT 1 UID:--082319-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505020823' ) UID:--082319-- UPDATE `tier_att` SET `id_work`='367',`att2`='Klein',`att3`='Jonathan',`att5`='0652252739',`att6`='klein.jonathan.57@gmail.com',`att8`='2998',`att10`='[IDMYUSER]',`attdatmod`='202505020823',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '2999') AND (id_type = '149') LIMIT 1 UID:--082319-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505020823' ) UID:--082319-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-',`att2`='2998',`attf100`='20250502',`att8`='1513',`att6`='[IDMYUSER]',`att9`='2999',`att3`='§façade§',`attdatmod`='202505020823',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '229') AND (id_type = '148') LIMIT 1 UID:--082320-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Klein',`att2`='2998',`attf100`='20250502',`att8`='1513',`att6`='[IDMYUSER]',`att9`='2999',`att3`='§façade§',`attdatmod`='202505020823',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '229') AND (id_type = '148') LIMIT 1 UID:--082320-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Klein',`att2`='2998',`attf100`='20250502',`att8`='1513',`att6`='[IDMYUSER]',`att9`='2999',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505020823',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '229') AND (id_type = '148') LIMIT 1 UID:--082320-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Klein',`att2`='2998',`attf100`='20250502',`att8`='1513',`att6`='0',`att9`='2999',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505020823',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '229') AND (id_type = '148') LIMIT 1 UID:--082320-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250502','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Klein','\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-Klein

\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:--082320-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '128') LIMIT 1 UID:--082320--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:--082320-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250502','','1','','Exteco','agence-metz@exteco.fr','','','Exteco - Nouvelle opportunité - OPP-Klein','\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-Klein

\r\n\r\n

\r\n Bonjour AYAD, (mail envoyé à la personne qui gère le client si le client existe déjà et qu\'il a déjà été affecté)

\r\n Une nouvelle opportunité vous a été affecté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:--082320-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '129') LIMIT 1 UID:--082320-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Klein',`att2`='2998',`attf100`='20250502',`att8`='1513',`att6`='4',`att9`='2999',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505020823',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '229') AND (id_type = '148') LIMIT 1 UID:--082320-- UPDATE `tier_lig` SET `lig2`='260',`ligdatmod`='202505020823',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '6') LIMIT 1 UID:--082320-- UPDATE `tier_att` SET `id_work`='367',`att2`='Klein',`att3`='Jonathan',`att5`='0652252739',`att6`='klein.jonathan.57@gmail.com',`att8`='2998',`att10`='[IDMYUSER]',`att4`='0652252739',`attdatmod`='202505020823',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '2999') AND (id_type = '149') LIMIT 1 UID:--082320-- UPDATE `tier_att` SET `id_work`='259',`att3`='Jonathan',`att1`='Klein',`att8`='non_défini',`att12`='klein.jonathan.57@gmail.com',`att21`='4',`att14`='48 rue principale',`att7`='57220',`att17`='Mégange',`att18`='France',`att5`='0652252739',`attf102`='20250502',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250502',`att24`='3',`att19`='49.217045',`att20`='6.434574',`att22`='CL-METZ-260',`attf100`='1',`attdatmod`='202505020823',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '2998') AND (id_type = '80') LIMIT 1 UID:--082320-- UPDATE `tier_att` SET `id_work`='259',`att3`='Jonathan',`att1`='Klein',`att8`='non_défini',`att12`='klein.jonathan.57@gmail.com',`att21`='4',`att14`='48 rue principale',`att7`='57220',`att17`='Mégange',`att18`='France',`att5`='0652252739',`attf102`='20250502',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250502',`att24`='3',`att19`='49.217045',`att20`='6.434574',`att22`='CL-EPI-2586',`attf100`='1',`attdatmod`='202505020823',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '2998') AND (id_type = '80') LIMIT 1 UID:--082320-- UPDATE `tier_att` SET `id_work`='259',`att3`='Jonathan',`att1`='Klein',`att8`='non_défini',`att12`='klein.jonathan.57@gmail.com',`att21`='4',`att14`='48 rue principale',`att7`='57220',`att17`='Mégange',`att18`='France',`att5`='0652252739',`attf102`='20250502',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250502',`att24`='3',`att19`='49.217045',`att20`='6.434574',`att22`='CL-EPI-2586',`attf100`='1',`attdatmod`='202505020823',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '2998') AND (id_type = '80') LIMIT 1 UID:--082320-- UPDATE `tier_att` SET `id_work`='259',`att3`='Jonathan',`att1`='Klein',`att8`='non_défini',`att12`='klein.jonathan.57@gmail.com',`att21`='4',`att14`='48 rue principale',`att7`='57220',`att17`='Mégange',`att18`='France',`att5`='0652252739',`attf102`='20250502',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250502',`att24`='3',`att19`='49.217045',`att20`='6.434574',`att22`='CL-EPI-2586',`attf100`='1',`att6`='0652252739',`attdatmod`='202505020823',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '2998') AND (id_type = '80') LIMIT 1 UID:--082320-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Klein',`att2`='2998',`attf100`='20250502',`att8`='1513',`att6`='4',`att9`='2999',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505020823',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '229') AND (id_type = '148') LIMIT 1 UID:--082503--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:--082503--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--091629--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 (90,88) ORDER BY pm.ordre UID:--091629--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--091705--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 (90,88) ORDER BY pm.ordre UID:--091705--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--091725--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 (90,88) ORDER BY pm.ordre UID:1--091725--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--091731--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:--091731--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:12--092029--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:12--092029--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--093049--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:--093049--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:2--093212--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:2--093212--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--093433--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:--093433--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--115755--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:--115755--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--125742-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505021257' ) UID:--125742-- UPDATE `tier_att` SET `id_work`='259',`att3`='Corinne',`att1`='Fresse',`att8`='non_défini',`att12`='didier.fresse0436@orange.fr',`att21`='2',`att14`='250 rue gravelier',`att7`='88150',`att17`='Bayecourt',`att18`='France',`att5`='0699533822',`attf102`='20250502',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250502',`att24`='2',`attdatmod`='202505021257',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3002') AND (id_type = '80') LIMIT 1 UID:--125742-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3002','202505021257','202505021257' ) UID:--125742-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='250 rue gravelier',`lig4`='88150',`lig5`='Bayecourt',`lig6`='France',`ligdatmod`='202505021257',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3002') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1515') LIMIT 1 UID:--125742-- UPDATE `tier_lig` SET `lig2`='2586',`ligdatmod`='202505021257',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '2') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '1') LIMIT 1 UID:--125742-- UPDATE `tier_att` SET `id_work`='259',`att3`='Corinne',`att1`='Fresse',`att8`='non_défini',`att12`='didier.fresse0436@orange.fr',`att21`='2',`att14`='250 rue gravelier',`att7`='88150',`att17`='Bayecourt',`att18`='France',`att5`='0699533822',`attf102`='20250502',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250502',`att24`='2',`att19`='48.267558',`att20`='6.482075',`att22`='CL-EPI-2586',`attf100`='1',`attdatmod`='202505021257',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3002') AND (id_type = '80') LIMIT 1 UID:--125742-- UPDATE `tier_att` SET `id_work`='259',`att3`='Corinne',`att1`='Fresse',`att8`='non_défini',`att12`='didier.fresse0436@orange.fr',`att21`='2',`att14`='250 rue gravelier',`att7`='88150',`att17`='Bayecourt',`att18`='France',`att5`='0699533822',`attf102`='20250502',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250502',`att24`='2',`att19`='48.267558',`att20`='6.482075',`att22`='-1',`attf100`='1',`attdatmod`='202505021257',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3002') AND (id_type = '80') LIMIT 1 UID:--125742-- UPDATE `tier_att` SET `id_work`='259',`att3`='Corinne',`att1`='Fresse',`att8`='non_défini',`att12`='didier.fresse0436@orange.fr',`att21`='2',`att14`='250 rue gravelier',`att7`='88150',`att17`='Bayecourt',`att18`='France',`att5`='0699533822',`attf102`='20250502',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250502',`att24`='2',`att19`='48.267558',`att20`='6.482075',`att22`='-1',`attf100`='1',`attdatmod`='202505021257',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3002') AND (id_type = '80') LIMIT 1 UID:--125742-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505021257' ) UID:--125742-- UPDATE `tier_att` SET `id_work`='367',`att2`='Fresse',`att3`='Corinne',`att5`='0699533822',`att6`='didier.fresse0436@orange.fr',`att8`='3002',`att10`='[IDMYUSER]',`attdatmod`='202505021257',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3003') AND (id_type = '149') LIMIT 1 UID:--125742-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505021257' ) UID:--125742-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-',`att2`='3002',`attf100`='20250502',`att8`='1515',`att6`='[IDMYUSER]',`att9`='3003',`att3`='§toiture§',`attdatmod`='202505021257',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '232') AND (id_type = '148') LIMIT 1 UID:--125742-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Fresse',`att2`='3002',`attf100`='20250502',`att8`='1515',`att6`='[IDMYUSER]',`att9`='3003',`att3`='§toiture§',`attdatmod`='202505021257',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '232') AND (id_type = '148') LIMIT 1 UID:--125742-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Fresse',`att2`='3002',`attf100`='20250502',`att8`='1515',`att6`='[IDMYUSER]',`att9`='3003',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505021257',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '232') AND (id_type = '148') LIMIT 1 UID:--125742-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Fresse',`att2`='3002',`attf100`='20250502',`att8`='1515',`att6`='0',`att9`='3003',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505021257',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '232') AND (id_type = '148') LIMIT 1 UID:--125742-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250502','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Fresse','\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-Fresse

\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:--125742-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '130') LIMIT 1 UID:--125742--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:--125742-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250502','','1','','Exteco','agence-epinal@exteco.fr','','','Exteco - Nouvelle opportunité - OPP-Fresse','\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-Fresse

\r\n\r\n

\r\n Bonjour PEULTIER, (mail envoyé à la personne qui gère le client si le client existe déjà et qu\'il a déjà été affecté)

\r\n Une nouvelle opportunité vous a été affecté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:--125742-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '131') LIMIT 1 UID:--125742-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Fresse',`att2`='3002',`attf100`='20250502',`att8`='1515',`att6`='2',`att9`='3003',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505021257',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '232') AND (id_type = '148') LIMIT 1 UID:--125742-- UPDATE `tier_lig` SET `lig2`='2587',`ligdatmod`='202505021257',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '2') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '1') LIMIT 1 UID:--125742-- UPDATE `tier_att` SET `id_work`='367',`att2`='Fresse',`att3`='Corinne',`att5`='0699533822',`att6`='didier.fresse0436@orange.fr',`att8`='3002',`att10`='[IDMYUSER]',`att4`='0699533822',`attdatmod`='202505021257',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3003') AND (id_type = '149') LIMIT 1 UID:--125742-- UPDATE `tier_att` SET `id_work`='259',`att3`='Corinne',`att1`='Fresse',`att8`='non_défini',`att12`='didier.fresse0436@orange.fr',`att21`='2',`att14`='250 rue gravelier',`att7`='88150',`att17`='Bayecourt',`att18`='France',`att5`='0699533822',`attf102`='20250502',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250502',`att24`='2',`att19`='48.267558',`att20`='6.482075',`att22`='CL-EPI-2587',`attf100`='1',`attdatmod`='202505021257',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3002') AND (id_type = '80') LIMIT 1 UID:--125742-- UPDATE `tier_att` SET `id_work`='259',`att3`='Corinne',`att1`='Fresse',`att8`='non_défini',`att12`='didier.fresse0436@orange.fr',`att21`='2',`att14`='250 rue gravelier',`att7`='88150',`att17`='Bayecourt',`att18`='France',`att5`='0699533822',`attf102`='20250502',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250502',`att24`='2',`att19`='48.267558',`att20`='6.482075',`att22`='CL-EPI-2588',`attf100`='1',`attdatmod`='202505021257',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3002') AND (id_type = '80') LIMIT 1 UID:--125742-- UPDATE `tier_att` SET `id_work`='259',`att3`='Corinne',`att1`='Fresse',`att8`='non_défini',`att12`='didier.fresse0436@orange.fr',`att21`='2',`att14`='250 rue gravelier',`att7`='88150',`att17`='Bayecourt',`att18`='France',`att5`='0699533822',`attf102`='20250502',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250502',`att24`='2',`att19`='48.267558',`att20`='6.482075',`att22`='CL-EPI-2588',`attf100`='1',`attdatmod`='202505021257',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3002') AND (id_type = '80') LIMIT 1 UID:--125742-- UPDATE `tier_att` SET `id_work`='259',`att3`='Corinne',`att1`='Fresse',`att8`='non_défini',`att12`='didier.fresse0436@orange.fr',`att21`='2',`att14`='250 rue gravelier',`att7`='88150',`att17`='Bayecourt',`att18`='France',`att5`='0699533822',`attf102`='20250502',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250502',`att24`='2',`att19`='48.267558',`att20`='6.482075',`att22`='CL-EPI-2588',`attf100`='1',`att6`='0699533822',`attdatmod`='202505021257',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3002') AND (id_type = '80') LIMIT 1 UID:--125742-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Fresse',`att2`='3002',`attf100`='20250502',`att8`='1515',`att6`='2',`att9`='3003',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505021257',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '232') AND (id_type = '148') LIMIT 1 UID:--140222--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:--140222--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--154443--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:--154443--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--155637--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:--155637--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--163659--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:--163659--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--172310--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:--172310--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre