UID:--084003-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505150840' ) UID:--084003-- UPDATE `tier_att` SET `id_work`='259',`att3`='Norbert',`att1`='PLOT',`att8`='non_défini',`att12`='plot.perso@gmail.com',`att14`='87 avenue de la Vallée Verte',`att7`='85800',`att17`='Saint-Gilles-Croix-de-Vie',`att18`='France',`att5`='0624974420',`attf102`='20250515',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250515',`attdatmod`='202505150840',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3146') AND (id_type = '80') LIMIT 1 UID:--084003-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3146','202505150840','202505150840' ) UID:--084003-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='87 avenue de la Vallée Verte',`lig4`='85800',`lig5`='Saint-Gilles-Croix-de-Vie',`lig6`='France',`ligdatmod`='202505150840',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3146') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1584') LIMIT 1 UID:--084003-- UPDATE `tier_att` SET `id_work`='259',`att3`='Norbert',`att1`='PLOT',`att8`='non_défini',`att12`='plot.perso@gmail.com',`att14`='87 avenue de la Vallée Verte',`att7`='85800',`att17`='Saint-Gilles-Croix-de-Vie',`att18`='France',`att5`='0624974420',`attf102`='20250515',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250515',`att19`='46.684224',`att20`='-1.92007',`attf100`='1',`attdatmod`='202505150840',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3146') AND (id_type = '80') LIMIT 1 UID:--084003-- UPDATE `tier_att` SET `id_work`='259',`att3`='Norbert',`att1`='PLOT',`att8`='non_défini',`att12`='plot.perso@gmail.com',`att14`='87 avenue de la Vallée Verte',`att7`='85800',`att17`='Saint-Gilles-Croix-de-Vie',`att18`='France',`att5`='0624974420',`attf102`='20250515',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250515',`att19`='46.684224',`att20`='-1.92007',`attf100`='1',`attdatmod`='202505150840',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3146') AND (id_type = '80') LIMIT 1 UID:--084003-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505150840' ) UID:--084003-- UPDATE `tier_att` SET `id_work`='367',`att2`='PLOT',`att3`='Norbert',`att5`='0624974420',`att6`='plot.perso@gmail.com',`att8`='3146',`att10`='[IDMYUSER]',`attdatmod`='202505150840',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3147') AND (id_type = '149') LIMIT 1 UID:--084003-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505150840' ) UID:--084003-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-',`att2`='3146',`att90`='Pour nettoyage toit en tuiles',`attf100`='20250515',`att8`='1584',`att6`='[IDMYUSER]',`att9`='3147',`att3`='§toiture§',`attdatmod`='202505150840',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '413') AND (id_type = '148') LIMIT 1 UID:--084003-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-PLOT',`att2`='3146',`att90`='Pour nettoyage toit en tuiles',`attf100`='20250515',`att8`='1584',`att6`='[IDMYUSER]',`att9`='3147',`att3`='§toiture§',`attdatmod`='202505150840',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '413') AND (id_type = '148') LIMIT 1 UID:--084003-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-PLOT',`att2`='3146',`att90`='Pour nettoyage toit en tuiles',`attf100`='20250515',`att8`='1584',`att6`='[IDMYUSER]',`att9`='3147',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505150840',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '413') AND (id_type = '148') LIMIT 1 UID:--084003-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-PLOT',`att2`='3146',`att90`='Pour nettoyage toit en tuiles',`attf100`='20250515',`att8`='1584',`att6`='0',`att9`='3147',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505150840',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '413') AND (id_type = '148') LIMIT 1 UID:--084003-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250515','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-PLOT','\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-PLOT

\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:--084003-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '288') LIMIT 1 UID:--084003--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:--084003-- UPDATE `tier_att` SET `id_work`='367',`att2`='PLOT',`att3`='Norbert',`att5`='0624974420',`att6`='plot.perso@gmail.com',`att8`='3146',`att10`='[IDMYUSER]',`att4`='0624974420',`attdatmod`='202505150840',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3147') AND (id_type = '149') LIMIT 1 UID:--084003-- UPDATE `tier_att` SET `id_work`='259',`att3`='Norbert',`att1`='PLOT',`att8`='non_défini',`att12`='plot.perso@gmail.com',`att14`='87 avenue de la Vallée Verte',`att7`='85800',`att17`='Saint-Gilles-Croix-de-Vie',`att18`='France',`att5`='0624974420',`attf102`='20250515',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250515',`att19`='46.684224',`att20`='-1.92007',`attf100`='1',`attdatmod`='202505150840',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3146') AND (id_type = '80') LIMIT 1 UID:--084003-- UPDATE `tier_att` SET `id_work`='259',`att3`='Norbert',`att1`='PLOT',`att8`='non_défini',`att12`='plot.perso@gmail.com',`att14`='87 avenue de la Vallée Verte',`att7`='85800',`att17`='Saint-Gilles-Croix-de-Vie',`att18`='France',`att5`='0624974420',`attf102`='20250515',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250515',`att19`='46.684224',`att20`='-1.92007',`attf100`='1',`attdatmod`='202505150840',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3146') AND (id_type = '80') LIMIT 1 UID:--084003-- UPDATE `tier_att` SET `id_work`='259',`att3`='Norbert',`att1`='PLOT',`att8`='non_défini',`att12`='plot.perso@gmail.com',`att14`='87 avenue de la Vallée Verte',`att7`='85800',`att17`='Saint-Gilles-Croix-de-Vie',`att18`='France',`att5`='0624974420',`attf102`='20250515',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250515',`att19`='46.684224',`att20`='-1.92007',`attf100`='1',`att6`='0624974420',`attdatmod`='202505150840',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3146') AND (id_type = '80') LIMIT 1 UID:--084003-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-PLOT',`att2`='3146',`att90`='Pour nettoyage toit en tuiles',`attf100`='20250515',`att8`='1584',`att6`='0',`att9`='3147',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505150840',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '413') AND (id_type = '148') LIMIT 1 UID:--084424--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:--084424--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--085430--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:--085430--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--085514--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:--085514--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--085653--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:--085653--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--085916--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:--085916--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--090606--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:--090606--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--090747--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--090747--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:2--090759--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('241','1','2','Inscription au service Avance Immédiate-586 - EPINAL.pdf','20250515','747','2','-3','-2') UID:2--090759--UPDATE `file` SET `last`='1' , `size`='593158' , `fol_id`='2' , `esp_id`='1' WHERE file_id=376 UID:2--090759--UPDATE `file` SET `id_type`='165' , `id_obje`='416' , `specif`='' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=376 UID:2--090759--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=376 UID:2--090759--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1 UID:2--090759--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','2','2','376','241','Inscription au service Avance Immédiate-586 - EPINAL.pdf','1','20250515','09:07:59','upload') UID:1--091628--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--091628--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--092110--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:--092110--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:8--092307--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('246','1','2','Inscription au service Avance Immédiate-587 - METZ.pdf','20250515','360','8','-3','-2') UID:8--092307--UPDATE `file` SET `last`='1' , `size`='593071' , `fol_id`='2' , `esp_id`='1' WHERE file_id=384 UID:8--092307--UPDATE `file` SET `id_type`='165' , `id_obje`='418' , `specif`='' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=384 UID:8--092307--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=384 UID:8--092307--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1 UID:8--092307--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','8','2','384','246','Inscription au service Avance Immédiate-587 - METZ.pdf','1','20250515','09:23:07','upload') UID:1--092523--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--092523--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--092835--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:--092835--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--093712--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:--093712--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--093842--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:--093842--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--094255--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:--094255--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--095129--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:--095129--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--100149--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:--100149--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--100213--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:--100213--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--100236--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--100236--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--103920--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:--103920--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--110514--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:--110514--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:8--110652--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('250','1','2','img010.jpg','20250515','40','8','-3','-2') UID:8--110652--UPDATE `file` SET `last`='1' , `size`='233460' , `fol_id`='2' , `esp_id`='1' WHERE file_id=389 UID:8--110652--UPDATE `file` SET `id_type`='168' , `id_obje`='421' , `specif`='devis_signe' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=389 UID:8--110652--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=389 UID:8--110652--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1 UID:8--110652--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','8','2','389','250','img010.jpg','1','20250515','11:06:52','upload') UID:8--110722--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('251','1','2','img011.jpg','20250515','801','8','-3','-2') UID:8--110722--UPDATE `file` SET `last`='1' , `size`='417465' , `fol_id`='2' , `esp_id`='1' WHERE file_id=390 UID:8--110722--UPDATE `file` SET `id_type`='168' , `id_obje`='422' , `specif`='attestation_signe' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=390 UID:8--110722--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=390 UID:8--110722--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1 UID:8--110722--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','8','2','390','251','img011.jpg','1','20250515','11:07:22','upload') UID:8--110730--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('252','1','2','img010.jpg','20250515','282','8','-3','-2') UID:8--110730--UPDATE `file` SET `last`='1' , `size`='233460' , `fol_id`='2' , `esp_id`='1' WHERE file_id=391 UID:8--110730--UPDATE `file` SET `id_type`='168' , `id_obje`='422' , `specif`='devis_signe' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=391 UID:8--110730--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=391 UID:8--110730--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1 UID:8--110730--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','8','2','391','252','img010.jpg','1','20250515','11:07:30','upload') UID:8--110734--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:8--110734--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--111115--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:--111115--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--111236--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:--111236--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:2--112156--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--112156--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--112200--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:--112200--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:2--112448--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('255','1','2','IMG_2293 (1).jpg','20250515','764','2','-3','-2') UID:2--112448--UPDATE `file` SET `last`='1' , `size`='2702669' , `fol_id`='2' , `esp_id`='1' WHERE file_id=394 UID:2--112448--UPDATE `file` SET `id_type`='168' , `id_obje`='425' , `specif`='attestation_signe' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=394 UID:2--112448--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=394 UID:2--112448--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1 UID:2--112448--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','2','2','394','255','IMG_2293 (1).jpg','1','20250515','11:24:48','upload') UID:2--112516--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('256','1','2','IMG_2293 (1).jpg','20250515','387','2','-3','-2') UID:2--112516--UPDATE `file` SET `last`='1' , `size`='2702669' , `fol_id`='2' , `esp_id`='1' WHERE file_id=395 UID:2--112516--UPDATE `file` SET `id_type`='168' , `id_obje`='426' , `specif`='devis_signe' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=395 UID:2--112516--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=395 UID:2--112516--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1 UID:2--112516--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','2','2','395','256','IMG_2293 (1).jpg','1','20250515','11:25:16','upload') UID:2--112521--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('257','1','2','IMG_2293 (1).jpg','20250515','253','2','-3','-2') UID:2--112521--UPDATE `file` SET `last`='1' , `size`='2702669' , `fol_id`='2' , `esp_id`='1' WHERE file_id=396 UID:2--112521--UPDATE `file` SET `id_type`='168' , `id_obje`='426' , `specif`='attestation_signe' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=396 UID:2--112521--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=396 UID:2--112521--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1 UID:2--112521--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','2','2','396','257','IMG_2293 (1).jpg','1','20250515','11:25:21','upload') UID:2--112526--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--112526--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:8--112926--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('258','1','2','Inscription au service Avance Immédiate-587 - METZ.pdf','20250515','662','8','-3','-2') UID:8--112926--UPDATE `file` SET `last`='1' , `size`='593071' , `fol_id`='2' , `esp_id`='1' WHERE file_id=398 UID:8--112926--UPDATE `file` SET `id_type`='165' , `id_obje`='428' , `specif`='' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=398 UID:8--112926--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=398 UID:8--112926--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1 UID:8--112926--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','8','2','398','258','Inscription au service Avance Immédiate-587 - METZ.pdf','1','20250515','11:29:26','upload') UID:--114617--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:--114617--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--115049-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505151150' ) UID:--115049-- UPDATE `tier_att` SET `id_work`='259',`att3`='Sylvie',`att1`='Mervelay',`att8`='non_défini',`att12`='mervelaysylvie@outlook.com',`att14`='45 rue du moulin',`att7`='88470',`att17`='Saint Michel sur Meurthe',`att18`='France',`att5`='0609057643',`attf102`='20250515',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250515',`attdatmod`='202505151150',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3150') AND (id_type = '80') LIMIT 1 UID:--115049-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3150','202505151150','202505151150' ) UID:--115049-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='45 rue du moulin',`lig4`='88470',`lig5`='Saint Michel sur Meurthe',`lig6`='France',`ligdatmod`='202505151150',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3150') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1586') LIMIT 1 UID:--115049-- UPDATE `tier_att` SET `id_work`='259',`att3`='Sylvie',`att1`='Mervelay',`att8`='non_défini',`att12`='mervelaysylvie@outlook.com',`att14`='45 rue du moulin',`att7`='88470',`att17`='Saint Michel sur Meurthe',`att18`='France',`att5`='0609057643',`attf102`='20250515',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250515',`att19`='48.317195',`att20`='6.884596',`attf100`='1',`attdatmod`='202505151150',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3150') AND (id_type = '80') LIMIT 1 UID:--115049-- UPDATE `tier_att` SET `id_work`='259',`att3`='Sylvie',`att1`='Mervelay',`att8`='non_défini',`att12`='mervelaysylvie@outlook.com',`att14`='45 rue du moulin',`att7`='88470',`att17`='Saint Michel sur Meurthe',`att18`='France',`att5`='0609057643',`attf102`='20250515',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250515',`att19`='48.317195',`att20`='6.884596',`attf100`='1',`attdatmod`='202505151150',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3150') AND (id_type = '80') LIMIT 1 UID:--115049-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505151150' ) UID:--115049-- UPDATE `tier_att` SET `id_work`='367',`att2`='Mervelay',`att3`='Sylvie',`att5`='0609057643',`att6`='mervelaysylvie@outlook.com',`att8`='3150',`att10`='[IDMYUSER]',`attdatmod`='202505151150',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3151') AND (id_type = '149') LIMIT 1 UID:--115049-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505151150' ) UID:--115049-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-',`att2`='3150',`att90`='Bonjour \r\nJe voudrais un devis pour le démoussage de ma toiture.',`attf100`='20250515',`att8`='1586',`att6`='[IDMYUSER]',`att9`='3151',`att3`='§toiture§',`attdatmod`='202505151150',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '429') AND (id_type = '148') LIMIT 1 UID:--115049-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Mervelay',`att2`='3150',`att90`='Bonjour \r\nJe voudrais un devis pour le démoussage de ma toiture.',`attf100`='20250515',`att8`='1586',`att6`='[IDMYUSER]',`att9`='3151',`att3`='§toiture§',`attdatmod`='202505151150',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '429') AND (id_type = '148') LIMIT 1 UID:--115049-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Mervelay',`att2`='3150',`att90`='Bonjour \r\nJe voudrais un devis pour le démoussage de ma toiture.',`attf100`='20250515',`att8`='1586',`att6`='[IDMYUSER]',`att9`='3151',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505151150',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '429') AND (id_type = '148') LIMIT 1 UID:--115049-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Mervelay',`att2`='3150',`att90`='Bonjour \r\nJe voudrais un devis pour le démoussage de ma toiture.',`attf100`='20250515',`att8`='1586',`att6`='0',`att9`='3151',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505151150',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '429') AND (id_type = '148') LIMIT 1 UID:--115049-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250515','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Mervelay','\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-Mervelay

\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:--115049-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '301') LIMIT 1 UID:--115049--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:--115049-- UPDATE `tier_att` SET `id_work`='367',`att2`='Mervelay',`att3`='Sylvie',`att5`='0609057643',`att6`='mervelaysylvie@outlook.com',`att8`='3150',`att10`='[IDMYUSER]',`att4`='0609057643',`attdatmod`='202505151150',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3151') AND (id_type = '149') LIMIT 1 UID:--115049-- UPDATE `tier_att` SET `id_work`='259',`att3`='Sylvie',`att1`='Mervelay',`att8`='non_défini',`att12`='mervelaysylvie@outlook.com',`att14`='45 rue du moulin',`att7`='88470',`att17`='Saint Michel sur Meurthe',`att18`='France',`att5`='0609057643',`attf102`='20250515',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250515',`att19`='48.317195',`att20`='6.884596',`attf100`='1',`attdatmod`='202505151150',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3150') AND (id_type = '80') LIMIT 1 UID:--115049-- UPDATE `tier_att` SET `id_work`='259',`att3`='Sylvie',`att1`='Mervelay',`att8`='non_défini',`att12`='mervelaysylvie@outlook.com',`att14`='45 rue du moulin',`att7`='88470',`att17`='Saint Michel sur Meurthe',`att18`='France',`att5`='0609057643',`attf102`='20250515',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250515',`att19`='48.317195',`att20`='6.884596',`attf100`='1',`attdatmod`='202505151150',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3150') AND (id_type = '80') LIMIT 1 UID:--115049-- UPDATE `tier_att` SET `id_work`='259',`att3`='Sylvie',`att1`='Mervelay',`att8`='non_défini',`att12`='mervelaysylvie@outlook.com',`att14`='45 rue du moulin',`att7`='88470',`att17`='Saint Michel sur Meurthe',`att18`='France',`att5`='0609057643',`attf102`='20250515',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250515',`att19`='48.317195',`att20`='6.884596',`attf100`='1',`att6`='0609057643',`attdatmod`='202505151150',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3150') AND (id_type = '80') LIMIT 1 UID:--115049-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Mervelay',`att2`='3150',`att90`='Bonjour \r\nJe voudrais un devis pour le démoussage de ma toiture.',`attf100`='20250515',`att8`='1586',`att6`='0',`att9`='3151',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505151150',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '429') AND (id_type = '148') LIMIT 1 UID:--120921--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:--120921--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--123237-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505151232' ) UID:--123237-- UPDATE `tier_att` SET `id_work`='259',`att3`='Cassandra',`att1`='DOS SANTOS',`att8`='non_défini',`att12`='cassandra@everfruitdigital.com',`att14`='48 Avenue Barthélémy Buyer, Lyon, France',`att7`='69009',`att17`='Lyon',`att18`='France',`att5`='0606060606',`attf102`='20250515',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250515',`attdatmod`='202505151232',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3152') AND (id_type = '80') LIMIT 1 UID:--123237-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3152','202505151232','202505151232' ) UID:--123237-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='48 Avenue Barthélémy Buyer, Lyon, France',`lig4`='69009',`lig5`='Lyon',`lig6`='France',`ligdatmod`='202505151232',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3152') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1587') LIMIT 1 UID:--123237-- UPDATE `tier_att` SET `id_work`='259',`att3`='Cassandra',`att1`='DOS SANTOS',`att8`='non_défini',`att12`='cassandra@everfruitdigital.com',`att14`='48 Avenue Barthélémy Buyer, Lyon, France',`att7`='69009',`att17`='Lyon',`att18`='France',`att5`='0606060606',`attf102`='20250515',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250515',`att19`='45.759537',`att20`='4.808006',`attf100`='1',`attdatmod`='202505151232',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3152') AND (id_type = '80') LIMIT 1 UID:--123237-- UPDATE `tier_att` SET `id_work`='259',`att3`='Cassandra',`att1`='DOS SANTOS',`att8`='non_défini',`att12`='cassandra@everfruitdigital.com',`att14`='48 Avenue Barthélémy Buyer, Lyon, France',`att7`='69009',`att17`='Lyon',`att18`='France',`att5`='0606060606',`attf102`='20250515',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250515',`att19`='45.759537',`att20`='4.808006',`attf100`='1',`attdatmod`='202505151232',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3152') AND (id_type = '80') LIMIT 1 UID:--123237-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505151232' ) UID:--123237-- UPDATE `tier_att` SET `id_work`='367',`att2`='DOS SANTOS',`att3`='Cassandra',`att5`='0606060606',`att6`='cassandra@everfruitdigital.com',`att8`='3152',`att10`='[IDMYUSER]',`attdatmod`='202505151232',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3153') AND (id_type = '149') LIMIT 1 UID:--123237-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505151232' ) UID:--123237-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-',`att2`='3152',`att90`='Test everfruit',`attf100`='20250515',`att8`='1587',`att6`='[IDMYUSER]',`att9`='3153',`att3`='§terrasse§',`attdatmod`='202505151232',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '432') AND (id_type = '148') LIMIT 1 UID:--123237-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-DOS SANTOS',`att2`='3152',`att90`='Test everfruit',`attf100`='20250515',`att8`='1587',`att6`='[IDMYUSER]',`att9`='3153',`att3`='§terrasse§',`attdatmod`='202505151232',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '432') AND (id_type = '148') LIMIT 1 UID:--123237-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-DOS SANTOS',`att2`='3152',`att90`='Test everfruit',`attf100`='20250515',`att8`='1587',`att6`='[IDMYUSER]',`att9`='3153',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505151232',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '432') AND (id_type = '148') LIMIT 1 UID:--123237-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-DOS SANTOS',`att2`='3152',`att90`='Test everfruit',`attf100`='20250515',`att8`='1587',`att6`='0',`att9`='3153',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505151232',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '432') AND (id_type = '148') LIMIT 1 UID:--123237-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250515','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-DOS SANTOS','\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-DOS SANTOS

\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:--123237-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '304') LIMIT 1 UID:--123237--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:--123237-- UPDATE `tier_att` SET `id_work`='367',`att2`='DOS SANTOS',`att3`='Cassandra',`att5`='0606060606',`att6`='cassandra@everfruitdigital.com',`att8`='3152',`att10`='[IDMYUSER]',`att4`='0606060606',`attdatmod`='202505151232',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3153') AND (id_type = '149') LIMIT 1 UID:--123237-- UPDATE `tier_att` SET `id_work`='259',`att3`='Cassandra',`att1`='DOS SANTOS',`att8`='non_défini',`att12`='cassandra@everfruitdigital.com',`att14`='48 Avenue Barthélémy Buyer, Lyon, France',`att7`='69009',`att17`='Lyon',`att18`='France',`att5`='0606060606',`attf102`='20250515',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250515',`att19`='45.759537',`att20`='4.808006',`attf100`='1',`attdatmod`='202505151232',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3152') AND (id_type = '80') LIMIT 1 UID:--123237-- UPDATE `tier_att` SET `id_work`='259',`att3`='Cassandra',`att1`='DOS SANTOS',`att8`='non_défini',`att12`='cassandra@everfruitdigital.com',`att14`='48 Avenue Barthélémy Buyer, Lyon, France',`att7`='69009',`att17`='Lyon',`att18`='France',`att5`='0606060606',`attf102`='20250515',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250515',`att19`='45.759537',`att20`='4.808006',`attf100`='1',`attdatmod`='202505151232',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3152') AND (id_type = '80') LIMIT 1 UID:--123237-- UPDATE `tier_att` SET `id_work`='259',`att3`='Cassandra',`att1`='DOS SANTOS',`att8`='non_défini',`att12`='cassandra@everfruitdigital.com',`att14`='48 Avenue Barthélémy Buyer, Lyon, France',`att7`='69009',`att17`='Lyon',`att18`='France',`att5`='0606060606',`attf102`='20250515',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250515',`att19`='45.759537',`att20`='4.808006',`attf100`='1',`att6`='0606060606',`attdatmod`='202505151232',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3152') AND (id_type = '80') LIMIT 1 UID:--123237-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-DOS SANTOS',`att2`='3152',`att90`='Test everfruit',`attf100`='20250515',`att8`='1587',`att6`='0',`att9`='3153',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505151232',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '432') AND (id_type = '148') LIMIT 1 UID:--123301-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505151233' ) UID:--123301-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-',`att2`='3152',`att90`='test Everfruit',`attf100`='20250515',`att8`='1587',`att6`='[IDMYUSER]',`att9`='3153',`att3`='§terrasse§',`attdatmod`='202505151233',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '433') AND (id_type = '148') LIMIT 1 UID:--123301-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-DOS SANTOS',`att2`='3152',`att90`='test Everfruit',`attf100`='20250515',`att8`='1587',`att6`='[IDMYUSER]',`att9`='3153',`att3`='§terrasse§',`attdatmod`='202505151233',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '433') AND (id_type = '148') LIMIT 1 UID:--123301-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-DOS SANTOS',`att2`='3152',`att90`='test Everfruit',`attf100`='20250515',`att8`='1587',`att6`='[IDMYUSER]',`att9`='3153',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505151233',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '433') AND (id_type = '148') LIMIT 1 UID:--123301-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-DOS SANTOS',`att2`='3152',`att90`='test Everfruit',`attf100`='20250515',`att8`='1587',`att6`='0',`att9`='3153',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505151233',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '433') AND (id_type = '148') LIMIT 1 UID:--123301-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250515','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-DOS SANTOS','\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-DOS SANTOS

\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:--123301-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '305') LIMIT 1 UID:--123301--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:--123301-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-DOS SANTOS',`att2`='3152',`att90`='test Everfruit',`attf100`='20250515',`att8`='1587',`att6`='0',`att9`='3153',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505151233',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '433') AND (id_type = '148') LIMIT 1 UID:--123410-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505151234' ) UID:--123410-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-',`att2`='3152',`att90`='Test Everfruit',`attf100`='20250515',`att8`='1587',`att6`='[IDMYUSER]',`att9`='3153',`att3`='§terrasse§',`attdatmod`='202505151234',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '434') AND (id_type = '148') LIMIT 1 UID:--123410-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-DOS SANTOS',`att2`='3152',`att90`='Test Everfruit',`attf100`='20250515',`att8`='1587',`att6`='[IDMYUSER]',`att9`='3153',`att3`='§terrasse§',`attdatmod`='202505151234',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '434') AND (id_type = '148') LIMIT 1 UID:--123410-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-DOS SANTOS',`att2`='3152',`att90`='Test Everfruit',`attf100`='20250515',`att8`='1587',`att6`='[IDMYUSER]',`att9`='3153',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505151234',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '434') AND (id_type = '148') LIMIT 1 UID:--123410-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-DOS SANTOS',`att2`='3152',`att90`='Test Everfruit',`attf100`='20250515',`att8`='1587',`att6`='0',`att9`='3153',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505151234',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '434') AND (id_type = '148') LIMIT 1 UID:--123410-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250515','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-DOS SANTOS','\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-DOS SANTOS

\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:--123410-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '306') LIMIT 1 UID:--123410--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:--123410-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-DOS SANTOS',`att2`='3152',`att90`='Test Everfruit',`attf100`='20250515',`att8`='1587',`att6`='0',`att9`='3153',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505151234',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '434') AND (id_type = '148') LIMIT 1 UID:--123526-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505151235' ) UID:--123526-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-',`att2`='3152',`att90`='Test everfruit',`attf100`='20250515',`att8`='1587',`att6`='[IDMYUSER]',`att9`='3153',`att3`='§terrasse§',`attdatmod`='202505151235',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '435') AND (id_type = '148') LIMIT 1 UID:--123526-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-DOS SANTOS',`att2`='3152',`att90`='Test everfruit',`attf100`='20250515',`att8`='1587',`att6`='[IDMYUSER]',`att9`='3153',`att3`='§terrasse§',`attdatmod`='202505151235',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '435') AND (id_type = '148') LIMIT 1 UID:--123526-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-DOS SANTOS',`att2`='3152',`att90`='Test everfruit',`attf100`='20250515',`att8`='1587',`att6`='[IDMYUSER]',`att9`='3153',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505151235',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '435') AND (id_type = '148') LIMIT 1 UID:--123526-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-DOS SANTOS',`att2`='3152',`att90`='Test everfruit',`attf100`='20250515',`att8`='1587',`att6`='0',`att9`='3153',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505151235',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '435') AND (id_type = '148') LIMIT 1 UID:--123526-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250515','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-DOS SANTOS','\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-DOS SANTOS

\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:--123526-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '307') LIMIT 1 UID:--123526--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:--123526-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-DOS SANTOS',`att2`='3152',`att90`='Test everfruit',`attf100`='20250515',`att8`='1587',`att6`='0',`att9`='3153',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505151235',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '435') AND (id_type = '148') LIMIT 1 UID:--132841--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:--132841--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--134050--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:--134050-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202505151340' ) UID:--134050-- UPDATE `vent_att` SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='Maison individuelle',`att90`='5n0kwneaulv34u38',`attf100`='20250430',`att5`='2985',`att8`='7',`att9`='945',`att10`='94.5',`att11`='1039.5',`att13`='',`att14`='224',`att15`='\n

Rainea Exteco Metz

\n
\n

10 Rue Rochambeau
\n 57000 Metz

\n

<',`att16`=' 5 impasse des Fougères 57100 Thionville',`att18`='0',`att24`='1039.5',`att25`='5 impasse des Fougères',`att26`='',`att27`='57100',`att28`='Thionville',`attdatmod`='202505151340',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '436') AND (id_type = '168') LIMIT 1 UID:--134050-- UPDATE `vent_att` SET `newobj`='new' WHERE 1=1 AND (id_type = '168') AND (id_vent = '436') LIMIT 1 UID:--134050-- UPDATE `tier_lig` SET `lig2`='10',`ligdatmod`='202505151340',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '8') LIMIT 1 UID:--134050-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-METZ-10',`att3`='',`att2`='Maison individuelle',`att90`='5n0kwneaulv34u38',`attf100`='20250430',`att5`='2985',`att8`='7',`att9`='945',`att10`='94.5',`att11`='1039.5',`att13`='',`att14`='224',`att15`='\n

Rainea Exteco Metz

\n
\n

10 Rue Rochambeau
\n 57000 Metz

\n

<',`att16`=' 5 impasse des Fougères 57100 Thionville',`att18`='0',`att24`='1039.5',`att25`='5 impasse des Fougères',`att26`='',`att27`='57100',`att28`='Thionville',`attdatmod`='202505151340',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '436') AND (id_type = '168') LIMIT 1 UID:--134050-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','436','202505151340','202505151340' ) UID:--134050-- UPDATE `vent_lig` SET `actif`='1',`lig16`='Unité',`lig23`='1',`lig5`='10',`lig10`='euro',`lig90`='

Nettoyage de la terrasse bois

',`ligdatmod`='202505151340',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '436') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '727') LIMIT 1 UID:--134050-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','436','202505151340','202505151340' ) UID:--134050-- UPDATE `vent_lig` SET `actif`='1',`lig1`='122',`lig7`='94.50',`lig9`='122',`lig16`='M2',`lig23`='1',`lig3`='63,9',`lig2`='15.00',`lig5`='10',`lig4`='945.00',`lig8`='1039.50',`lig10`='euro',`lig6`='1039.50',`lig90`='

Nettoyage de la terrasse bois


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

',`ligdatmod`='202505151340',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '436') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '728') LIMIT 1 UID:--134050-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('141','1','2','Devis_DV-METZ-13_15_05_2025_11h_24m_signe.pdf','20250515','451','devis_signe','168','436','-2','-1','' ) UID:--134050-- UPDATE `file` SET `size`='358812' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '403') LIMIT 1 UID:--134050-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('142','1','2','Attestation_fiscale_DV_METZ_13_30_04_2025_18h_01m_signe.pdf','20250515','153','attestation_signe','168','436','-2','-1','' ) UID:--134050-- UPDATE `file` SET `size`='473054' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '404') LIMIT 1 UID:--134050-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250515','','1','tete_de_reseau@toosmart.fr','Exteco','caroline.stemmler.agt@axa.fr','','','Merci pour votre commande : Devis N°DV-METZ-13','\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-13)\r\n

\r\n\r\n

\r\n Bonjour madame STEMMLER,

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/403-141-451-1§Devis_DV-METZ-13_15_05_2025_11h_24m_signe.pdf;/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/404-142-153-1§Attestation_fiscale_DV_METZ_13_30_04_2025_18h_01m_signe.pdf','0','v2017b' ) UID:--134050-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '308') LIMIT 1 UID:--134050-- UPDATE `vent_lig` SET `lig16`='Unité',`lig23`='1',`lig5`='10',`lig10`='euro',`lig90`='

Nettoyage de la terrasse bois

',`lig3`='1',`lig4`='0.00',`lig8`='0.00',`lig6`='0.00',`ligdatmod`='202505151340',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '436') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '727') LIMIT 1 UID:--134050-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-METZ-10',`att3`='',`att2`='Maison individuelle',`att90`='5n0kwneaulv34u38',`attf100`='20250430',`att5`='2985',`att8`='7',`att9`='945',`att10`='94.5',`att11`='1039.5',`att13`='',`att14`='224',`att15`='\n

Rainea Exteco Metz

\n
\n

10 Rue Rochambeau
\n 57000 Metz

\n

<',`att16`=' 5 impasse des Fougères 57100 Thionville',`att18`='0',`att24`='1039.5',`att25`='5 impasse des Fougères',`att26`='',`att27`='57100',`att28`='Thionville',`att31`='94.5',`att29`='945',`attdatmod`='202505151340',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '436') AND (id_type = '168') LIMIT 1 UID:--134051-- UPDATE `vent_att` SET `id_work`='417',`att4`='15',`attdatmod`='202505151340',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '223') AND (id_type = '148') LIMIT 1 UID:--134051-- UPDATE `vent_att` SET `id_work`='412',`attf107`='202505151340',`attdatmod`='202505151340',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '224') AND (id_type = '165') LIMIT 1 UID:--134051-- UPDATE `tier_att` SET `id_work`='205',`attdatmod`='202505151340',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '2985') AND (id_type = '80') LIMIT 1 UID:--135935-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505151359' ) UID:--135935-- UPDATE `tier_att` SET `id_work`='259',`att3`='Franz',`att1`='Hoeusler',`att8`='non_défini',`att12`='franz.hoeusler@wanadoo.fr',`att14`='8 Rue du Fort-Louis, Strasbourg, France',`att7`='67000',`att17`='Strasbourg',`att18`='France',`att5`='0611036967',`attf102`='20250515',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250515',`attdatmod`='202505151359',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3154') AND (id_type = '80') LIMIT 1 UID:--135936-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3154','202505151359','202505151359' ) UID:--135936-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='8 Rue du Fort-Louis, Strasbourg, France',`lig4`='67000',`lig5`='Strasbourg',`lig6`='France',`ligdatmod`='202505151359',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3154') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1588') LIMIT 1 UID:--135936-- UPDATE `tier_att` SET `id_work`='259',`att3`='Franz',`att1`='Hoeusler',`att8`='non_défini',`att12`='franz.hoeusler@wanadoo.fr',`att14`='8 Rue du Fort-Louis, Strasbourg, France',`att7`='67000',`att17`='Strasbourg',`att18`='France',`att5`='0611036967',`attf102`='20250515',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250515',`att19`='48.605873',`att20`='7.777283',`attf100`='1',`attdatmod`='202505151359',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3154') AND (id_type = '80') LIMIT 1 UID:--135936-- UPDATE `tier_att` SET `id_work`='259',`att3`='Franz',`att1`='Hoeusler',`att8`='non_défini',`att12`='franz.hoeusler@wanadoo.fr',`att14`='8 Rue du Fort-Louis, Strasbourg, France',`att7`='67000',`att17`='Strasbourg',`att18`='France',`att5`='0611036967',`attf102`='20250515',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250515',`att19`='48.605873',`att20`='7.777283',`attf100`='1',`attdatmod`='202505151359',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3154') AND (id_type = '80') LIMIT 1 UID:--135936-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505151359' ) UID:--135936-- UPDATE `tier_att` SET `id_work`='367',`att2`='Hoeusler',`att3`='Franz',`att5`='0611036967',`att6`='franz.hoeusler@wanadoo.fr',`att8`='3154',`att10`='[IDMYUSER]',`attdatmod`='202505151359',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3155') AND (id_type = '149') LIMIT 1 UID:--135936-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505151359' ) UID:--135936-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-',`att2`='3154',`att90`='Nettoyer plancher bois piscine surface 80 m2 et pavage cour 160 m2 . \r\nMerci \r\nFH',`attf100`='20250515',`att8`='1588',`att6`='[IDMYUSER]',`att9`='3155',`att3`='§autres§',`attdatmod`='202505151359',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '437') AND (id_type = '148') LIMIT 1 UID:--135936-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Hoeusler',`att2`='3154',`att90`='Nettoyer plancher bois piscine surface 80 m2 et pavage cour 160 m2 . \r\nMerci \r\nFH',`attf100`='20250515',`att8`='1588',`att6`='[IDMYUSER]',`att9`='3155',`att3`='§autres§',`attdatmod`='202505151359',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '437') AND (id_type = '148') LIMIT 1 UID:--135936-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Hoeusler',`att2`='3154',`att90`='Nettoyer plancher bois piscine surface 80 m2 et pavage cour 160 m2 . \r\nMerci \r\nFH',`attf100`='20250515',`att8`='1588',`att6`='[IDMYUSER]',`att9`='3155',`att3`='§autres§',`att5`='',`att10`='non_défini',`attdatmod`='202505151359',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '437') AND (id_type = '148') LIMIT 1 UID:--135936-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Hoeusler',`att2`='3154',`att90`='Nettoyer plancher bois piscine surface 80 m2 et pavage cour 160 m2 . \r\nMerci \r\nFH',`attf100`='20250515',`att8`='1588',`att6`='0',`att9`='3155',`att3`='§autres§',`att5`='',`att10`='non_défini',`attdatmod`='202505151359',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '437') AND (id_type = '148') LIMIT 1 UID:--135936-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250515','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Hoeusler','\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-Hoeusler

\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:--135936-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '309') LIMIT 1 UID:--135936--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:--135936-- UPDATE `tier_att` SET `id_work`='367',`att2`='Hoeusler',`att3`='Franz',`att5`='0611036967',`att6`='franz.hoeusler@wanadoo.fr',`att8`='3154',`att10`='[IDMYUSER]',`att4`='0611036967',`attdatmod`='202505151359',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3155') AND (id_type = '149') LIMIT 1 UID:--135936-- UPDATE `tier_att` SET `id_work`='259',`att3`='Franz',`att1`='Hoeusler',`att8`='non_défini',`att12`='franz.hoeusler@wanadoo.fr',`att14`='8 Rue du Fort-Louis, Strasbourg, France',`att7`='67000',`att17`='Strasbourg',`att18`='France',`att5`='0611036967',`attf102`='20250515',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250515',`att19`='48.605873',`att20`='7.777283',`attf100`='1',`attdatmod`='202505151359',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3154') AND (id_type = '80') LIMIT 1 UID:--135936-- UPDATE `tier_att` SET `id_work`='259',`att3`='Franz',`att1`='Hoeusler',`att8`='non_défini',`att12`='franz.hoeusler@wanadoo.fr',`att14`='8 Rue du Fort-Louis, Strasbourg, France',`att7`='67000',`att17`='Strasbourg',`att18`='France',`att5`='0611036967',`attf102`='20250515',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250515',`att19`='48.605873',`att20`='7.777283',`attf100`='1',`attdatmod`='202505151359',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3154') AND (id_type = '80') LIMIT 1 UID:--135936-- UPDATE `tier_att` SET `id_work`='259',`att3`='Franz',`att1`='Hoeusler',`att8`='non_défini',`att12`='franz.hoeusler@wanadoo.fr',`att14`='8 Rue du Fort-Louis, Strasbourg, France',`att7`='67000',`att17`='Strasbourg',`att18`='France',`att5`='0611036967',`attf102`='20250515',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250515',`att19`='48.605873',`att20`='7.777283',`attf100`='1',`att6`='0611036967',`attdatmod`='202505151359',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3154') AND (id_type = '80') LIMIT 1 UID:--135936-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Hoeusler',`att2`='3154',`att90`='Nettoyer plancher bois piscine surface 80 m2 et pavage cour 160 m2 . \r\nMerci \r\nFH',`attf100`='20250515',`att8`='1588',`att6`='0',`att9`='3155',`att3`='§autres§',`att5`='',`att10`='non_défini',`attdatmod`='202505151359',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '437') AND (id_type = '148') LIMIT 1 UID:--140457--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:--140457--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--141240--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:--141240--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--141455--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--141455--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--141929--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:--141929--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--152950--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:--152950--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--155049--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:--155049--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--155053--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:--155053--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--160108--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:--160108-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202505151601' ) UID:--160108-- UPDATE `vent_att` SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='maison individuelle - terrasse - Custines',`att90`='0wpxl7lxw4n4tzpd',`attf100`='20250513',`att5`='3127',`att8`='6',`att9`='1333.3',`att10`='133.33',`att11`='1466.63',`att13`='chèque ou virement',`att14`='382',`att15`='\n

Rainea Exteco Epinal

\n
\n

2 rue de la Ballastière
\n 88190 GOLBEY

\n ',`att16`=' 7 rue de la garenne 54670 Custines',`att18`='0',`att24`='1466.63',`att25`='7 rue de la garenne',`att26`='',`att27`='54670',`att28`='Custines',`attdatmod`='202505151601',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '438') AND (id_type = '168') LIMIT 1 UID:--160108-- UPDATE `vent_att` SET `newobj`='new' WHERE 1=1 AND (id_type = '168') AND (id_vent = '438') LIMIT 1 UID:--160108-- UPDATE `tier_lig` SET `lig2`='16',`ligdatmod`='202505151601',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '2') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '3') LIMIT 1 UID:--160108-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-EPI-16',`att3`='',`att2`='maison individuelle - terrasse - Custines',`att90`='0wpxl7lxw4n4tzpd',`attf100`='20250513',`att5`='3127',`att8`='6',`att9`='1333.3',`att10`='133.33',`att11`='1466.63',`att13`='chèque ou virement',`att14`='382',`att15`='\n

Rainea Exteco Epinal

\n
\n

2 rue de la Ballastière
\n 88190 GOLBEY

\n ',`att16`=' 7 rue de la garenne 54670 Custines',`att18`='0',`att24`='1466.63',`att25`='7 rue de la garenne',`att26`='',`att27`='54670',`att28`='Custines',`attdatmod`='202505151601',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '438') AND (id_type = '168') LIMIT 1 UID:--160108-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','438','202505151601','202505151601' ) UID:--160108-- UPDATE `vent_lig` SET `actif`='1',`lig1`='113',`lig7`='133.33',`lig9`='113',`lig16`='M2',`lig3`='67,8',`lig2`='19.90',`lig5`='10',`lig4`='1333.30',`lig8`='1466.63',`lig10`='euro',`lig6`='1466.63',`lig90`='<p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`ligdatmod`='202505151601',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '438') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '729') LIMIT 1 UID:--160109-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('143','1','2','Devis_DV-EPI-44_15_05_2025_15h_51m_signe.pdf','20250515','412','devis_signe','168','438','-2','-1','' ) UID:--160109-- UPDATE `file` SET `size`='500726' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '407') LIMIT 1 UID:--160109-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('144','1','2','Attestation_fiscale_DV_EPI_44_13_05_2025_16h_20m_signe.pdf','20250515','139','attestation_signe','168','438','-2','-1','' ) UID:--160109-- UPDATE `file` SET `size`='732066' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '408') LIMIT 1 UID:--160109-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250515','','1','tete_de_reseau@toosmart.fr','Exteco','helene.petitcolas@sfr.fr','','','Merci pour votre commande : Devis N°DV-EPI-44','\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-EPI-44)\r\n

\r\n\r\n

\r\n Bonjour madame PETITCOLAS,

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/407-143-412-1§Devis_DV-EPI-44_15_05_2025_15h_51m_signe.pdf;/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/408-144-139-1§Attestation_fiscale_DV_EPI_44_13_05_2025_16h_20m_signe.pdf','0','v2017b' ) UID:--160109-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '312') LIMIT 1 UID:--160109-- UPDATE `vent_lig` SET `lig1`='113',`lig7`='133.33',`lig9`='113',`lig16`='M2',`lig3`='67,8',`lig2`='19.90',`lig5`='10',`lig4`='1333.30',`lig8`='1466.63',`lig10`='euro',`lig6`='1466.63',`lig90`='<p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`ligdatmod`='202505151601',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '438') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '729') LIMIT 1 UID:--160109-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-EPI-16',`att3`='',`att2`='maison individuelle - terrasse - Custines',`att90`='0wpxl7lxw4n4tzpd',`attf100`='20250513',`att5`='3127',`att8`='6',`att9`='1333.3',`att10`='133.33',`att11`='1466.63',`att13`='chèque ou virement',`att14`='382',`att15`='\n

Rainea Exteco Epinal

\n
\n

2 rue de la Ballastière
\n 88190 GOLBEY

\n ',`att16`=' 7 rue de la garenne 54670 Custines',`att18`='-2.2737367544323E-13',`att24`='1466.63',`att25`='7 rue de la garenne',`att26`='',`att27`='54670',`att28`='Custines',`att31`='133.33',`att29`='1333.3',`attdatmod`='202505151601',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '438') AND (id_type = '168') LIMIT 1 UID:--160112-- UPDATE `vent_att` SET `id_work`='417',`att4`='2',`attdatmod`='202505151601',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '381') AND (id_type = '148') LIMIT 1 UID:--160112-- UPDATE `vent_att` SET `id_work`='412',`attf107`='202505151601',`attdatmod`='202505151601',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '382') AND (id_type = '165') LIMIT 1 UID:--160112-- UPDATE `tier_att` SET `id_work`='205',`attdatmod`='202505151601',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3127') AND (id_type = '80') LIMIT 1 UID:--160203--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:--160203-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202505151602' ) UID:--160203-- UPDATE `vent_att` SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='maison individuelle - toiture - Custines',`att90`='dh6c3nxfenw3qycp',`attf100`='20250513',`att5`='3127',`att8`='6',`att9`='2758.5',`att10`='275.85',`att11`='3034.35',`att13`='chèque ou virement',`att14`='379',`att15`='\n

Rainea Exteco Epinal

\n
\n

2 rue de la Ballastière
\n 88190 GOLBEY

\n ',`att16`=' 7 rue de la garenne 54670 Custines',`att18`='0',`att24`='3034.35',`att25`='7 rue de la garenne',`att26`='',`att27`='54670',`att28`='Custines',`attdatmod`='202505151602',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '439') AND (id_type = '168') LIMIT 1 UID:--160203-- UPDATE `vent_att` SET `newobj`='new' WHERE 1=1 AND (id_type = '168') AND (id_vent = '439') LIMIT 1 UID:--160203-- UPDATE `tier_lig` SET `lig2`='17',`ligdatmod`='202505151602',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '2') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '3') LIMIT 1 UID:--160203-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-EPI-17',`att3`='',`att2`='maison individuelle - toiture - Custines',`att90`='dh6c3nxfenw3qycp',`attf100`='20250513',`att5`='3127',`att8`='6',`att9`='2758.5',`att10`='275.85',`att11`='3034.35',`att13`='chèque ou virement',`att14`='379',`att15`='\n

Rainea Exteco Epinal

\n
\n

2 rue de la Ballastière
\n 88190 GOLBEY

\n ',`att16`=' 7 rue de la garenne 54670 Custines',`att18`='0',`att24`='3034.35',`att25`='7 rue de la garenne',`att26`='',`att27`='54670',`att28`='Custines',`attdatmod`='202505151602',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '439') AND (id_type = '168') LIMIT 1 UID:--160203-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','439','202505151602','202505151602' ) UID:--160203-- UPDATE `vent_lig` SET `actif`='1',`lig1`='65',`lig7`='28.00',`lig9`='65',`lig16`='Unite',`lig3`='1',`lig2`='280.00',`lig5`='10',`lig4`='280.00',`lig8`='308.00',`lig10`='euro',`lig6`='308.00',`lig90`='<p><br></p>',`ligdatmod`='202505151602',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '439') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '730') LIMIT 1 UID:--160203-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','439','202505151602','202505151602' ) UID:--160203-- UPDATE `vent_lig` SET `actif`='1',`lig1`='17',`lig7`='149.50',`lig9`='17',`lig16`='M2',`lig3`='115',`lig2`='13.00',`lig5`='10',`lig4`='1495.00',`lig8`='1644.50',`lig10`='euro',`lig6`='1644.50',`lig90`='<p>Nettoyage et désinfection du support via un procédé vapeur basse pression (de 30 à 60 bars maximum)</p>',`ligdatmod`='202505151602',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '439') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '731') LIMIT 1 UID:--160203-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','439','202505151602','202505151602' ) UID:--160203-- UPDATE `vent_lig` SET `actif`='1',`lig1`='49',`lig7`='19.00',`lig9`='49',`lig16`='Unite',`lig3`='1',`lig2`='190.00',`lig5`='10',`lig4`='190.00',`lig8`='209.00',`lig10`='euro',`lig6`='209.00',`lig90`='<p>Nettoyage des tuiles de rive via un procédé vapeur basse pression (de 30 à 60 bars maximum)</p>',`ligdatmod`='202505151602',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '439') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '732') LIMIT 1 UID:--160203-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','439','202505151602','202505151602' ) UID:--160203-- UPDATE `vent_lig` SET `actif`='1',`lig1`='25',`lig7`='79.35',`lig9`='25',`lig16`='M2',`lig3`='115',`lig2`='6.90',`lig5`='10',`lig4`='793.50',`lig8`='872.85',`lig10`='euro',`lig6`='872.85',`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`='202505151602',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '439') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '733') LIMIT 1 UID:--160203-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','439','202505151602','202505151602' ) UID:--160203-- UPDATE `vent_lig` SET `actif`='1',`lig1`='41',`lig7`='0.00',`lig9`='41',`lig16`='Unite',`lig3`='1',`lig5`='10',`lig4`='0.00',`lig8`='0.00',`lig10`='euro',`lig6`='0.00',`lig90`='

OFFERT : Nettoyage intérieur et extérieur des gouttières 

',`ligdatmod`='202505151602',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '439') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '734') LIMIT 1 UID:--160203-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('145','1','2','Devis_DV-EPI-43_15_05_2025_15h_51m_signe.pdf','20250515','571','devis_signe','168','439','-2','-1','' ) UID:--160203-- UPDATE `file` SET `size`='587028' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '409') LIMIT 1 UID:--160203-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('146','1','2','Attestation_fiscale_DV_EPI_43_13_05_2025_16h_16m_signe.pdf','20250515','498','attestation_signe','168','439','-2','-1','' ) UID:--160203-- UPDATE `file` SET `size`='732014' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '410') LIMIT 1 UID:--160203-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250515','','1','tete_de_reseau@toosmart.fr','Exteco','helene.petitcolas@sfr.fr','','','Merci pour votre commande : Devis N°DV-EPI-43','\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-EPI-43)\r\n

\r\n\r\n

\r\n Bonjour madame PETITCOLAS,

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/409-145-571-1§Devis_DV-EPI-43_15_05_2025_15h_51m_signe.pdf;/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/410-146-498-1§Attestation_fiscale_DV_EPI_43_13_05_2025_16h_16m_signe.pdf','0','v2017b' ) UID:--160203-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '313') LIMIT 1 UID:--160204-- UPDATE `vent_lig` SET `lig1`='65',`lig7`='28.00',`lig9`='65',`lig16`='Unite',`lig3`='1',`lig2`='280.00',`lig5`='10',`lig4`='280.00',`lig8`='308.00',`lig10`='euro',`lig6`='308.00',`lig90`='<p><br></p>',`ligdatmod`='202505151602',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '439') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '730') LIMIT 1 UID:--160204-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-EPI-17',`att3`='',`att2`='maison individuelle - toiture - Custines',`att90`='dh6c3nxfenw3qycp',`attf100`='20250513',`att5`='3127',`att8`='6',`att9`='2758.5',`att10`='275.85',`att11`='3034.35',`att13`='chèque ou virement',`att14`='379',`att15`='\n

Rainea Exteco Epinal

\n
\n

2 rue de la Ballastière
\n 88190 GOLBEY

\n ',`att16`=' 7 rue de la garenne 54670 Custines',`att18`='0',`att24`='3034.35',`att25`='7 rue de la garenne',`att26`='',`att27`='54670',`att28`='Custines',`att31`='275.85',`att29`='2758.5',`attdatmod`='202505151602',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '439') AND (id_type = '168') LIMIT 1 UID:--160210-- UPDATE `vent_att` SET `id_work`='417',`att4`='2',`attdatmod`='202505151602',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '378') AND (id_type = '148') LIMIT 1 UID:--160210-- UPDATE `vent_att` SET `id_work`='412',`attf107`='202505151602',`attdatmod`='202505151602',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '379') AND (id_type = '165') LIMIT 1 UID:--162636--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:--162636--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--163835--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:--163835--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--164558--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:--164558--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--173046--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:--173046--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--173325--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:--173325--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--173435--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:--173435--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--181112--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:--181112-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202505151811' ) UID:--181112-- UPDATE `vent_att` SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='appartement - terrasse - Villers lès Nancy',`att90`='cmnpg0ofuj29es4o',`attf100`='20250514',`att5`='3085',`att8`='6',`att9`='616.9',`att10`='61.69',`att11`='678.59',`att13`='',`att14`='393',`att15`='\n

Rainea Exteco Epinal

\n
\n

2 rue de la Ballastière
\n 88190 GOLBEY

\n ',`att16`=' 3 rue Lucie Aubrac 54600 VILLERS-LES-NANCY',`att18`='0',`att24`='678.59',`att25`='3 rue Lucie Aubrac',`att26`='',`att27`='54600',`att28`='VILLERS-LES-NANCY',`attdatmod`='202505151811',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '441') AND (id_type = '168') LIMIT 1 UID:--181112-- UPDATE `vent_att` SET `newobj`='new' WHERE 1=1 AND (id_type = '168') AND (id_vent = '441') LIMIT 1 UID:--181112-- UPDATE `tier_lig` SET `lig2`='18',`ligdatmod`='202505151811',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '2') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '3') LIMIT 1 UID:--181112-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-EPI-18',`att3`='',`att2`='appartement - terrasse - Villers lès Nancy',`att90`='cmnpg0ofuj29es4o',`attf100`='20250514',`att5`='3085',`att8`='6',`att9`='616.9',`att10`='61.69',`att11`='678.59',`att13`='',`att14`='393',`att15`='\n

Rainea Exteco Epinal

\n
\n

2 rue de la Ballastière
\n 88190 GOLBEY

\n ',`att16`=' 3 rue Lucie Aubrac 54600 VILLERS-LES-NANCY',`att18`='0',`att24`='678.59',`att25`='3 rue Lucie Aubrac',`att26`='',`att27`='54600',`att28`='VILLERS-LES-NANCY',`attdatmod`='202505151811',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '441') AND (id_type = '168') LIMIT 1 UID:--181112-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','441','202505151811','202505151811' ) UID:--181112-- UPDATE `vent_lig` SET `actif`='1',`lig1`='121',`lig7`='61.69',`lig9`='121',`lig16`='M2',`lig3`='31,95',`lig2`='19.90',`lig5`='10',`lig4`='616.90',`lig8`='678.59',`lig10`='euro',`lig6`='678.59',`lig90`='<p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`ligdatmod`='202505151811',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '441') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '753') LIMIT 1 UID:--181113-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('148','1','2','Devis_DV-EPI-45_15_05_2025_16h_43m_signe.pdf','20250515','881','devis_signe','168','441','-2','-1','' ) UID:--181113-- UPDATE `file` SET `size`='353898' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '413') LIMIT 1 UID:--181113-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('149','1','2','Attestation_fiscale_DV_EPI_45_14_05_2025_08h_11m_signe.pdf','20250515','686','attestation_signe','168','441','-2','-1','' ) UID:--181113-- UPDATE `file` SET `size`='470606' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '414') LIMIT 1 UID:--181113-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250515','','1','tete_de_reseau@toosmart.fr','Exteco','christelle.petit17@gmail.com','','','Merci pour votre commande : Devis N°DV-EPI-45','\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-EPI-45)\r\n

\r\n\r\n

\r\n Bonjour madame PETIT-BERRUET,

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/413-148-881-1§Devis_DV-EPI-45_15_05_2025_16h_43m_signe.pdf;/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/414-149-686-1§Attestation_fiscale_DV_EPI_45_14_05_2025_08h_11m_signe.pdf','0','v2017b' ) UID:--181113-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '315') LIMIT 1 UID:--181113-- UPDATE `vent_lig` SET `lig1`='121',`lig7`='61.69',`lig9`='121',`lig16`='M2',`lig3`='31,95',`lig2`='19.90',`lig5`='10',`lig4`='616.90',`lig8`='678.59',`lig10`='euro',`lig6`='678.59',`lig90`='<p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`ligdatmod`='202505151811',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '441') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '753') LIMIT 1 UID:--181113-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-EPI-18',`att3`='',`att2`='appartement - terrasse - Villers lès Nancy',`att90`='cmnpg0ofuj29es4o',`attf100`='20250514',`att5`='3085',`att8`='6',`att9`='616.9',`att10`='61.69',`att11`='678.59',`att13`='',`att14`='393',`att15`='\n

Rainea Exteco Epinal

\n
\n

2 rue de la Ballastière
\n 88190 GOLBEY

\n ',`att16`=' 3 rue Lucie Aubrac 54600 VILLERS-LES-NANCY',`att18`='-1.1368683772162E-13',`att24`='678.59',`att25`='3 rue Lucie Aubrac',`att26`='',`att27`='54600',`att28`='VILLERS-LES-NANCY',`att31`='61.69',`att29`='616.9',`attdatmod`='202505151811',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '441') AND (id_type = '168') LIMIT 1 UID:--181113-- UPDATE `vent_att` SET `id_work`='417',`att4`='3',`attdatmod`='202505151811',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '329') AND (id_type = '148') LIMIT 1 UID:--181113-- UPDATE `vent_att` SET `id_work`='412',`attf107`='202505151811',`attdatmod`='202505151811',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '393') AND (id_type = '165') LIMIT 1 UID:--181113-- UPDATE `tier_att` SET `id_work`='205',`attdatmod`='202505151811',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3085') AND (id_type = '80') LIMIT 1 UID:--215944--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:--215944--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre