UID:--093751--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:--093751--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:10--093758--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--093758--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--100647--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:--100647-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202506011006' )
UID:--100647-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='maison individuelle - terrasse - Toul',`att90`='gxj-fhg5k36ftr28',`attf100`='20250526',`att5`='3210',`att8`='6',`att9`='3044.7',`att10`='304.47',`att11`='3349.17',`att13`='chèque ou virement',`att14`='589',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Epinal</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>2 rue de la Ballastière<br>\n                    88190 GOLBEY</p>\n                  ',`att16`='  883 Avenue Georges Clemenceau 54200 TOUL',`att18`='534.12',`att24`='2815.05',`att25`='883 Avenue Georges Clemenceau',`att26`='',`att27`='54200',`att28`='TOUL',`attdatmod`='202506011006',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '652')  AND (id_type = '168')  LIMIT 1 
UID:--100647-- UPDATE  `vent_att`  SET `newobj`='new'  WHERE 1=1  AND (id_type = '168')  AND (id_vent = '652')  LIMIT 1 
UID:--100647-- UPDATE  `tier_lig`  SET `lig2`='33',`ligdatmod`='202506011006',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '2')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '3')  LIMIT 1 
UID:--100647-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-EPI-33',`att3`='',`att2`='maison individuelle - terrasse - Toul',`att90`='gxj-fhg5k36ftr28',`attf100`='20250526',`att5`='3210',`att8`='6',`att9`='3044.7',`att10`='304.47',`att11`='3349.17',`att13`='chèque ou virement',`att14`='589',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Epinal</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>2 rue de la Ballastière<br>\n                    88190 GOLBEY</p>\n                  ',`att16`='  883 Avenue Georges Clemenceau 54200 TOUL',`att18`='534.12',`att24`='2815.05',`att25`='883 Avenue Georges Clemenceau',`att26`='',`att27`='54200',`att28`='TOUL',`attdatmod`='202506011006',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '652')  AND (id_type = '168')  LIMIT 1 
UID:--100647-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','652','202506011006','202506011006' )
UID:--100647-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='157',`lig7`='0.00',`lig22`='Partie pavés',`lig91`='<b>Partie pavés</b><br /><p><br></p>',`lig4`='0.00',`lig8`='0.00',`lig6`='0.00',`lig90`='<p><br></p>',`ligdatmod`='202506011006',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '652')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '1232')  LIMIT 1 
UID:--100647-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','652','202506011006','202506011006' )
UID:--100647-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='113',`lig7`='242.78',`lig9`='113',`lig16`='M2',`lig91`='<b>Nettoyage de la terrasse (1)</b><br /><p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`lig3`='122',`lig2`='19.90',`lig5`='10',`lig4`='2427.80',`lig8`='2670.58',`lig10`='pourcentage',`lig11`='20',`lig6`='2136.46',`lig90`='&lt;p&gt;Nettoyage et désinfection du support via un procédé vapeur basse pression &lt;/p&gt;',`ligdatmod`='202506011006',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '652')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '1233')  LIMIT 1 
UID:--100647-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','652','202506011006','202506011006' )
UID:--100647-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='157',`lig7`='0.00',`lig22`='Partie béton',`lig91`='<b>Partie béton</b><br /><p><br></p>',`lig2`='0.00',`lig4`='0.00',`lig8`='0.00',`lig6`='0.00',`lig90`='<p><br></p>',`ligdatmod`='202506011006',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '652')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '1234')  LIMIT 1 
UID:--100647-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','652','202506011006','202506011006' )
UID:--100647-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='113',`lig7`='61.69',`lig9`='113',`lig16`='M2',`lig91`='<b>Nettoyage de la terrasse (1)</b><br /><p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`lig3`='31',`lig2`='19.90',`lig5`='10',`lig4`='616.90',`lig8`='678.59',`lig10`='euro',`lig6`='678.59',`lig90`='&lt;p&gt;Nettoyage et désinfection du support via un procédé vapeur basse pression &lt;/p&gt;',`ligdatmod`='202506011006',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '652')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '1235')  LIMIT 1 
UID:--100647-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('242','1','2','Devis_DV-EPI-76_26_05_2025_19h_49m_signe.pdf','20250601','351','devis_signe','168','652','-2','-1','' )
UID:--100647-- UPDATE  `file`  SET `size`='407392'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '730')  LIMIT 1 
UID:--100647-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('243','1','2','Attestation_fiscale_DV_EPI_76_26_05_2025_19h_40m_signe.pdf','20250601','915','attestation_signe','168','652','-2','-1','' )
UID:--100647-- UPDATE  `file`  SET `size`='471486'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '731')  LIMIT 1 
UID:--100647-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250601','','1','contact@exteco.fr','Exteco','lionel.iselin54@gmail.com','','','Merci pour votre commande : Devis N°DV-EPI-76','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Nouveau Devis EXTECO</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Merci pour votre commande (Devis N° DV-EPI-76)\r\n                            </p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour madame ISELIN,<br><br>Nous vous remercions pour votre commande. Vous trouverez ci-joint le devis que vous avez signé.<br></p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">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.<br><br>\r\n                                Nous vous remercions de votre confiance et restons à votre disposition pour toute information complémentaire.<br><br>\r\n                                Cordialement, <br>\r\n                            </p>\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Votre équipe Exteco</p>\r\n                            <div style=\"display: flex; flex-direction: column; justify-content: center; align-items: center; text-align: center;\"><br></div>\r\n                        </td>\r\n                    </tr>\r\n                    <!-- END MAIN CONTENT AREA -->\r\n\r\n                    </tbody></table>\r\n                <!-- END CENTERED WHITE CONTAINER -->\r\n\r\n            </div>\r\n        </td>\r\n    </tr>\r\n    </tbody></table>\r\n','/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/730-242-351-1§Devis_DV-EPI-76_26_05_2025_19h_49m_signe.pdf;/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/731-243-915-1§Attestation_fiscale_DV_EPI_76_26_05_2025_19h_40m_signe.pdf','0','v2017b' )
UID:--100647-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '526')  LIMIT 1 
UID:--100647-- UPDATE  `vent_lig`  SET `lig1`='157',`lig7`='0.00',`lig22`='Partie pavés',`lig91`='<b>Partie pavés</b><br /><p><br></p>',`lig4`='0.00',`lig8`='0.00',`lig6`='0.00',`lig90`='<p><br></p>',`lig3`='1',`ligdatmod`='202506011006',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '652')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '1232')  LIMIT 1 
UID:--100647-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-EPI-33',`att3`='',`att2`='maison individuelle - terrasse - Toul',`att90`='gxj-fhg5k36ftr28',`attf100`='20250526',`att5`='3210',`att8`='6',`att9`='3044.7',`att10`='304.47',`att11`='3349.17',`att13`='chèque ou virement',`att14`='589',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Epinal</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>2 rue de la Ballastière<br>\n                    88190 GOLBEY</p>\n                  ',`att16`='  883 Avenue Georges Clemenceau 54200 TOUL',`att18`='534.12',`att24`='2815.05',`att25`='883 Avenue Georges Clemenceau',`att26`='',`att27`='54200',`att28`='TOUL',`att31`='255.91',`att29`='2559.14',`attdatmod`='202506011006',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '652')  AND (id_type = '168')  LIMIT 1 
UID:--100648-- UPDATE  `vent_att`  SET `id_work`='417',`att4`='11',`attdatmod`='202506011006',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '521')  AND (id_type = '148')  LIMIT 1 
UID:--100648-- UPDATE  `vent_att`  SET `id_work`='412',`attf107`='202506011006',`attdatmod`='202506011006',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '589')  AND (id_type = '165')  LIMIT 1 
UID:--100648-- UPDATE  `tier_att`  SET `id_work`='205',`attdatmod`='202506011006',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3210')  AND (id_type = '80')  LIMIT 1 
UID:--102638--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:--102638--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--133526-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202506011335' )
UID:--133526-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Jean-Marc',`att1`='Massé',`att8`='non_défini',`att12`='adloise@orange.fr',`att14`='1 rue de la Paix',`att7`='85500',`att17`='Les Herbiers',`att18`='France',`att5`='0616730416',`attf102`='20250601',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250601',`attdatmod`='202506011335',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3314')  AND (id_type = '80')  LIMIT 1 
UID:--133526-- INSERT INTO  `tier_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3314','202506011335','202506011335' )
UID:--133526-- UPDATE  `tier_lig`  SET `actif`='1',`lig7`='Adresse principale',`lig2`='1 rue de la Paix',`lig4`='85500',`lig5`='Les Herbiers',`lig6`='France',`ligdatmod`='202506011335',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '3314')  AND ( id_type = '80')  AND ( id_tlig = '147')  AND ( id_lig = '1665')  LIMIT 1 
UID:--133526-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Jean-Marc',`att1`='Massé',`att8`='non_défini',`att12`='adloise@orange.fr',`att14`='1 rue de la Paix',`att7`='85500',`att17`='Les Herbiers',`att18`='France',`att5`='0616730416',`attf102`='20250601',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250601',`att19`='46.866535',`att20`='-1.011826',`attf100`='1',`attdatmod`='202506011335',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3314')  AND (id_type = '80')  LIMIT 1 
UID:--133526-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Jean-Marc',`att1`='Massé',`att8`='non_défini',`att12`='adloise@orange.fr',`att14`='1 rue de la Paix',`att7`='85500',`att17`='Les Herbiers',`att18`='France',`att5`='0616730416',`attf102`='20250601',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250601',`att19`='46.866535',`att20`='-1.011826',`attf100`='1',`attdatmod`='202506011335',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3314')  AND (id_type = '80')  LIMIT 1 
UID:--133526-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202506011335' )
UID:--133526-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Massé',`att3`='Jean-Marc',`att5`='0616730416',`att6`='adloise@orange.fr',`att8`='3314',`att10`='[IDMYUSER]',`attdatmod`='202506011335',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3315')  AND (id_type = '149')  LIMIT 1 
UID:--133526-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202506011335' )
UID:--133526-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-',`att2`='3314',`att90`='Nous serions intéressés pour un nettoyage toiture et façades ! \r\nMerci de nous donner plus d’information svp, durée, coût, passez-vous quelque chose après pour protéger ? \r\nMerci d’avance cordialement \r\nJM Massé',`attf100`='20250601',`att8`='1665',`att6`='[IDMYUSER]',`att9`='3315',`att3`='§toiture§',`attdatmod`='202506011335',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '653')  AND (id_type = '148')  LIMIT 1 
UID:--133526-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Massé',`att2`='3314',`att90`='Nous serions intéressés pour un nettoyage toiture et façades ! \r\nMerci de nous donner plus d’information svp, durée, coût, passez-vous quelque chose après pour protéger ? \r\nMerci d’avance cordialement \r\nJM Massé',`attf100`='20250601',`att8`='1665',`att6`='[IDMYUSER]',`att9`='3315',`att3`='§toiture§',`attdatmod`='202506011335',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '653')  AND (id_type = '148')  LIMIT 1 
UID:--133526-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Massé',`att2`='3314',`att90`='Nous serions intéressés pour un nettoyage toiture et façades ! \r\nMerci de nous donner plus d’information svp, durée, coût, passez-vous quelque chose après pour protéger ? \r\nMerci d’avance cordialement \r\nJM Massé',`attf100`='20250601',`att8`='1665',`att6`='[IDMYUSER]',`att9`='3315',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202506011335',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '653')  AND (id_type = '148')  LIMIT 1 
UID:--133526-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Massé',`att2`='3314',`att90`='Nous serions intéressés pour un nettoyage toiture et façades ! \r\nMerci de nous donner plus d’information svp, durée, coût, passez-vous quelque chose après pour protéger ? \r\nMerci d’avance cordialement \r\nJM Massé',`attf100`='20250601',`att8`='1665',`att6`='0',`att9`='3315',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202506011335',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '653')  AND (id_type = '148')  LIMIT 1 
UID:--133526-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250601','','1','','Exteco','contact@exteco.fr','','','Exteco - Nouvelle opportunité - OPP-Massé','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Nouvelle opportunite</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Nouvelle opportunité - OPP-Massé</p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour Exteco,</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Vous avez reçu une nouvelle demande de contact.<br><br>Coordonnées du contact :</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Nom : Massé</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Prénom : Jean-Marc</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Téléphone : 0616730416</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Mail : adloise@orange.fr</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Service : toiture</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Adresse : 1 rue de la Paix</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Code Postal : 85500</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Ville : Les Herbiers</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Message : Nous serions intéressés pour un nettoyage toiture et façades ! \r\nMerci de nous donner plus d\'information svp, durée, coût, passez-vous quelque chose après pour protéger ? \r\nMerci d\'avance cordialement \r\nJM Massé</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\"><br></p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Bonne prise de contact !&nbsp;&nbsp;</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\"><br></p>\r\n\r\n                            <!-- Button -->\r\n                            <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: 100%; margin: 0 auto;\" width=\"100%\">\r\n                                <tbody><tr>\r\n                                    <td align=\"center\" style=\"padding-bottom: 16px;\">\r\n                                        <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: auto; margin: 0 auto;\">\r\n                                            <tbody><tr>\r\n                                                <td align=\"center\" valign=\"top\" bgcolor=\"#005c7d\" style=\"border-radius: 4px; background-color: #005c7d; padding: 12px 24px;\"><font color=\"#ffffff\"><a href=\"https://exteco.toosmart.app/\" target=\"_blank\" style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; text-decoration: none; color: #ffffff; display: inline-block;\">\r\n                                                        Consulter l\'opportunité\r\n                                                    </a></font></td>\r\n                                            </tr>\r\n                                            </tbody></table>\r\n                                    </td>\r\n                                </tr>\r\n                                </tbody></table>\r\n                            <div style=\"display: flex; flex-direction: column; justify-content: center; align-items: center; text-align: center;\">\r\n                                \r\n                            </div>\r\n                        </td>\r\n                    </tr>\r\n                    <!-- END MAIN CONTENT AREA -->\r\n\r\n                    </tbody></table>\r\n                <!-- END CENTERED WHITE CONTAINER -->\r\n\r\n            </div>\r\n        </td>\r\n    </tr>\r\n    </tbody></table>','','0','v2017b' )
UID:--133526-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '527')  LIMIT 1 
UID:--133526--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:--133526-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Massé',`att3`='Jean-Marc',`att5`='0616730416',`att6`='adloise@orange.fr',`att8`='3314',`att10`='[IDMYUSER]',`att4`='0616730416',`attdatmod`='202506011335',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3315')  AND (id_type = '149')  LIMIT 1 
UID:--133526-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Jean-Marc',`att1`='Massé',`att8`='non_défini',`att12`='adloise@orange.fr',`att14`='1 rue de la Paix',`att7`='85500',`att17`='Les Herbiers',`att18`='France',`att5`='0616730416',`attf102`='20250601',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250601',`att19`='46.866535',`att20`='-1.011826',`attf100`='1',`attdatmod`='202506011335',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3314')  AND (id_type = '80')  LIMIT 1 
UID:--133526-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Jean-Marc',`att1`='Massé',`att8`='non_défini',`att12`='adloise@orange.fr',`att14`='1 rue de la Paix',`att7`='85500',`att17`='Les Herbiers',`att18`='France',`att5`='0616730416',`attf102`='20250601',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250601',`att19`='46.866535',`att20`='-1.011826',`attf100`='1',`attdatmod`='202506011335',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3314')  AND (id_type = '80')  LIMIT 1 
UID:--133526-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Jean-Marc',`att1`='Massé',`att8`='non_défini',`att12`='adloise@orange.fr',`att14`='1 rue de la Paix',`att7`='85500',`att17`='Les Herbiers',`att18`='France',`att5`='0616730416',`attf102`='20250601',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250601',`att19`='46.866535',`att20`='-1.011826',`attf100`='1',`att6`='0616730416',`attdatmod`='202506011335',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3314')  AND (id_type = '80')  LIMIT 1 
UID:--133526-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Massé',`att2`='3314',`att90`='Nous serions intéressés pour un nettoyage toiture et façades ! \r\nMerci de nous donner plus d’information svp, durée, coût, passez-vous quelque chose après pour protéger ? \r\nMerci d’avance cordialement \r\nJM Massé',`attf100`='20250601',`att8`='1665',`att6`='0',`att9`='3315',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202506011335',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '653')  AND (id_type = '148')  LIMIT 1 
UID:--134641-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202506011346' )
UID:--134641-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Noémie',`att1`='Fiore',`att8`='non_défini',`att12`='noemie.fiore@wanadoo.fr',`att14`='16 rue de l&#039;avenir',`att7`='88000',`att17`='DEYVILLERS',`att18`='France',`att5`='0679317856',`attf102`='20250601',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250601',`attdatmod`='202506011346',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3316')  AND (id_type = '80')  LIMIT 1 
UID:--134641-- INSERT INTO  `tier_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3316','202506011346','202506011346' )
UID:--134641-- UPDATE  `tier_lig`  SET `actif`='1',`lig7`='Adresse principale',`lig2`='16 rue de l&#039;avenir',`lig4`='88000',`lig5`='DEYVILLERS',`lig6`='France',`ligdatmod`='202506011346',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '3316')  AND ( id_type = '80')  AND ( id_tlig = '147')  AND ( id_lig = '1666')  LIMIT 1 
UID:--134641-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Noémie',`att1`='Fiore',`att8`='non_défini',`att12`='noemie.fiore@wanadoo.fr',`att14`='16 rue de l&#039;avenir',`att7`='88000',`att17`='DEYVILLERS',`att18`='France',`att5`='0679317856',`attf102`='20250601',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250601',`att19`='48.19821',`att20`='6.508767',`attf100`='1',`attdatmod`='202506011346',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3316')  AND (id_type = '80')  LIMIT 1 
UID:--134641-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Noémie',`att1`='Fiore',`att8`='non_défini',`att12`='noemie.fiore@wanadoo.fr',`att14`='16 rue de l&#039;avenir',`att7`='88000',`att17`='DEYVILLERS',`att18`='France',`att5`='0679317856',`attf102`='20250601',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250601',`att19`='48.19821',`att20`='6.508767',`attf100`='1',`attdatmod`='202506011346',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3316')  AND (id_type = '80')  LIMIT 1 
UID:--134641-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202506011346' )
UID:--134641-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Fiore',`att3`='Noémie',`att5`='0679317856',`att6`='noemie.fiore@wanadoo.fr',`att8`='3316',`att10`='[IDMYUSER]',`attdatmod`='202506011346',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3317')  AND (id_type = '149')  LIMIT 1 
UID:--134641-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202506011346' )
UID:--134641-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-',`att2`='3316',`att90`='Bonjour, nous souhaitons faire nettoyer nos tuiles béton posées en 2001. Les chevrons auraient également besoin d&#039;être poncés et repeints, et quelques petits trous auraient besoin d&#039;être colmatés à la jointure de ces chevrons et de la façade. Par avance merci pour votre réponse. ( Il me semble que la surface de toiture est de 100m2. )',`attf100`='20250601',`att8`='1666',`att6`='[IDMYUSER]',`att9`='3317',`att3`='§toiture§',`attdatmod`='202506011346',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '654')  AND (id_type = '148')  LIMIT 1 
UID:--134641-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Fiore',`att2`='3316',`att90`='Bonjour, nous souhaitons faire nettoyer nos tuiles béton posées en 2001. Les chevrons auraient également besoin d&#039;être poncés et repeints, et quelques petits trous auraient besoin d&#039;être colmatés à la jointure de ces chevrons et de la façade. Par avance merci pour votre réponse. ( Il me semble que la surface de toiture est de 100m2. )',`attf100`='20250601',`att8`='1666',`att6`='[IDMYUSER]',`att9`='3317',`att3`='§toiture§',`attdatmod`='202506011346',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '654')  AND (id_type = '148')  LIMIT 1 
UID:--134641-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Fiore',`att2`='3316',`att90`='Bonjour, nous souhaitons faire nettoyer nos tuiles béton posées en 2001. Les chevrons auraient également besoin d&#039;être poncés et repeints, et quelques petits trous auraient besoin d&#039;être colmatés à la jointure de ces chevrons et de la façade. Par avance merci pour votre réponse. ( Il me semble que la surface de toiture est de 100m2. )',`attf100`='20250601',`att8`='1666',`att6`='[IDMYUSER]',`att9`='3317',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202506011346',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '654')  AND (id_type = '148')  LIMIT 1 
UID:--134641-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Fiore',`att2`='3316',`att90`='Bonjour, nous souhaitons faire nettoyer nos tuiles béton posées en 2001. Les chevrons auraient également besoin d&#039;être poncés et repeints, et quelques petits trous auraient besoin d&#039;être colmatés à la jointure de ces chevrons et de la façade. Par avance merci pour votre réponse. ( Il me semble que la surface de toiture est de 100m2. )',`attf100`='20250601',`att8`='1666',`att6`='0',`att9`='3317',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202506011346',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '654')  AND (id_type = '148')  LIMIT 1 
UID:--134641-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250601','','1','','Exteco','contact@exteco.fr','','','Exteco - Nouvelle opportunité - OPP-Fiore','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Nouvelle opportunite</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Nouvelle opportunité - OPP-Fiore</p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour Exteco,</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Vous avez reçu une nouvelle demande de contact.<br><br>Coordonnées du contact :</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Nom : Fiore</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Prénom : Noémie</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Téléphone : 0679317856</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Mail : noemie.fiore@wanadoo.fr</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Service : toiture</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Adresse : 16 rue de l&#039;avenir</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Code Postal : 88000</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Ville : DEYVILLERS</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Message : Bonjour, nous souhaitons faire nettoyer nos tuiles béton posées en 2001. Les chevrons auraient également besoin d&#039;être poncés et repeints, et quelques petits trous auraient besoin d&#039;être colmatés à la jointure de ces chevrons et de la façade. Par avance merci pour votre réponse. ( Il me semble que la surface de toiture est de 100m2. )</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\"><br></p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Bonne prise de contact !&nbsp;&nbsp;</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\"><br></p>\r\n\r\n                            <!-- Button -->\r\n                            <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: 100%; margin: 0 auto;\" width=\"100%\">\r\n                                <tbody><tr>\r\n                                    <td align=\"center\" style=\"padding-bottom: 16px;\">\r\n                                        <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: auto; margin: 0 auto;\">\r\n                                            <tbody><tr>\r\n                                                <td align=\"center\" valign=\"top\" bgcolor=\"#005c7d\" style=\"border-radius: 4px; background-color: #005c7d; padding: 12px 24px;\"><font color=\"#ffffff\"><a href=\"https://exteco.toosmart.app/\" target=\"_blank\" style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; text-decoration: none; color: #ffffff; display: inline-block;\">\r\n                                                        Consulter l\'opportunité\r\n                                                    </a></font></td>\r\n                                            </tr>\r\n                                            </tbody></table>\r\n                                    </td>\r\n                                </tr>\r\n                                </tbody></table>\r\n                            <div style=\"display: flex; flex-direction: column; justify-content: center; align-items: center; text-align: center;\">\r\n                                \r\n                            </div>\r\n                        </td>\r\n                    </tr>\r\n                    <!-- END MAIN CONTENT AREA -->\r\n\r\n                    </tbody></table>\r\n                <!-- END CENTERED WHITE CONTAINER -->\r\n\r\n            </div>\r\n        </td>\r\n    </tr>\r\n    </tbody></table>','','0','v2017b' )
UID:--134641-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '528')  LIMIT 1 
UID:--134641--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:--134642-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Fiore',`att3`='Noémie',`att5`='0679317856',`att6`='noemie.fiore@wanadoo.fr',`att8`='3316',`att10`='[IDMYUSER]',`att4`='0679317856',`attdatmod`='202506011346',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3317')  AND (id_type = '149')  LIMIT 1 
UID:--134642-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Noémie',`att1`='Fiore',`att8`='non_défini',`att12`='noemie.fiore@wanadoo.fr',`att14`='16 rue de l&#039;avenir',`att7`='88000',`att17`='DEYVILLERS',`att18`='France',`att5`='0679317856',`attf102`='20250601',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250601',`att19`='48.19821',`att20`='6.508767',`attf100`='1',`attdatmod`='202506011346',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3316')  AND (id_type = '80')  LIMIT 1 
UID:--134642-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Noémie',`att1`='Fiore',`att8`='non_défini',`att12`='noemie.fiore@wanadoo.fr',`att14`='16 rue de l&#039;avenir',`att7`='88000',`att17`='DEYVILLERS',`att18`='France',`att5`='0679317856',`attf102`='20250601',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250601',`att19`='48.19821',`att20`='6.508767',`attf100`='1',`attdatmod`='202506011346',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3316')  AND (id_type = '80')  LIMIT 1 
UID:--134642-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Noémie',`att1`='Fiore',`att8`='non_défini',`att12`='noemie.fiore@wanadoo.fr',`att14`='16 rue de l&#039;avenir',`att7`='88000',`att17`='DEYVILLERS',`att18`='France',`att5`='0679317856',`attf102`='20250601',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250601',`att19`='48.19821',`att20`='6.508767',`attf100`='1',`att6`='0679317856',`attdatmod`='202506011346',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3316')  AND (id_type = '80')  LIMIT 1 
UID:--134642-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Fiore',`att2`='3316',`att90`='Bonjour, nous souhaitons faire nettoyer nos tuiles béton posées en 2001. Les chevrons auraient également besoin d&#039;être poncés et repeints, et quelques petits trous auraient besoin d&#039;être colmatés à la jointure de ces chevrons et de la façade. Par avance merci pour votre réponse. ( Il me semble que la surface de toiture est de 100m2. )',`attf100`='20250601',`att8`='1666',`att6`='0',`att9`='3317',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202506011346',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '654')  AND (id_type = '148')  LIMIT 1 
UID:--142342--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:--142342--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--173032--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:--173032--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--192127-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202506011921' )
UID:--192127-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Thibaud',`att1`='Perrin',`att8`='non_défini',`att12`='perrin.thibaud@gmail.com',`att14`='42T Rue de la Foucotte, Nancy, France',`att7`='54000',`att17`='Nancy',`att18`='France',`att5`='0686591632',`attf102`='20250601',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250601',`attdatmod`='202506011921',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3318')  AND (id_type = '80')  LIMIT 1 
UID:--192127-- INSERT INTO  `tier_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3318','202506011921','202506011921' )
UID:--192127-- UPDATE  `tier_lig`  SET `actif`='1',`lig7`='Adresse principale',`lig2`='42T Rue de la Foucotte, Nancy, France',`lig4`='54000',`lig5`='Nancy',`lig6`='France',`ligdatmod`='202506011921',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '3318')  AND ( id_type = '80')  AND ( id_tlig = '147')  AND ( id_lig = '1667')  LIMIT 1 
UID:--192127-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Thibaud',`att1`='Perrin',`att8`='non_défini',`att12`='perrin.thibaud@gmail.com',`att14`='42T Rue de la Foucotte, Nancy, France',`att7`='54000',`att17`='Nancy',`att18`='France',`att5`='0686591632',`attf102`='20250601',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250601',`att19`='48.696135',`att20`='6.161122',`attf100`='1',`attdatmod`='202506011921',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3318')  AND (id_type = '80')  LIMIT 1 
UID:--192127-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Thibaud',`att1`='Perrin',`att8`='non_défini',`att12`='perrin.thibaud@gmail.com',`att14`='42T Rue de la Foucotte, Nancy, France',`att7`='54000',`att17`='Nancy',`att18`='France',`att5`='0686591632',`attf102`='20250601',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250601',`att19`='48.696135',`att20`='6.161122',`attf100`='1',`attdatmod`='202506011921',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3318')  AND (id_type = '80')  LIMIT 1 
UID:--192127-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202506011921' )
UID:--192128-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Perrin',`att3`='Thibaud',`att5`='0686591632',`att6`='perrin.thibaud@gmail.com',`att8`='3318',`att10`='[IDMYUSER]',`attdatmod`='202506011921',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3319')  AND (id_type = '149')  LIMIT 1 
UID:--192128-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202506011921' )
UID:--192128-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-',`att2`='3318',`att90`='Nettoyage vitre et éventuellement démoussage toit',`attf100`='20250601',`att8`='1667',`att6`='[IDMYUSER]',`att9`='3319',`att3`='§vitres§',`attdatmod`='202506011921',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '655')  AND (id_type = '148')  LIMIT 1 
UID:--192128-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Perrin',`att2`='3318',`att90`='Nettoyage vitre et éventuellement démoussage toit',`attf100`='20250601',`att8`='1667',`att6`='[IDMYUSER]',`att9`='3319',`att3`='§vitres§',`attdatmod`='202506011921',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '655')  AND (id_type = '148')  LIMIT 1 
UID:--192128-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Perrin',`att2`='3318',`att90`='Nettoyage vitre et éventuellement démoussage toit',`attf100`='20250601',`att8`='1667',`att6`='[IDMYUSER]',`att9`='3319',`att3`='§vitres§',`att5`='',`att10`='non_défini',`attdatmod`='202506011921',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '655')  AND (id_type = '148')  LIMIT 1 
UID:--192128-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Perrin',`att2`='3318',`att90`='Nettoyage vitre et éventuellement démoussage toit',`attf100`='20250601',`att8`='1667',`att6`='0',`att9`='3319',`att3`='§vitres§',`att5`='',`att10`='non_défini',`attdatmod`='202506011921',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '655')  AND (id_type = '148')  LIMIT 1 
UID:--192128-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250601','','1','','Exteco','contact@exteco.fr','','','Exteco - Nouvelle opportunité - OPP-Perrin','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Nouvelle opportunite</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Nouvelle opportunité - OPP-Perrin</p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour Exteco,</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Vous avez reçu une nouvelle demande de contact.<br><br>Coordonnées du contact :</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Nom : Perrin</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Prénom : Thibaud</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Téléphone : 0686591632</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Mail : perrin.thibaud@gmail.com</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Service : vitres</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Adresse : 42T Rue de la Foucotte, Nancy, France</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Code Postal : 54000</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Ville : Nancy</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Message : Nettoyage vitre et éventuellement démoussage toit</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\"><br></p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Bonne prise de contact !&nbsp;&nbsp;</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\"><br></p>\r\n\r\n                            <!-- Button -->\r\n                            <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: 100%; margin: 0 auto;\" width=\"100%\">\r\n                                <tbody><tr>\r\n                                    <td align=\"center\" style=\"padding-bottom: 16px;\">\r\n                                        <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: auto; margin: 0 auto;\">\r\n                                            <tbody><tr>\r\n                                                <td align=\"center\" valign=\"top\" bgcolor=\"#005c7d\" style=\"border-radius: 4px; background-color: #005c7d; padding: 12px 24px;\"><font color=\"#ffffff\"><a href=\"https://exteco.toosmart.app/\" target=\"_blank\" style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; text-decoration: none; color: #ffffff; display: inline-block;\">\r\n                                                        Consulter l\'opportunité\r\n                                                    </a></font></td>\r\n                                            </tr>\r\n                                            </tbody></table>\r\n                                    </td>\r\n                                </tr>\r\n                                </tbody></table>\r\n                            <div style=\"display: flex; flex-direction: column; justify-content: center; align-items: center; text-align: center;\">\r\n                                \r\n                            </div>\r\n                        </td>\r\n                    </tr>\r\n                    <!-- END MAIN CONTENT AREA -->\r\n\r\n                    </tbody></table>\r\n                <!-- END CENTERED WHITE CONTAINER -->\r\n\r\n            </div>\r\n        </td>\r\n    </tr>\r\n    </tbody></table>','','0','v2017b' )
UID:--192128-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '529')  LIMIT 1 
UID:--192128--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:--192128-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Perrin',`att3`='Thibaud',`att5`='0686591632',`att6`='perrin.thibaud@gmail.com',`att8`='3318',`att10`='[IDMYUSER]',`att4`='0686591632',`attdatmod`='202506011921',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3319')  AND (id_type = '149')  LIMIT 1 
UID:--192128-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Thibaud',`att1`='Perrin',`att8`='non_défini',`att12`='perrin.thibaud@gmail.com',`att14`='42T Rue de la Foucotte, Nancy, France',`att7`='54000',`att17`='Nancy',`att18`='France',`att5`='0686591632',`attf102`='20250601',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250601',`att19`='48.696135',`att20`='6.161122',`attf100`='1',`attdatmod`='202506011921',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3318')  AND (id_type = '80')  LIMIT 1 
UID:--192128-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Thibaud',`att1`='Perrin',`att8`='non_défini',`att12`='perrin.thibaud@gmail.com',`att14`='42T Rue de la Foucotte, Nancy, France',`att7`='54000',`att17`='Nancy',`att18`='France',`att5`='0686591632',`attf102`='20250601',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250601',`att19`='48.696135',`att20`='6.161122',`attf100`='1',`attdatmod`='202506011921',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3318')  AND (id_type = '80')  LIMIT 1 
UID:--192128-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Thibaud',`att1`='Perrin',`att8`='non_défini',`att12`='perrin.thibaud@gmail.com',`att14`='42T Rue de la Foucotte, Nancy, France',`att7`='54000',`att17`='Nancy',`att18`='France',`att5`='0686591632',`attf102`='20250601',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250601',`att19`='48.696135',`att20`='6.161122',`attf100`='1',`att6`='0686591632',`attdatmod`='202506011921',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3318')  AND (id_type = '80')  LIMIT 1 
UID:--192128-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Perrin',`att2`='3318',`att90`='Nettoyage vitre et éventuellement démoussage toit',`attf100`='20250601',`att8`='1667',`att6`='0',`att9`='3319',`att3`='§vitres§',`att5`='',`att10`='non_défini',`attdatmod`='202506011921',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '655')  AND (id_type = '148')  LIMIT 1 
UID:--213109--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:--213109--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--220256--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:--220256--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--221727--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:--221727--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre