UID:--085420--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:--085420--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--085428--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 (58,59,88) ORDER BY pm.ordre UID:--085428--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--091902--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:--091902--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:9--092056--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--092056--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--093828--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 (58,59,88) ORDER BY pm.ordre UID:--093828--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--093834--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:--093834--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--100204--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:--100204--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--101339--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:--101339--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--102736--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:--102736--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:2--110422--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--110422--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--110432--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 (58,59,88) ORDER BY pm.ordre UID:--110432--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--112517--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:--112517--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--112750--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:--112750--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--112911--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--112911--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--112933--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--112933--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--113009--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:--113009--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--113017--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--113017--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--113335--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:--113335--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--113419--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--113419--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--113450--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:--113450--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--113458--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 (58,59,88) ORDER BY pm.ordre UID:--113458--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--113913--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:--113913--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--114003--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:--114003--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--114114--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:--114114--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--114130--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--114130--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--114233--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:--114233--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--114624--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--114624--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--114735--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:--114735--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--114814--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--114814--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--114837--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 (58,59,88) ORDER BY pm.ordre UID:--114837--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--115121--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:--115121--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--115535--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--115535--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--115538--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--115538--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--115545-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505121155' ) UID:--115545-- UPDATE `tier_att` SET `id_work`='259',`att3`='Test-Morgane',`att1`='TOOSMART',`att8`='non_défini',`att12`='morgane@toosmart.io',`att14`='33 Rue Paul Duvivier',`att7`='69007',`att17`='Lyon',`att18`='France',`att5`='0748868107',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`attdatmod`='202505121155',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3087') AND (id_type = '80') LIMIT 1 UID:--115545-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3087','202505121155','202505121155' ) UID:--115545-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='33 Rue Paul Duvivier',`lig4`='69007',`lig5`='Lyon',`lig6`='France',`ligdatmod`='202505121155',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3087') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1555') LIMIT 1 UID:--115545-- UPDATE `tier_att` SET `id_work`='259',`att3`='Test-Morgane',`att1`='TOOSMART',`att8`='non_défini',`att12`='morgane@toosmart.io',`att14`='33 Rue Paul Duvivier',`att7`='69007',`att17`='Lyon',`att18`='France',`att5`='0748868107',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`att19`='45.741567',`att20`='4.848298',`attf100`='1',`attdatmod`='202505121155',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3087') AND (id_type = '80') LIMIT 1 UID:--115545-- UPDATE `tier_att` SET `id_work`='259',`att3`='Test-Morgane',`att1`='TOOSMART',`att8`='non_défini',`att12`='morgane@toosmart.io',`att14`='33 Rue Paul Duvivier',`att7`='69007',`att17`='Lyon',`att18`='France',`att5`='0748868107',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`att19`='45.741567',`att20`='4.848298',`attf100`='1',`attdatmod`='202505121155',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3087') AND (id_type = '80') LIMIT 1 UID:--115545-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505121155' ) UID:--115545-- UPDATE `tier_att` SET `id_work`='367',`att2`='TOOSMART',`att3`='Test-Morgane',`att5`='0748868107',`att6`='morgane@toosmart.io',`att8`='3087',`att10`='[IDMYUSER]',`attdatmod`='202505121155',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3088') AND (id_type = '149') LIMIT 1 UID:--115545-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505121155' ) UID:--115545-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-',`att2`='3087',`attf100`='20250512',`att8`='1555',`att6`='[IDMYUSER]',`att9`='3088',`att3`='§panneaux_photovoltaïques§',`attdatmod`='202505121155',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '338') AND (id_type = '148') LIMIT 1 UID:--115545-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-TOOSMART',`att2`='3087',`attf100`='20250512',`att8`='1555',`att6`='[IDMYUSER]',`att9`='3088',`att3`='§panneaux_photovoltaïques§',`attdatmod`='202505121155',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '338') AND (id_type = '148') LIMIT 1 UID:--115545-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-TOOSMART',`att2`='3087',`attf100`='20250512',`att8`='1555',`att6`='[IDMYUSER]',`att9`='3088',`att3`='§panneaux_photovoltaïques§',`att5`='',`att10`='non_défini',`attdatmod`='202505121155',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '338') AND (id_type = '148') LIMIT 1 UID:--115545-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-TOOSMART',`att2`='3087',`attf100`='20250512',`att8`='1555',`att6`='0',`att9`='3088',`att3`='§panneaux_photovoltaïques§',`att5`='',`att10`='non_défini',`attdatmod`='202505121155',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '338') AND (id_type = '148') LIMIT 1 UID:--115545-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250512','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-TOOSMART','\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-TOOSMART

\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:--115545-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '222') LIMIT 1 UID:--115545--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:--115545-- UPDATE `tier_att` SET `id_work`='367',`att2`='TOOSMART',`att3`='Test-Morgane',`att5`='0748868107',`att6`='morgane@toosmart.io',`att8`='3087',`att10`='[IDMYUSER]',`att4`='0748868107',`attdatmod`='202505121155',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3088') AND (id_type = '149') LIMIT 1 UID:--115545-- UPDATE `tier_att` SET `id_work`='259',`att3`='Test-Morgane',`att1`='TOOSMART',`att8`='non_défini',`att12`='morgane@toosmart.io',`att14`='33 Rue Paul Duvivier',`att7`='69007',`att17`='Lyon',`att18`='France',`att5`='0748868107',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`att19`='45.741567',`att20`='4.848298',`attf100`='1',`attdatmod`='202505121155',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3087') AND (id_type = '80') LIMIT 1 UID:--115545-- UPDATE `tier_att` SET `id_work`='259',`att3`='Test-Morgane',`att1`='TOOSMART',`att8`='non_défini',`att12`='morgane@toosmart.io',`att14`='33 Rue Paul Duvivier',`att7`='69007',`att17`='Lyon',`att18`='France',`att5`='0748868107',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`att19`='45.741567',`att20`='4.848298',`attf100`='1',`attdatmod`='202505121155',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3087') AND (id_type = '80') LIMIT 1 UID:--115545-- UPDATE `tier_att` SET `id_work`='259',`att3`='Test-Morgane',`att1`='TOOSMART',`att8`='non_défini',`att12`='morgane@toosmart.io',`att14`='33 Rue Paul Duvivier',`att7`='69007',`att17`='Lyon',`att18`='France',`att5`='0748868107',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`att19`='45.741567',`att20`='4.848298',`attf100`='1',`att6`='0748868107',`attdatmod`='202505121155',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3087') AND (id_type = '80') LIMIT 1 UID:--115545-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-TOOSMART',`att2`='3087',`attf100`='20250512',`att8`='1555',`att6`='0',`att9`='3088',`att3`='§panneaux_photovoltaïques§',`att5`='',`att10`='non_défini',`attdatmod`='202505121155',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '338') AND (id_type = '148') LIMIT 1 UID:1--115817--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--115817--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--121533--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:--121533--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--133615--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 (58,59,88) ORDER BY pm.ordre UID:--133615--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--133711--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:--133711--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--141143--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:--141143--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--141219--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--141219--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--141412--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:--141412--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--141429--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--141429--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--141934--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--141934--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--141944--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 (58,59,88) ORDER BY pm.ordre UID:--141944--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--141945-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505121419' ) UID:--141945-- UPDATE `tier_att` SET `id_work`='259',`att3`='Toosmart',`att1`='TEST1205',`att8`='non_défini',`att12`='test1205@toosmart.fr',`att14`='33 rue Paul Duvivier',`att7`='69003',`att17`='Lyon',`att18`='France',`att5`='0748868107',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`attdatmod`='202505121419',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3089') AND (id_type = '80') LIMIT 1 UID:--141945-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3089','202505121419','202505121419' ) UID:--141945-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='33 rue Paul Duvivier',`lig4`='69003',`lig5`='Lyon',`lig6`='France',`ligdatmod`='202505121419',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3089') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1556') LIMIT 1 UID:--141945-- UPDATE `tier_att` SET `id_work`='259',`att3`='Toosmart',`att1`='TEST1205',`att8`='non_défini',`att12`='test1205@toosmart.fr',`att14`='33 rue Paul Duvivier',`att7`='69003',`att17`='Lyon',`att18`='France',`att5`='0748868107',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`att19`='45.75251',`att20`='4.856402',`attf100`='1',`attdatmod`='202505121419',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3089') AND (id_type = '80') LIMIT 1 UID:--141945-- UPDATE `tier_att` SET `id_work`='259',`att3`='Toosmart',`att1`='TEST1205',`att8`='non_défini',`att12`='test1205@toosmart.fr',`att14`='33 rue Paul Duvivier',`att7`='69003',`att17`='Lyon',`att18`='France',`att5`='0748868107',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`att19`='45.75251',`att20`='4.856402',`attf100`='1',`attdatmod`='202505121419',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3089') AND (id_type = '80') LIMIT 1 UID:--141945-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505121419' ) UID:--141945-- UPDATE `tier_att` SET `id_work`='367',`att2`='TEST1205',`att3`='Toosmart',`att5`='0748868107',`att6`='test1205@toosmart.fr',`att8`='3089',`att10`='[IDMYUSER]',`attdatmod`='202505121419',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3090') AND (id_type = '149') LIMIT 1 UID:--141945-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505121419' ) UID:--141945-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-',`att2`='3089',`attf100`='20250512',`att8`='1556',`att6`='[IDMYUSER]',`att9`='3090',`att3`='§toiture§',`attdatmod`='202505121419',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '339') AND (id_type = '148') LIMIT 1 UID:--141945-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-TEST1205',`att2`='3089',`attf100`='20250512',`att8`='1556',`att6`='[IDMYUSER]',`att9`='3090',`att3`='§toiture§',`attdatmod`='202505121419',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '339') AND (id_type = '148') LIMIT 1 UID:--141945-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-TEST1205',`att2`='3089',`attf100`='20250512',`att8`='1556',`att6`='[IDMYUSER]',`att9`='3090',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505121419',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '339') AND (id_type = '148') LIMIT 1 UID:--141945-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-TEST1205',`att2`='3089',`attf100`='20250512',`att8`='1556',`att6`='0',`att9`='3090',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505121419',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '339') AND (id_type = '148') LIMIT 1 UID:--141945-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250512','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-TEST1205','\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-TEST1205

\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:--141945-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '223') LIMIT 1 UID:--141945--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:--141945-- UPDATE `tier_att` SET `id_work`='367',`att2`='TEST1205',`att3`='Toosmart',`att5`='0748868107',`att6`='test1205@toosmart.fr',`att8`='3089',`att10`='[IDMYUSER]',`att4`='0748868107',`attdatmod`='202505121419',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3090') AND (id_type = '149') LIMIT 1 UID:--141945-- UPDATE `tier_att` SET `id_work`='259',`att3`='Toosmart',`att1`='TEST1205',`att8`='non_défini',`att12`='test1205@toosmart.fr',`att14`='33 rue Paul Duvivier',`att7`='69003',`att17`='Lyon',`att18`='France',`att5`='0748868107',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`att19`='45.75251',`att20`='4.856402',`attf100`='1',`attdatmod`='202505121419',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3089') AND (id_type = '80') LIMIT 1 UID:--141945-- UPDATE `tier_att` SET `id_work`='259',`att3`='Toosmart',`att1`='TEST1205',`att8`='non_défini',`att12`='test1205@toosmart.fr',`att14`='33 rue Paul Duvivier',`att7`='69003',`att17`='Lyon',`att18`='France',`att5`='0748868107',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`att19`='45.75251',`att20`='4.856402',`attf100`='1',`attdatmod`='202505121419',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3089') AND (id_type = '80') LIMIT 1 UID:--141945-- UPDATE `tier_att` SET `id_work`='259',`att3`='Toosmart',`att1`='TEST1205',`att8`='non_défini',`att12`='test1205@toosmart.fr',`att14`='33 rue Paul Duvivier',`att7`='69003',`att17`='Lyon',`att18`='France',`att5`='0748868107',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`att19`='45.75251',`att20`='4.856402',`attf100`='1',`att6`='0748868107',`attdatmod`='202505121419',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3089') AND (id_type = '80') LIMIT 1 UID:--141945-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-TEST1205',`att2`='3089',`attf100`='20250512',`att8`='1556',`att6`='0',`att9`='3090',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505121419',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '339') AND (id_type = '148') LIMIT 1 UID:--142057--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:--142057--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--143834--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 (58,59,88) ORDER BY pm.ordre UID:--143834--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--143916--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:--143916--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--144116--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 (58,59,88) ORDER BY pm.ordre UID:--144116--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--145321--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:--145321--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--150436--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:--150436--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--151145--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:--151145--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--152554--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:--152554--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--154628--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:--154628--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--154933--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--154933--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:10--160532--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--160532--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--161535--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:--161535--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--163335--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:--163335--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:8--171347--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('195','1','2','Inscription au service Avance Immédiate-587 - METZ.pdf','20250512','875','8','-3','-2') UID:8--171347--UPDATE `file` SET `last`='1' , `size`='593071' , `fol_id`='2' , `esp_id`='1' WHERE file_id=294 UID:8--171347--UPDATE `file` SET `id_type`='165' , `id_obje`='350' , `specif`='' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=294 UID:8--171347--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=294 UID:8--171347--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1 UID:8--171347--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','8','2','294','195','Inscription au service Avance Immédiate-587 - METZ.pdf','1','20250512','17:13:47','upload') UID:--173247--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:--173247--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--173320--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:--173320--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:7--173928--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:7--173928--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--174052-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505121740' ) UID:--174052-- UPDATE `tier_att` SET `id_work`='259',`att3`='Toosmart',`att1`='TestToosmart',`att8`='non_défini',`att12`='testToosmart@toosmart.fr',`att14`='100 rue coste',`att7`='69300',`att17`='Lyon',`att18`='France',`att5`='0645787878',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`attdatmod`='202505121740',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3105') AND (id_type = '80') LIMIT 1 UID:--174052-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3105','202505121740','202505121740' ) UID:--174052-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='100 rue coste',`lig4`='69300',`lig5`='Lyon',`lig6`='France',`ligdatmod`='202505121740',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3105') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1564') LIMIT 1 UID:--174052-- UPDATE `tier_att` SET `id_work`='259',`att3`='Toosmart',`att1`='TestToosmart',`att8`='non_défini',`att12`='testToosmart@toosmart.fr',`att14`='100 rue coste',`att7`='69300',`att17`='Lyon',`att18`='France',`att5`='0645787878',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`att19`='45.790057',`att20`='4.836083',`attf100`='1',`attdatmod`='202505121740',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3105') AND (id_type = '80') LIMIT 1 UID:--174052-- UPDATE `tier_att` SET `id_work`='259',`att3`='Toosmart',`att1`='TestToosmart',`att8`='non_défini',`att12`='testToosmart@toosmart.fr',`att14`='100 rue coste',`att7`='69300',`att17`='Lyon',`att18`='France',`att5`='0645787878',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`att19`='45.790057',`att20`='4.836083',`attf100`='1',`attdatmod`='202505121740',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3105') AND (id_type = '80') LIMIT 1 UID:--174052-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505121740' ) UID:--174052-- UPDATE `tier_att` SET `id_work`='367',`att2`='TestToosmart',`att3`='Toosmart',`att5`='0645787878',`att6`='testToosmart@toosmart.fr',`att8`='3105',`att10`='[IDMYUSER]',`attdatmod`='202505121740',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3106') AND (id_type = '149') LIMIT 1 UID:--174052-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505121740' ) UID:--174052-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-',`att2`='3105',`attf100`='20250512',`att8`='1564',`att6`='[IDMYUSER]',`att9`='3106',`att3`='§terrasse§',`attdatmod`='202505121740',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '353') AND (id_type = '148') LIMIT 1 UID:--174052-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-TestToosmart',`att2`='3105',`attf100`='20250512',`att8`='1564',`att6`='[IDMYUSER]',`att9`='3106',`att3`='§terrasse§',`attdatmod`='202505121740',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '353') AND (id_type = '148') LIMIT 1 UID:--174052-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-TestToosmart',`att2`='3105',`attf100`='20250512',`att8`='1564',`att6`='[IDMYUSER]',`att9`='3106',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505121740',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '353') AND (id_type = '148') LIMIT 1 UID:--174052-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-TestToosmart',`att2`='3105',`attf100`='20250512',`att8`='1564',`att6`='0',`att9`='3106',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505121740',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '353') AND (id_type = '148') LIMIT 1 UID:--174052-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250512','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-TestToosmart','\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-TestToosmart

\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:--174052-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '232') LIMIT 1 UID:--174052--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:--174052-- UPDATE `tier_att` SET `id_work`='367',`att2`='TestToosmart',`att3`='Toosmart',`att5`='0645787878',`att6`='testToosmart@toosmart.fr',`att8`='3105',`att10`='[IDMYUSER]',`att4`='0645787878',`attdatmod`='202505121740',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3106') AND (id_type = '149') LIMIT 1 UID:--174052-- UPDATE `tier_att` SET `id_work`='259',`att3`='Toosmart',`att1`='TestToosmart',`att8`='non_défini',`att12`='testToosmart@toosmart.fr',`att14`='100 rue coste',`att7`='69300',`att17`='Lyon',`att18`='France',`att5`='0645787878',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`att19`='45.790057',`att20`='4.836083',`attf100`='1',`attdatmod`='202505121740',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3105') AND (id_type = '80') LIMIT 1 UID:--174052-- UPDATE `tier_att` SET `id_work`='259',`att3`='Toosmart',`att1`='TestToosmart',`att8`='non_défini',`att12`='testToosmart@toosmart.fr',`att14`='100 rue coste',`att7`='69300',`att17`='Lyon',`att18`='France',`att5`='0645787878',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`att19`='45.790057',`att20`='4.836083',`attf100`='1',`attdatmod`='202505121740',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3105') AND (id_type = '80') LIMIT 1 UID:--174052-- UPDATE `tier_att` SET `id_work`='259',`att3`='Toosmart',`att1`='TestToosmart',`att8`='non_défini',`att12`='testToosmart@toosmart.fr',`att14`='100 rue coste',`att7`='69300',`att17`='Lyon',`att18`='France',`att5`='0645787878',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`att19`='45.790057',`att20`='4.836083',`attf100`='1',`att6`='0645787878',`attdatmod`='202505121740',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3105') AND (id_type = '80') LIMIT 1 UID:--174052-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-TestToosmart',`att2`='3105',`attf100`='20250512',`att8`='1564',`att6`='0',`att9`='3106',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505121740',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '353') AND (id_type = '148') LIMIT 1 UID:1--174510--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--174510--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--174519-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505121745' ) UID:--174519-- UPDATE `tier_att` SET `id_work`='259',`att3`='Maria',`att1`='L',`att8`='non_défini',`att12`='goouuut@gmail.com',`att14`='28 Avenue Rameau',`att7`='54460',`att17`='Liverdun',`att18`='France',`att5`='0777497702',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`attdatmod`='202505121745',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3107') AND (id_type = '80') LIMIT 1 UID:--174519-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3107','202505121745','202505121745' ) UID:--174519-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='28 Avenue Rameau',`lig4`='54460',`lig5`='Liverdun',`lig6`='France',`ligdatmod`='202505121745',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3107') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1565') LIMIT 1 UID:--174519-- UPDATE `tier_att` SET `id_work`='259',`att3`='Maria',`att1`='L',`att8`='non_défini',`att12`='goouuut@gmail.com',`att14`='28 Avenue Rameau',`att7`='54460',`att17`='Liverdun',`att18`='France',`att5`='0777497702',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`att19`='48.750395',`att20`='6.086076',`attf100`='1',`attdatmod`='202505121745',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3107') AND (id_type = '80') LIMIT 1 UID:--174519-- UPDATE `tier_att` SET `id_work`='259',`att3`='Maria',`att1`='L',`att8`='non_défini',`att12`='goouuut@gmail.com',`att14`='28 Avenue Rameau',`att7`='54460',`att17`='Liverdun',`att18`='France',`att5`='0777497702',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`att19`='48.750395',`att20`='6.086076',`attf100`='1',`attdatmod`='202505121745',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3107') AND (id_type = '80') LIMIT 1 UID:--174519-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505121745' ) UID:--174519-- UPDATE `tier_att` SET `id_work`='367',`att2`='L',`att3`='Maria',`att5`='0777497702',`att6`='goouuut@gmail.com',`att8`='3107',`att10`='[IDMYUSER]',`attdatmod`='202505121745',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3108') AND (id_type = '149') LIMIT 1 UID:--174519-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505121745' ) UID:--174519-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-',`att2`='3107',`attf100`='20250512',`att8`='1565',`att6`='[IDMYUSER]',`att9`='3108',`att3`='§façade§',`attdatmod`='202505121745',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '354') AND (id_type = '148') LIMIT 1 UID:--174519-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-L',`att2`='3107',`attf100`='20250512',`att8`='1565',`att6`='[IDMYUSER]',`att9`='3108',`att3`='§façade§',`attdatmod`='202505121745',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '354') AND (id_type = '148') LIMIT 1 UID:--174519-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-L',`att2`='3107',`attf100`='20250512',`att8`='1565',`att6`='[IDMYUSER]',`att9`='3108',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505121745',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '354') AND (id_type = '148') LIMIT 1 UID:--174519-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-L',`att2`='3107',`attf100`='20250512',`att8`='1565',`att6`='0',`att9`='3108',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505121745',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '354') AND (id_type = '148') LIMIT 1 UID:--174519-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250512','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-L','\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-L

\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:--174519-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '234') LIMIT 1 UID:--174519--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:--174519-- UPDATE `tier_att` SET `id_work`='367',`att2`='L',`att3`='Maria',`att5`='0777497702',`att6`='goouuut@gmail.com',`att8`='3107',`att10`='[IDMYUSER]',`att4`='0777497702',`attdatmod`='202505121745',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3108') AND (id_type = '149') LIMIT 1 UID:--174519-- UPDATE `tier_att` SET `id_work`='259',`att3`='Maria',`att1`='L',`att8`='non_défini',`att12`='goouuut@gmail.com',`att14`='28 Avenue Rameau',`att7`='54460',`att17`='Liverdun',`att18`='France',`att5`='0777497702',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`att19`='48.750395',`att20`='6.086076',`attf100`='1',`attdatmod`='202505121745',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3107') AND (id_type = '80') LIMIT 1 UID:--174519-- UPDATE `tier_att` SET `id_work`='259',`att3`='Maria',`att1`='L',`att8`='non_défini',`att12`='goouuut@gmail.com',`att14`='28 Avenue Rameau',`att7`='54460',`att17`='Liverdun',`att18`='France',`att5`='0777497702',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`att19`='48.750395',`att20`='6.086076',`attf100`='1',`attdatmod`='202505121745',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3107') AND (id_type = '80') LIMIT 1 UID:--174519-- UPDATE `tier_att` SET `id_work`='259',`att3`='Maria',`att1`='L',`att8`='non_défini',`att12`='goouuut@gmail.com',`att14`='28 Avenue Rameau',`att7`='54460',`att17`='Liverdun',`att18`='France',`att5`='0777497702',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`att19`='48.750395',`att20`='6.086076',`attf100`='1',`att6`='0777497702',`attdatmod`='202505121745',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3107') AND (id_type = '80') LIMIT 1 UID:--174519-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-L',`att2`='3107',`attf100`='20250512',`att8`='1565',`att6`='0',`att9`='3108',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505121745',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '354') AND (id_type = '148') LIMIT 1 UID:--174546--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:--174546--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--174945-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505121749' ) UID:--174945-- UPDATE `tier_att` SET `id_work`='259',`att3`='toosmart',`att1`='Test',`att8`='professionnel',`att12`='toosmarttest@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250512',`attdatmod`='202505121749',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3109') AND (id_type = '80') LIMIT 1 UID:--174945-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3109','202505121749','202505121749' ) UID:--174945-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='66 rue coste',`lig4`='69300',`lig5`='Caluire et cuire',`lig6`='France',`ligdatmod`='202505121749',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3109') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1566') LIMIT 1 UID:--174945-- UPDATE `tier_att` SET `id_work`='259',`att3`='toosmart',`att1`='Test',`att8`='professionnel',`att12`='toosmarttest@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250512',`att19`='45.786944',`att20`='4.834154',`attf100`='1',`attdatmod`='202505121749',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3109') AND (id_type = '80') LIMIT 1 UID:--174945-- UPDATE `tier_att` SET `id_work`='259',`att3`='toosmart',`att1`='Test',`att8`='professionnel',`att12`='toosmarttest@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250512',`att19`='45.786944',`att20`='4.834154',`attf100`='1',`attdatmod`='202505121749',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3109') AND (id_type = '80') LIMIT 1 UID:--174945-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505121749' ) UID:--174945-- UPDATE `tier_att` SET `id_work`='367',`att2`='Test',`att3`='toosmart',`att5`='0909090909',`att6`='toosmarttest@toosmart.fr',`att8`='3109',`att10`='[IDMYUSER]',`attdatmod`='202505121749',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3110') AND (id_type = '149') LIMIT 1 UID:--174945-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505121749' ) UID:--174945-- UPDATE `vent_att` SET `att7`='facebook',`att1`='OPP-',`att2`='3109',`att90`='devis pour démoussage toiture',`attf100`='20250512',`att8`='1566',`att6`='[IDMYUSER]',`att9`='3110',`att3`='§toiture§',`attdatmod`='202505121749',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '355') AND (id_type = '148') LIMIT 1 UID:--174946-- UPDATE `vent_att` SET `att7`='facebook',`att1`='OPP-Test',`att2`='3109',`att90`='devis pour démoussage toiture',`attf100`='20250512',`att8`='1566',`att6`='[IDMYUSER]',`att9`='3110',`att3`='§toiture§',`attdatmod`='202505121749',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '355') AND (id_type = '148') LIMIT 1 UID:--174946-- UPDATE `vent_att` SET `att7`='facebook',`att1`='OPP-Test',`att2`='3109',`att90`='devis pour démoussage toiture',`attf100`='20250512',`att8`='1566',`att6`='[IDMYUSER]',`att9`='3110',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202505121749',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '355') AND (id_type = '148') LIMIT 1 UID:--174946-- UPDATE `vent_att` SET `att7`='facebook',`att1`='OPP-Test',`att2`='3109',`att90`='devis pour démoussage toiture',`attf100`='20250512',`att8`='1566',`att6`='0',`att9`='3110',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202505121749',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '355') AND (id_type = '148') LIMIT 1 UID:--174946-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250512','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Test','\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-Test

\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:--174946-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '235') LIMIT 1 UID:--174946--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:--174946-- UPDATE `tier_att` SET `id_work`='367',`att2`='Test',`att3`='toosmart',`att5`='0909090909',`att6`='toosmarttest@toosmart.fr',`att8`='3109',`att10`='[IDMYUSER]',`att4`='0909090909',`attdatmod`='202505121749',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3110') AND (id_type = '149') LIMIT 1 UID:--174946-- UPDATE `tier_att` SET `id_work`='259',`att3`='toosmart',`att1`='Test',`att8`='professionnel',`att12`='toosmarttest@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250512',`att19`='45.786944',`att20`='4.834154',`attf100`='1',`attdatmod`='202505121749',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3109') AND (id_type = '80') LIMIT 1 UID:--174946-- UPDATE `tier_att` SET `id_work`='259',`att3`='toosmart',`att1`='Test',`att8`='professionnel',`att12`='toosmarttest@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250512',`att19`='45.786944',`att20`='4.834154',`attf100`='1',`attdatmod`='202505121749',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3109') AND (id_type = '80') LIMIT 1 UID:--174946-- UPDATE `tier_att` SET `id_work`='259',`att3`='toosmart',`att1`='Test',`att8`='professionnel',`att12`='toosmarttest@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250512',`att19`='45.786944',`att20`='4.834154',`attf100`='1',`att6`='0909090909',`attdatmod`='202505121749',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3109') AND (id_type = '80') LIMIT 1 UID:--174946-- UPDATE `vent_att` SET `att7`='facebook',`att1`='OPP-Test',`att2`='3109',`att90`='devis pour démoussage toiture',`attf100`='20250512',`att8`='1566',`att6`='0',`att9`='3110',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202505121749',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '355') AND (id_type = '148') LIMIT 1 UID:1--174955--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--174955--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--175124--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--175124--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--175136--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--175136--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--175138--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--175138--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--175153-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505121751' ) UID:--175153-- UPDATE `tier_att` SET `id_work`='259',`att3`='testToosmart',`att1`='toosmartTest',`att8`='non_défini',`att12`='toosmarttestlead@toosmart.fr',`att14`='78 rue coste',`att7`='69300',`att17`='Lyon',`att18`='France',`att5`='0654567678',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`attdatmod`='202505121751',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3111') AND (id_type = '80') LIMIT 1 UID:--175153-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3111','202505121751','202505121751' ) UID:--175153-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='78 rue coste',`lig4`='69300',`lig5`='Lyon',`lig6`='France',`ligdatmod`='202505121751',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3111') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1567') LIMIT 1 UID:--175153-- UPDATE `tier_att` SET `id_work`='259',`att3`='testToosmart',`att1`='toosmartTest',`att8`='non_défini',`att12`='toosmarttestlead@toosmart.fr',`att14`='78 rue coste',`att7`='69300',`att17`='Lyon',`att18`='France',`att5`='0654567678',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`att19`='45.7879',`att20`='4.834609',`attf100`='1',`attdatmod`='202505121751',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3111') AND (id_type = '80') LIMIT 1 UID:--175153-- UPDATE `tier_att` SET `id_work`='259',`att3`='testToosmart',`att1`='toosmartTest',`att8`='non_défini',`att12`='toosmarttestlead@toosmart.fr',`att14`='78 rue coste',`att7`='69300',`att17`='Lyon',`att18`='France',`att5`='0654567678',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`att19`='45.7879',`att20`='4.834609',`attf100`='1',`attdatmod`='202505121751',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3111') AND (id_type = '80') LIMIT 1 UID:--175153-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505121751' ) UID:--175153-- UPDATE `tier_att` SET `id_work`='367',`att2`='toosmartTest',`att3`='testToosmart',`att5`='0654567678',`att6`='toosmarttestlead@toosmart.fr',`att8`='3111',`att10`='[IDMYUSER]',`attdatmod`='202505121751',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3112') AND (id_type = '149') LIMIT 1 UID:--175153-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505121751' ) UID:--175153-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-',`att2`='3111',`attf100`='20250512',`att8`='1567',`att6`='[IDMYUSER]',`att9`='3112',`att3`='§toiture§',`attdatmod`='202505121751',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '356') AND (id_type = '148') LIMIT 1 UID:--175153-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-toosmartTest',`att2`='3111',`attf100`='20250512',`att8`='1567',`att6`='[IDMYUSER]',`att9`='3112',`att3`='§toiture§',`attdatmod`='202505121751',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '356') AND (id_type = '148') LIMIT 1 UID:--175153-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-toosmartTest',`att2`='3111',`attf100`='20250512',`att8`='1567',`att6`='[IDMYUSER]',`att9`='3112',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505121751',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '356') AND (id_type = '148') LIMIT 1 UID:--175153-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-toosmartTest',`att2`='3111',`attf100`='20250512',`att8`='1567',`att6`='0',`att9`='3112',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505121751',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '356') AND (id_type = '148') LIMIT 1 UID:--175153-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250512','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-toosmartTest','\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-toosmartTest

\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:--175153-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '236') LIMIT 1 UID:--175153--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:--175153-- UPDATE `tier_att` SET `id_work`='367',`att2`='toosmartTest',`att3`='testToosmart',`att5`='0654567678',`att6`='toosmarttestlead@toosmart.fr',`att8`='3111',`att10`='[IDMYUSER]',`att4`='0654567678',`attdatmod`='202505121751',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3112') AND (id_type = '149') LIMIT 1 UID:--175153-- UPDATE `tier_att` SET `id_work`='259',`att3`='testToosmart',`att1`='toosmartTest',`att8`='non_défini',`att12`='toosmarttestlead@toosmart.fr',`att14`='78 rue coste',`att7`='69300',`att17`='Lyon',`att18`='France',`att5`='0654567678',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`att19`='45.7879',`att20`='4.834609',`attf100`='1',`attdatmod`='202505121751',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3111') AND (id_type = '80') LIMIT 1 UID:--175153-- UPDATE `tier_att` SET `id_work`='259',`att3`='testToosmart',`att1`='toosmartTest',`att8`='non_défini',`att12`='toosmarttestlead@toosmart.fr',`att14`='78 rue coste',`att7`='69300',`att17`='Lyon',`att18`='France',`att5`='0654567678',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`att19`='45.7879',`att20`='4.834609',`attf100`='1',`attdatmod`='202505121751',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3111') AND (id_type = '80') LIMIT 1 UID:--175153-- UPDATE `tier_att` SET `id_work`='259',`att3`='testToosmart',`att1`='toosmartTest',`att8`='non_défini',`att12`='toosmarttestlead@toosmart.fr',`att14`='78 rue coste',`att7`='69300',`att17`='Lyon',`att18`='France',`att5`='0654567678',`attf102`='20250512',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250512',`att19`='45.7879',`att20`='4.834609',`attf100`='1',`att6`='0654567678',`attdatmod`='202505121751',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3111') AND (id_type = '80') LIMIT 1 UID:--175153-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-toosmartTest',`att2`='3111',`attf100`='20250512',`att8`='1567',`att6`='0',`att9`='3112',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505121751',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '356') AND (id_type = '148') LIMIT 1 UID:1--175537--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--175537--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--225141--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:--225141-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202505122251' ) UID:--225141-- UPDATE `vent_att` SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='Maison individuelle- Façade - Ogy',`att90`='ejp6rptwx2rkf8z-',`attf100`='20250508',`att5`='3021',`att8`='8',`att9`='2049.7',`att10`='204.97',`att11`='2254.67',`att13`='',`att14`='307',`att15`='\n

Rainea Exteco Metz

\n
\n

10 Rue Rochambeau
\n 57000 Metz

\n

<',`att16`=' 7 chemin sous les vignes 57645 Ogy-montoy-flanville',`att18`='0',`att24`='2254.67',`att25`='7 chemin sous les vignes',`att26`='',`att27`='57645',`att28`='Ogy-montoy-flanville',`attdatmod`='202505122251',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '357') AND (id_type = '168') LIMIT 1 UID:--225141-- UPDATE `vent_att` SET `newobj`='new' WHERE 1=1 AND (id_type = '168') AND (id_vent = '357') LIMIT 1 UID:--225141-- UPDATE `tier_lig` SET `lig2`='4',`ligdatmod`='202505122251',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '8') LIMIT 1 UID:--225141-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-METZ-4',`att3`='',`att2`='Maison individuelle- Façade - Ogy',`att90`='ejp6rptwx2rkf8z-',`attf100`='20250508',`att5`='3021',`att8`='8',`att9`='2049.7',`att10`='204.97',`att11`='2254.67',`att13`='',`att14`='307',`att15`='\n

Rainea Exteco Metz

\n
\n

10 Rue Rochambeau
\n 57000 Metz

\n

<',`att16`=' 7 chemin sous les vignes 57645 Ogy-montoy-flanville',`att18`='0',`att24`='2254.67',`att25`='7 chemin sous les vignes',`att26`='',`att27`='57645',`att28`='Ogy-montoy-flanville',`attdatmod`='202505122251',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '357') AND (id_type = '168') LIMIT 1 UID:--225141-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','357','202505122251','202505122251' ) UID:--225141-- UPDATE `vent_lig` SET `actif`='1',`lig16`='Unité',`lig23`='1',`lig5`='10',`lig10`='euro',`lig90`='

Façade côté Jardin - Gauche

',`ligdatmod`='202505122251',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '357') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '538') LIMIT 1 UID:--225141-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','357','202505122251','202505122251' ) UID:--225141-- UPDATE `vent_lig` SET `actif`='1',`lig1`='18',`lig7`='78.00',`lig9`='18',`lig16`='M2',`lig3`='60',`lig2`='13.00',`lig5`='10',`lig4`='780.00',`lig8`='858.00',`lig10`='euro',`lig6`='858.00',`lig90`='<p>Nettoyage et désinfection du support via un procédé vapeur basse pression (de 30 à 60 bars maximum)</p>',`ligdatmod`='202505122251',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '357') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '539') LIMIT 1 UID:--225141-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','357','202505122251','202505122251' ) UID:--225141-- UPDATE `vent_lig` SET `actif`='1',`lig1`='26',`lig7`='41.40',`lig9`='26',`lig16`='M2',`lig3`='60',`lig2`='6.90',`lig5`='10',`lig4`='414.00',`lig8`='455.40',`lig10`='euro',`lig6`='455.40',`lig90`='<p>HydroGuard® Pro Formule Végétale protège durablement tous les matériaux minéraux poreux et permet de prévenir les principales causes de dégradations comme les infiltrations, érosion, cycle gel/dégel, formation de mousses et lichens... Il retarde le vieillissement du support et garde son aspect neuf plus longtemps.</p><p><br></p><p>HydroGuard® Pro Formule Végétale est un produit d’imprégnation incolore qui laisse respirer le matériau. Le support reste ainsi perméable à l’air et à la vapeur d’eau. De plus, il résiste parfaitement aux UV et ne jaunit pas dans le temps.</p><p><br></p><p>HydroGuard® Pro Formule Végétale est un produit biosourcé issu de la biomasse. Il a été formulé à base d’ingrédients d’origine végétale (colza, tournesol, canola, soja). L’utilisation de molécules végétales représente une alternative éco-responsable aux ressources fossiles dommageables à l’environnement.</p>',`ligdatmod`='202505122251',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '357') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '540') LIMIT 1 UID:--225141-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','357','202505122251','202505122251' ) UID:--225141-- UPDATE `vent_lig` SET `actif`='1',`lig16`='Unité',`lig23`='1',`lig5`='10',`lig10`='euro',`lig90`='

Façade côté piscine ( arrière )

',`ligdatmod`='202505122251',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '357') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '541') LIMIT 1 UID:--225141-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','357','202505122251','202505122251' ) UID:--225141-- UPDATE `vent_lig` SET `actif`='1',`lig1`='18',`lig7`='55.90',`lig9`='18',`lig16`='M2',`lig3`='43',`lig2`='13.00',`lig5`='10',`lig4`='559.00',`lig8`='614.90',`lig10`='euro',`lig6`='614.90',`lig90`='<p>Nettoyage et désinfection du support via un procédé vapeur basse pression (de 30 à 60 bars maximum)</p>',`ligdatmod`='202505122251',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '357') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '542') LIMIT 1 UID:--225141-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','357','202505122251','202505122251' ) UID:--225141-- UPDATE `vent_lig` SET `actif`='1',`lig1`='26',`lig7`='29.67',`lig9`='26',`lig16`='M2',`lig3`='43',`lig2`='6.90',`lig5`='10',`lig4`='296.70',`lig8`='326.37',`lig10`='euro',`lig6`='326.37',`lig90`='<p>HydroGuard® Pro Formule Végétale protège durablement tous les matériaux minéraux poreux et permet de prévenir les principales causes de dégradations comme les infiltrations, érosion, cycle gel/dégel, formation de mousses et lichens... Il retarde le vieillissement du support et garde son aspect neuf plus longtemps.</p><p><br></p><p>HydroGuard® Pro Formule Végétale est un produit d’imprégnation incolore qui laisse respirer le matériau. Le support reste ainsi perméable à l’air et à la vapeur d’eau. De plus, il résiste parfaitement aux UV et ne jaunit pas dans le temps.</p><p><br></p><p>HydroGuard® Pro Formule Végétale est un produit biosourcé issu de la biomasse. Il a été formulé à base d’ingrédients d’origine végétale (colza, tournesol, canola, soja). L’utilisation de molécules végétales représente une alternative éco-responsable aux ressources fossiles dommageables à l’environnement.</p>',`ligdatmod`='202505122251',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '357') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '543') LIMIT 1 UID:--225141-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('99','1','2','Devis_DV-METZ-16_12_05_2025_16h_30m_signe.pdf','20250512','62','devis_signe','168','357','-2','-1','' ) UID:--225141-- UPDATE `file` SET `size`='764747' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '300') LIMIT 1 UID:--225141-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('100','1','2','Attestation_fiscale_DV_METZ_16_08_05_2025_15h_36m_signe.pdf','20250512','515','attestation_signe','168','357','-2','-1','' ) UID:--225141-- UPDATE `file` SET `size`='813674' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '301') LIMIT 1 UID:--225141-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250512','','1','tete_de_reseau@toosmart.fr','Exteco','mariecaro_6@hotmail.com','','','Merci pour votre commande : Devis N°DV-METZ-16','\r\n\r\nNouveau Devis EXTECO\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 Merci pour votre commande (Devis N° DV-METZ-16)\r\n

\r\n\r\n

\r\n Bonjour Hurard,

Nous vous remercions pour votre commande. Vous trouverez ci-joint le devis que vous avez signé.

Nous prendrons contact avec vous rapidement pour programmer l\'intervention. En attendant, n\'hésitez pas à nous contacter si vous avez la moindre question ou besoin de clarification sur certains points.

\r\n Nous vous remercions de votre confiance et restons à votre disposition pour toute information complémentaire.

\r\n Cordialement,
\r\n

\r\n\r\n

\r\n Votre équipe Exteco

\r\n

\r\n
\r\n \r\n\r\n
\r\n
\r\n','/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/300-99-62-1§Devis_DV-METZ-16_12_05_2025_16h_30m_signe.pdf;/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/301-100-515-1§Attestation_fiscale_DV_METZ_16_08_05_2025_15h_36m_signe.pdf','0','v2017b' ) UID:--225141-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '237') LIMIT 1 UID:--225141-- UPDATE `vent_lig` SET `lig16`='Unité',`lig23`='1',`lig5`='10',`lig10`='euro',`lig90`='

Façade côté Jardin - Gauche

',`lig3`='1',`lig4`='0.00',`lig8`='0.00',`lig6`='0.00',`ligdatmod`='202505122251',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '357') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '538') LIMIT 1 UID:--225141-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-METZ-4',`att3`='',`att2`='Maison individuelle- Façade - Ogy',`att90`='ejp6rptwx2rkf8z-',`attf100`='20250508',`att5`='3021',`att8`='8',`att9`='2049.7',`att10`='204.97',`att11`='2254.67',`att13`='',`att14`='307',`att15`='\n

Rainea Exteco Metz

\n
\n

10 Rue Rochambeau
\n 57000 Metz

\n

<',`att16`=' 7 chemin sous les vignes 57645 Ogy-montoy-flanville',`att18`='0',`att24`='2254.67',`att25`='7 chemin sous les vignes',`att26`='',`att27`='57645',`att28`='Ogy-montoy-flanville',`att31`='204.97',`att29`='2049.7',`attdatmod`='202505122251',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '357') AND (id_type = '168') LIMIT 1 UID:--225142-- UPDATE `vent_att` SET `id_work`='417',`att4`='7',`attdatmod`='202505122251',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '243') AND (id_type = '148') LIMIT 1 UID:--225142-- UPDATE `vent_att` SET `id_work`='412',`attf107`='202505122251',`attdatmod`='202505122251',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '307') AND (id_type = '165') LIMIT 1 UID:--225142-- UPDATE `tier_att` SET `id_work`='205',`attdatmod`='202505122251',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3021') AND (id_type = '80') LIMIT 1 UID:--225259--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:--225259-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202505122252' ) UID:--225259-- UPDATE `vent_att` SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='Maison individuelle - Terrasses - Ogy',`att90`='jdnzvha4vzdrm8qs',`attf100`='20250508',`att5`='3021',`att8`='8',`att9`='1155',`att10`='115.5',`att11`='1270.5',`att13`='',`att14`='309',`att15`='\n

Rainea Exteco Metz

\n
\n

10 Rue Rochambeau
\n 57000 Metz

\n

<',`att16`=' 7 chemin sous les vignes 57645 Ogy-montoy-flanville',`att18`='0',`att24`='1270.5',`att25`='7 chemin sous les vignes',`att26`='',`att27`='57645',`att28`='Ogy-montoy-flanville',`attdatmod`='202505122252',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '358') AND (id_type = '168') LIMIT 1 UID:--225259-- UPDATE `vent_att` SET `newobj`='new' WHERE 1=1 AND (id_type = '168') AND (id_vent = '358') LIMIT 1 UID:--225259-- UPDATE `tier_lig` SET `lig2`='5',`ligdatmod`='202505122252',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '8') LIMIT 1 UID:--225259-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-METZ-5',`att3`='',`att2`='Maison individuelle - Terrasses - Ogy',`att90`='jdnzvha4vzdrm8qs',`attf100`='20250508',`att5`='3021',`att8`='8',`att9`='1155',`att10`='115.5',`att11`='1270.5',`att13`='',`att14`='309',`att15`='\n

Rainea Exteco Metz

\n
\n

10 Rue Rochambeau
\n 57000 Metz

\n

<',`att16`=' 7 chemin sous les vignes 57645 Ogy-montoy-flanville',`att18`='0',`att24`='1270.5',`att25`='7 chemin sous les vignes',`att26`='',`att27`='57645',`att28`='Ogy-montoy-flanville',`attdatmod`='202505122252',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '358') AND (id_type = '168') LIMIT 1 UID:--225259-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','358','202505122252','202505122252' ) UID:--225259-- UPDATE `vent_lig` SET `actif`='1',`lig16`='Unité',`lig23`='1',`lig5`='10',`lig10`='euro',`lig90`='

Terrasse arrière - Dalle Ciment

',`ligdatmod`='202505122252',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '358') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '544') LIMIT 1 UID:--225259-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','358','202505122252','202505122252' ) UID:--225259-- UPDATE `vent_lig` SET `actif`='1',`lig1`='122',`lig7`='115.50',`lig9`='122',`lig16`='M2',`lig3`='55',`lig2`='21.00',`lig5`='10',`lig4`='1155.00',`lig8`='1270.50',`lig10`='euro',`lig6`='1270.50',`lig90`='

Terrasse arrière :

Nettoyage et désinfection du support via un procédé vapeur basse pression 

',`ligdatmod`='202505122252',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '358') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '545') LIMIT 1 UID:--225259-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('101','1','2','Devis_DV-METZ-17_12_05_2025_16h_35m_signe.pdf','20250512','280','devis_signe','168','358','-2','-1','' ) UID:--225259-- UPDATE `file` SET `size`='532754' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '302') LIMIT 1 UID:--225259-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('102','1','2','Attestation_fiscale_DV_METZ_17_08_05_2025_15h_43m_signe.pdf','20250512','676','attestation_signe','168','358','-2','-1','' ) UID:--225259-- UPDATE `file` SET `size`='813676' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '303') LIMIT 1 UID:--225259-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250512','','1','tete_de_reseau@toosmart.fr','Exteco','mariecaro_6@hotmail.com','','','Merci pour votre commande : Devis N°DV-METZ-17','\r\n\r\nNouveau Devis EXTECO\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 Merci pour votre commande (Devis N° DV-METZ-17)\r\n

\r\n\r\n

\r\n Bonjour Hurard,

Nous vous remercions pour votre commande. Vous trouverez ci-joint le devis que vous avez signé.

Nous prendrons contact avec vous rapidement pour programmer l\'intervention. En attendant, n\'hésitez pas à nous contacter si vous avez la moindre question ou besoin de clarification sur certains points.

\r\n Nous vous remercions de votre confiance et restons à votre disposition pour toute information complémentaire.

\r\n Cordialement,
\r\n

\r\n\r\n

\r\n Votre équipe Exteco

\r\n

\r\n
\r\n \r\n\r\n
\r\n
\r\n','/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/302-101-280-1§Devis_DV-METZ-17_12_05_2025_16h_35m_signe.pdf;/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/303-102-676-1§Attestation_fiscale_DV_METZ_17_08_05_2025_15h_43m_signe.pdf','0','v2017b' ) UID:--225259-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '238') LIMIT 1 UID:--225300-- UPDATE `vent_lig` SET `lig16`='Unité',`lig23`='1',`lig5`='10',`lig10`='euro',`lig90`='

Terrasse arrière - Dalle Ciment

',`lig3`='1',`lig4`='0.00',`lig8`='0.00',`lig6`='0.00',`ligdatmod`='202505122253',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '358') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '544') LIMIT 1 UID:--225300-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-METZ-5',`att3`='',`att2`='Maison individuelle - Terrasses - Ogy',`att90`='jdnzvha4vzdrm8qs',`attf100`='20250508',`att5`='3021',`att8`='8',`att9`='1155',`att10`='115.5',`att11`='1270.5',`att13`='',`att14`='309',`att15`='\n

Rainea Exteco Metz

\n
\n

10 Rue Rochambeau
\n 57000 Metz

\n

<',`att16`=' 7 chemin sous les vignes 57645 Ogy-montoy-flanville',`att18`='0',`att24`='1270.5',`att25`='7 chemin sous les vignes',`att26`='',`att27`='57645',`att28`='Ogy-montoy-flanville',`att31`='115.5',`att29`='1155',`attdatmod`='202505122253',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '358') AND (id_type = '168') LIMIT 1 UID:--225300-- UPDATE `vent_att` SET `id_work`='417',`att4`='4',`attdatmod`='202505122253',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '308') AND (id_type = '148') LIMIT 1 UID:--225300-- UPDATE `vent_att` SET `id_work`='412',`attf107`='202505122253',`attdatmod`='202505122253',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '309') AND (id_type = '165') LIMIT 1