UID:--073425--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:--073425--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--075629--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:--075629--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--085030--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:--085030--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--101338--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:--101338--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--133155--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:--133155--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--141115--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:--141115--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--161533--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)
        ORDER BY pm.ordre
UID:--161533--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--162301--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)
        ORDER BY pm.ordre
UID:1--162301--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--174413--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:--174413-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202506091744' )
UID:--174413-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='Maison individuelle - Terrasses - Ars Laquenexy',`att90`='rwnclrne4w9bbpi0',`attf100`='20250514',`att5`='3138',`att8`='8',`att9`='1532.3',`att10`='153.24',`att11`='1685.54',`att13`='chèque ou virement',`att14`='398',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Metz</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>10 Rue Rochambeau<br>\n                    57000 Metz</p>\n                    <br><p><',`att16`='  27 Rue des Poitiers 57350 Ars Laquenexy',`att18`='252.83',`att29`='1302.46',`att24`='1432.71',`att25`='27 Rue des Poitiers',`att26`='',`att27`='57350',`att28`='Ars Laquenexy',`attdatmod`='202506091744',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '739')  AND (id_type = '168')  LIMIT 1 
UID:--174413-- UPDATE  `vent_att`  SET `newobj`='new'  WHERE 1=1  AND (id_type = '168')  AND (id_vent = '739')  LIMIT 1 
UID:--174413-- UPDATE  `tier_lig`  SET `lig2`='18',`ligdatmod`='202506091744',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '3')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '8')  LIMIT 1 
UID:--174413-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-METZ-18',`att3`='',`att2`='Maison individuelle - Terrasses - Ars Laquenexy',`att90`='rwnclrne4w9bbpi0',`attf100`='20250514',`att5`='3138',`att8`='8',`att9`='1532.3',`att10`='153.24',`att11`='1685.54',`att13`='chèque ou virement',`att14`='398',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Metz</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>10 Rue Rochambeau<br>\n                    57000 Metz</p>\n                    <br><p><',`att16`='  27 Rue des Poitiers 57350 Ars Laquenexy',`att18`='252.83',`att29`='1302.46',`att24`='1432.71',`att25`='27 Rue des Poitiers',`att26`='',`att27`='57350',`att28`='Ars Laquenexy',`attdatmod`='202506091744',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '739')  AND (id_type = '168')  LIMIT 1 
UID:--174413-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','739','202506091744','202506091744' )
UID:--174413-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='122',`lig7`='48.16',`lig9`='122',`lig16`='M2',`lig91`='<b>Nettoyage de la terrasse (2)</b><br /><p><font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">Sol Pavé Rose</font></p><p><br></p><p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`lig3`='22',`lig2`='21.89',`lig5`='10',`lig4`='481.58',`lig8`='529.74',`lig10`='pourcentage',`lig11`='15',`lig6`='450.28',`lig90`='<p><font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">Sol Pavé Rose</font></p><p><br></p><p>Nettoyage et désinfection du support via un procédé vapeur basse pression&nbsp;</p>',`ligdatmod`='202506091744',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '739')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '1356')  LIMIT 1 
UID:--174413-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','739','202506091744','202506091744' )
UID:--174413-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='122',`lig7`='39.40',`lig9`='122',`lig16`='M2',`lig91`='<b>Nettoyage de la terrasse (2)</b><br /><p><font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">Sol Dalle Terrasse et Escaliers</font></p><p><br></p><p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`lig3`='18',`lig2`='21.89',`lig5`='10',`lig4`='394.02',`lig8`='433.42',`lig10`='pourcentage',`lig11`='15',`lig6`='368.41',`lig90`='<p><font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">Sol Dalle Terrasse et Escaliers</font></p><p><br></p><p>Nettoyage et désinfection du support via un procédé vapeur basse pression&nbsp;</p>',`ligdatmod`='202506091744',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '739')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '1357')  LIMIT 1 
UID:--174414-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','739','202506091744','202506091744' )
UID:--174414-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='122',`lig7`='32.84',`lig9`='122',`lig16`='M2',`lig91`='<b>Nettoyage de la terrasse (2)</b><br /><p><font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">Sol Muret interieur</font></p><p><br></p><p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`lig3`='15',`lig2`='21.89',`lig5`='10',`lig4`='328.35',`lig8`='361.19',`lig10`='pourcentage',`lig11`='15',`lig6`='307.01',`lig90`='<p><font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">Sol Muret interieur</font></p><p><br></p><p>Nettoyage et désinfection du support via un procédé vapeur basse pression&nbsp;</p>',`ligdatmod`='202506091744',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '739')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '1358')  LIMIT 1 
UID:--174414-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','739','202506091744','202506091744' )
UID:--174414-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='122',`lig7`='32.84',`lig9`='122',`lig16`='M2',`lig91`='<b>Nettoyage de la terrasse (2)</b><br /><p><font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">Sol Muret Extérieur</font></p><p><br></p><p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`lig3`='15',`lig2`='21.89',`lig5`='10',`lig4`='328.35',`lig8`='361.19',`lig10`='pourcentage',`lig11`='15',`lig6`='307.01',`lig90`='<p><font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">Sol Muret Extérieur</font></p><p><br></p><p>Nettoyage et désinfection du support via un procédé vapeur basse pression&nbsp;</p>',`ligdatmod`='202506091744',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '739')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '1359')  LIMIT 1 
UID:--174414-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('276','1','2','Devis_DV-METZ-37_26_05_2025_17h_23m_signe.pdf','20250609','1','devis_signe','168','739','-2','-1','' )
UID:--174414-- UPDATE  `file`  SET `size`='653489'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '854')  LIMIT 1 
UID:--174414-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('277','1','2','Attestation_fiscale_DV_METZ_37_14_05_2025_16h_12m_signe.pdf','20250609','240','attestation_signe','168','739','-2','-1','' )
UID:--174414-- UPDATE  `file`  SET `size`='857139'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '855')  LIMIT 1 
UID:--174414-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250609','','1','contact@exteco.fr','Exteco','erchevau@gmail.com','','','Merci pour votre commande : Devis N°DV-METZ-37','<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-METZ-37)\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 monsieur CHEVAU,<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/854-276-1-1§Devis_DV-METZ-37_26_05_2025_17h_23m_signe.pdf;/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/855-277-240-1§Attestation_fiscale_DV_METZ_37_14_05_2025_16h_12m_signe.pdf','0','v2017b' )
UID:--174414-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '629')  LIMIT 1 
UID:--174414-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250609','','1','contact@exteco.fr','Exteco','agence-metz@exteco.fr','','','Devis signé - N° DV-METZ-37','<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>Devis signé</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                                Devis signé (Devis N° DV-METZ-37)\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,<br><br>Le devis n°DV-METZ-37 de   a été signé électroniquement.</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;\">\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>','','0','v2017b' )
UID:--174414-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '630')  LIMIT 1 
UID:--174414-- UPDATE  `vent_lig`  SET `lig1`='122',`lig7`='48.16',`lig9`='122',`lig16`='M2',`lig91`='<b>Nettoyage de la terrasse (2)</b><br /><p><font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">Sol Pavé Rose</font></p><p><br></p><p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`lig3`='22',`lig2`='21.89',`lig5`='10',`lig4`='481.58',`lig8`='529.74',`lig10`='pourcentage',`lig11`='15',`lig6`='450.28',`lig90`='<p><font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">Sol Pavé Rose</font></p><p><br></p><p>Nettoyage et désinfection du support via un procédé vapeur basse pression&nbsp;</p>',`ligdatmod`='202506091744',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '739')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '1356')  LIMIT 1 
UID:--174414-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-METZ-18',`att3`='',`att2`='Maison individuelle - Terrasses - Ars Laquenexy',`att90`='rwnclrne4w9bbpi0',`attf100`='20250514',`att5`='3138',`att8`='8',`att9`='1532.3',`att10`='153.23',`att11`='1685.53',`att13`='chèque ou virement',`att14`='398',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Metz</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>10 Rue Rochambeau<br>\n                    57000 Metz</p>\n                    <br><p><',`att16`='  27 Rue des Poitiers 57350 Ars Laquenexy',`att18`='252.82',`att29`='1302.46',`att24`='1432.71',`att25`='27 Rue des Poitiers',`att26`='',`att27`='57350',`att28`='Ars Laquenexy',`att31`='130.25',`attdatmod`='202506091744',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '739')  AND (id_type = '168')  LIMIT 1 
UID:--174415-- UPDATE  `vent_att`  SET `id_work`='417',`att4`='26',`attdatmod`='202506091744',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '397')  AND (id_type = '148')  LIMIT 1 
UID:--174415-- UPDATE  `vent_att`  SET `id_work`='412',`attf107`='202506091744',`attdatmod`='202506091744',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '398')  AND (id_type = '165')  LIMIT 1 
UID:--174415-- UPDATE  `tier_att`  SET `id_work`='205',`att26`='',`attdatmod`='202506091744',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3138')  AND (id_type = '80')  LIMIT 1 
UID:--180029--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:--180029--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--182942-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202506091829' )
UID:--182942-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Jose',`att1`='Dos Santos',`att8`='non_défini',`att12`='josedossantos54230@gmail.com',`att14`='611A Rue du Puisot, Neuves-Maisons, France',`att7`='54230',`att17`='Neuves-Maisons',`att18`='France',`att5`='0685650271',`attf102`='20250609',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250609',`att26`='',`attdatmod`='202506091829',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3404')  AND (id_type = '80')  LIMIT 1 
UID:--182942-- INSERT INTO  `tier_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3404','202506091829','202506091829' )
UID:--182942-- UPDATE  `tier_lig`  SET `actif`='1',`lig7`='Adresse principale',`lig2`='611A Rue du Puisot, Neuves-Maisons, France',`lig4`='54230',`lig5`='Neuves-Maisons',`lig6`='France',`ligdatmod`='202506091829',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '3404')  AND ( id_type = '80')  AND ( id_tlig = '147')  AND ( id_lig = '1709')  LIMIT 1 
UID:--182942-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Jose',`att1`='Dos Santos',`att8`='non_défini',`att12`='josedossantos54230@gmail.com',`att14`='611A Rue du Puisot, Neuves-Maisons, France',`att7`='54230',`att17`='Neuves-Maisons',`att18`='France',`att5`='0685650271',`attf102`='20250609',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250609',`att26`='',`att19`='48.621125',`att20`='6.099652',`attf100`='1',`attdatmod`='202506091829',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3404')  AND (id_type = '80')  LIMIT 1 
UID:--182942-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Jose',`att1`='Dos Santos',`att8`='non_défini',`att12`='josedossantos54230@gmail.com',`att14`='611A Rue du Puisot, Neuves-Maisons, France',`att7`='54230',`att17`='Neuves-Maisons',`att18`='France',`att5`='0685650271',`attf102`='20250609',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250609',`att26`='',`att19`='48.621125',`att20`='6.099652',`attf100`='1',`attdatmod`='202506091829',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3404')  AND (id_type = '80')  LIMIT 1 
UID:--182942-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202506091829' )
UID:--182942-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Dos Santos',`att3`='Jose',`att5`='0685650271',`att6`='josedossantos54230@gmail.com',`att8`='3404',`att10`='[IDMYUSER]',`attdatmod`='202506091829',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3405')  AND (id_type = '149')  LIMIT 1 
UID:--182942-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202506091829' )
UID:--182942-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-',`att2`='3404',`att90`='Bonsoir ça serait pour avoir un devis pour le nettoyage de ma toiture en vous remerciant.',`attf100`='20250609',`att8`='1709',`att6`='[IDMYUSER]',`att9`='3405',`att3`='§toiture§',`attdatmod`='202506091829',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '740')  AND (id_type = '148')  LIMIT 1 
UID:--182942-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Dos Santos',`att2`='3404',`att90`='Bonsoir ça serait pour avoir un devis pour le nettoyage de ma toiture en vous remerciant.',`attf100`='20250609',`att8`='1709',`att6`='[IDMYUSER]',`att9`='3405',`att3`='§toiture§',`attdatmod`='202506091829',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '740')  AND (id_type = '148')  LIMIT 1 
UID:--182942-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Dos Santos',`att2`='3404',`att90`='Bonsoir ça serait pour avoir un devis pour le nettoyage de ma toiture en vous remerciant.',`attf100`='20250609',`att8`='1709',`att6`='[IDMYUSER]',`att9`='3405',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202506091829',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '740')  AND (id_type = '148')  LIMIT 1 
UID:--182942-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Dos Santos',`att2`='3404',`att90`='Bonsoir ça serait pour avoir un devis pour le nettoyage de ma toiture en vous remerciant.',`attf100`='20250609',`att8`='1709',`att6`='0',`att9`='3405',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202506091829',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '740')  AND (id_type = '148')  LIMIT 1 
UID:--182942-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250609','','1','','Exteco','contact@exteco.fr','','','Exteco - Nouvelle opportunité - OPP-Dos Santos','<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-Dos Santos</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 : Dos Santos</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Prénom : Jose</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Téléphone : 0685650271</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Mail : josedossantos54230@gmail.com</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 : 611A Rue du Puisot, Neuves-Maisons, France</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Code Postal : 54230</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Ville : Neuves-Maisons</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Message : Bonsoir ça serait pour avoir un devis pour le nettoyage de ma toiture en vous remerciant.</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:--182942-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '631')  LIMIT 1 
UID:--182942--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:--182942-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Dos Santos',`att3`='Jose',`att5`='0685650271',`att6`='josedossantos54230@gmail.com',`att8`='3404',`att10`='[IDMYUSER]',`att4`='0685650271',`attdatmod`='202506091829',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3405')  AND (id_type = '149')  LIMIT 1 
UID:--182942-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Jose',`att1`='Dos Santos',`att8`='non_défini',`att12`='josedossantos54230@gmail.com',`att14`='611A Rue du Puisot, Neuves-Maisons, France',`att7`='54230',`att17`='Neuves-Maisons',`att18`='France',`att5`='0685650271',`attf102`='20250609',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250609',`att26`='',`att19`='48.621125',`att20`='6.099652',`attf100`='1',`attdatmod`='202506091829',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3404')  AND (id_type = '80')  LIMIT 1 
UID:--182942-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Jose',`att1`='Dos Santos',`att8`='non_défini',`att12`='josedossantos54230@gmail.com',`att14`='611A Rue du Puisot, Neuves-Maisons, France',`att7`='54230',`att17`='Neuves-Maisons',`att18`='France',`att5`='0685650271',`attf102`='20250609',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250609',`att26`='',`att19`='48.621125',`att20`='6.099652',`attf100`='1',`attdatmod`='202506091829',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3404')  AND (id_type = '80')  LIMIT 1 
UID:--182942-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Jose',`att1`='Dos Santos',`att8`='non_défini',`att12`='josedossantos54230@gmail.com',`att14`='611A Rue du Puisot, Neuves-Maisons, France',`att7`='54230',`att17`='Neuves-Maisons',`att18`='France',`att5`='0685650271',`attf102`='20250609',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250609',`att26`='',`att19`='48.621125',`att20`='6.099652',`attf100`='1',`att6`='0685650271',`attdatmod`='202506091829',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3404')  AND (id_type = '80')  LIMIT 1 
UID:--182942-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Dos Santos',`att2`='3404',`att90`='Bonsoir ça serait pour avoir un devis pour le nettoyage de ma toiture en vous remerciant.',`attf100`='20250609',`att8`='1709',`att6`='0',`att9`='3405',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202506091829',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '740')  AND (id_type = '148')  LIMIT 1 
UID:--192803--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:--192803--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--200825--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:--200825--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--200918--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:--200918--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:8--204421--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--204421--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:8--205546--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--205546--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--205706--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:--205706--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--210142--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:--210142--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:3--210212--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:3--210212--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:10--210408--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('577','1','2','Devis_DV-LSDO-36_20_05_2025_10h_10m.pdf','20250609','893','10','-3','-2')
UID:10--210408--UPDATE `file` SET `last`='1' , `size`='507747' , `fol_id`='2' , `esp_id`='1' WHERE file_id=856
UID:10--210408--UPDATE `file` SET `id_type`='169' , `id_obje`='179' , `specif`='' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=856
UID:10--210408--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=856
UID:10--210408--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1
UID:10--210408--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','10','2','856','577','Devis_DV-LSDO-36_20_05_2025_10h_10m.pdf','1','20250609','21:04:08','upload')