UID:--085912-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505040859' )
UID:--085912-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Jean-François',`att1`='Delavergne',`att8`='non_défini',`att12`='jeffdelavergne@yahoo.fr',`att21`='10',`att14`='24 rue des tamaris la mothe achard',`att7`='85150',`att17`='Les achards',`att18`='France',`att5`='0616501066',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att24`='4',`attdatmod`='202505040859',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3013')  AND (id_type = '80')  LIMIT 1 
UID:--085912-- INSERT INTO  `tier_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3013','202505040859','202505040859' )
UID:--085912-- UPDATE  `tier_lig`  SET `actif`='1',`lig7`='Adresse principale',`lig2`='24 rue des tamaris la mothe achard',`lig4`='85150',`lig5`='Les achards',`lig6`='France',`ligdatmod`='202505040859',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '3013')  AND ( id_type = '80')  AND ( id_tlig = '147')  AND ( id_lig = '1519')  LIMIT 1 
UID:--085912-- UPDATE  `tier_lig`  SET `lig2`='55',`ligdatmod`='202505040859',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '4')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '11')  LIMIT 1 
UID:--085912-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Jean-François',`att1`='Delavergne',`att8`='non_défini',`att12`='jeffdelavergne@yahoo.fr',`att21`='10',`att14`='24 rue des tamaris la mothe achard',`att7`='85150',`att17`='Les achards',`att18`='France',`att5`='0616501066',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att24`='4',`att19`='46.614658',`att20`='-1.668011',`att22`='CL-LSDO-55',`attf100`='1',`attdatmod`='202505040859',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3013')  AND (id_type = '80')  LIMIT 1 
UID:--085912-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Jean-François',`att1`='Delavergne',`att8`='non_défini',`att12`='jeffdelavergne@yahoo.fr',`att21`='10',`att14`='24 rue des tamaris la mothe achard',`att7`='85150',`att17`='Les achards',`att18`='France',`att5`='0616501066',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att24`='4',`att19`='46.614658',`att20`='-1.668011',`att22`='-1',`attf100`='1',`attdatmod`='202505040859',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3013')  AND (id_type = '80')  LIMIT 1 
UID:--085912-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Jean-François',`att1`='Delavergne',`att8`='non_défini',`att12`='jeffdelavergne@yahoo.fr',`att21`='10',`att14`='24 rue des tamaris la mothe achard',`att7`='85150',`att17`='Les achards',`att18`='France',`att5`='0616501066',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att24`='4',`att19`='46.614658',`att20`='-1.668011',`att22`='-1',`attf100`='1',`attdatmod`='202505040859',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3013')  AND (id_type = '80')  LIMIT 1 
UID:--085912-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505040859' )
UID:--085912-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Delavergne',`att3`='Jean-François',`att5`='0616501066',`att6`='jeffdelavergne@yahoo.fr',`att8`='3013',`att10`='[IDMYUSER]',`attdatmod`='202505040859',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3014')  AND (id_type = '149')  LIMIT 1 
UID:--085912-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505040859' )
UID:--085912-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-',`att2`='3013',`attf100`='20250504',`att8`='1519',`att6`='[IDMYUSER]',`att9`='3014',`att3`='§terrasse§',`attdatmod`='202505040859',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '239')  AND (id_type = '148')  LIMIT 1 
UID:--085912-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Delavergne',`att2`='3013',`attf100`='20250504',`att8`='1519',`att6`='[IDMYUSER]',`att9`='3014',`att3`='§terrasse§',`attdatmod`='202505040859',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '239')  AND (id_type = '148')  LIMIT 1 
UID:--085912-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Delavergne',`att2`='3013',`attf100`='20250504',`att8`='1519',`att6`='[IDMYUSER]',`att9`='3014',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505040859',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '239')  AND (id_type = '148')  LIMIT 1 
UID:--085912-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Delavergne',`att2`='3013',`attf100`='20250504',`att8`='1519',`att6`='0',`att9`='3014',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505040859',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '239')  AND (id_type = '148')  LIMIT 1 
UID:--085912-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250504','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Delavergne','<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-Delavergne</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, (Mail envoyé au franchiseur lors d\'une création de nouvelle opportunité depuis l\'api lead)<br><br>\r\n                                Une nouvelle opportunité a été enregistrée, vous pouvez aller la consulter avec le bouton ci-dessous.<br><br>\r\n                                Cordialement,</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:--085912-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '138')  LIMIT 1 
UID:--085912--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:--085912-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250504','','1','','Exteco','mathieutheo@yahoo.fr','','','Exteco - Nouvelle opportunité - OPP-Delavergne','<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-Delavergne</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 MATHIEU, (mail envoyé à la personne qui gère le client si le client existe déjà et qu\'il a déjà été affecté)<br><br>\r\n                                Une nouvelle opportunité vous a été affectée, vous pouvez aller la consulter avec le bouton ci-dessous.<br><br>\r\n                                Cordialement,</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:--085912-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '139')  LIMIT 1 
UID:--085912-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Delavergne',`att2`='3013',`attf100`='20250504',`att8`='1519',`att6`='10',`att9`='3014',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505040859',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '239')  AND (id_type = '148')  LIMIT 1 
UID:--085912-- UPDATE  `tier_lig`  SET `lig2`='56',`ligdatmod`='202505040859',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '4')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '11')  LIMIT 1 
UID:--085912-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Delavergne',`att3`='Jean-François',`att5`='0616501066',`att6`='jeffdelavergne@yahoo.fr',`att8`='3013',`att10`='[IDMYUSER]',`att4`='0616501066',`attdatmod`='202505040859',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3014')  AND (id_type = '149')  LIMIT 1 
UID:--085912-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Jean-François',`att1`='Delavergne',`att8`='non_défini',`att12`='jeffdelavergne@yahoo.fr',`att21`='10',`att14`='24 rue des tamaris la mothe achard',`att7`='85150',`att17`='Les achards',`att18`='France',`att5`='0616501066',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att24`='4',`att19`='46.614658',`att20`='-1.668011',`att22`='CL-LSDO-56',`attf100`='1',`attdatmod`='202505040859',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3013')  AND (id_type = '80')  LIMIT 1 
UID:--085912-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Jean-François',`att1`='Delavergne',`att8`='non_défini',`att12`='jeffdelavergne@yahoo.fr',`att21`='10',`att14`='24 rue des tamaris la mothe achard',`att7`='85150',`att17`='Les achards',`att18`='France',`att5`='0616501066',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att24`='4',`att19`='46.614658',`att20`='-1.668011',`att22`='CL-EPI-2588',`attf100`='1',`attdatmod`='202505040859',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3013')  AND (id_type = '80')  LIMIT 1 
UID:--085912-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Jean-François',`att1`='Delavergne',`att8`='non_défini',`att12`='jeffdelavergne@yahoo.fr',`att21`='10',`att14`='24 rue des tamaris la mothe achard',`att7`='85150',`att17`='Les achards',`att18`='France',`att5`='0616501066',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att24`='4',`att19`='46.614658',`att20`='-1.668011',`att22`='CL-EPI-2588',`attf100`='1',`attdatmod`='202505040859',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3013')  AND (id_type = '80')  LIMIT 1 
UID:--085912-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Jean-François',`att1`='Delavergne',`att8`='non_défini',`att12`='jeffdelavergne@yahoo.fr',`att21`='10',`att14`='24 rue des tamaris la mothe achard',`att7`='85150',`att17`='Les achards',`att18`='France',`att5`='0616501066',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att24`='4',`att19`='46.614658',`att20`='-1.668011',`att22`='CL-EPI-2588',`attf100`='1',`att6`='0616501066',`attdatmod`='202505040859',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3013')  AND (id_type = '80')  LIMIT 1 
UID:--085912-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Delavergne',`att2`='3013',`attf100`='20250504',`att8`='1519',`att6`='10',`att9`='3014',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505040859',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '239')  AND (id_type = '148')  LIMIT 1 
UID:--094441--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:--094441--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--100929--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:--100929--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:9--102045--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:9--102045--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--102859-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505041028' )
UID:--102859-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Sophie',`att1`='ERNST',`att8`='non_défini',`att12`='fofiee@hotmail.com',`att21`='4',`att14`='22 le clos des vignes',`att7`='57310',`att17`='Bousse',`att18`='France',`att5`='0675828304',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att24`='3',`attdatmod`='202505041028',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3015')  AND (id_type = '80')  LIMIT 1 
UID:--102859-- INSERT INTO  `tier_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3015','202505041028','202505041028' )
UID:--102859-- UPDATE  `tier_lig`  SET `actif`='1',`lig7`='Adresse principale',`lig2`='22 le clos des vignes',`lig4`='57310',`lig5`='Bousse',`lig6`='France',`ligdatmod`='202505041028',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '3015')  AND ( id_type = '80')  AND ( id_tlig = '147')  AND ( id_lig = '1520')  LIMIT 1 
UID:--102859-- UPDATE  `tier_lig`  SET `lig2`='265',`ligdatmod`='202505041028',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '3')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '6')  LIMIT 1 
UID:--102859-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Sophie',`att1`='ERNST',`att8`='non_défini',`att12`='fofiee@hotmail.com',`att21`='4',`att14`='22 le clos des vignes',`att7`='57310',`att17`='Bousse',`att18`='France',`att5`='0675828304',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att24`='3',`att19`='49.286228',`att20`='6.192795',`att22`='CL-METZ-265',`attf100`='1',`attdatmod`='202505041028',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3015')  AND (id_type = '80')  LIMIT 1 
UID:--102859-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Sophie',`att1`='ERNST',`att8`='non_défini',`att12`='fofiee@hotmail.com',`att21`='4',`att14`='22 le clos des vignes',`att7`='57310',`att17`='Bousse',`att18`='France',`att5`='0675828304',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att24`='3',`att19`='49.286228',`att20`='6.192795',`att22`='-1',`attf100`='1',`attdatmod`='202505041028',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3015')  AND (id_type = '80')  LIMIT 1 
UID:--102859-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Sophie',`att1`='ERNST',`att8`='non_défini',`att12`='fofiee@hotmail.com',`att21`='4',`att14`='22 le clos des vignes',`att7`='57310',`att17`='Bousse',`att18`='France',`att5`='0675828304',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att24`='3',`att19`='49.286228',`att20`='6.192795',`att22`='-1',`attf100`='1',`attdatmod`='202505041028',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3015')  AND (id_type = '80')  LIMIT 1 
UID:--102859-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505041028' )
UID:--102859-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='ERNST',`att3`='Sophie',`att5`='0675828304',`att6`='fofiee@hotmail.com',`att8`='3015',`att10`='[IDMYUSER]',`attdatmod`='202505041028',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3016')  AND (id_type = '149')  LIMIT 1 
UID:--102859-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505041028' )
UID:--102859-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-',`att2`='3015',`attf100`='20250504',`att8`='1520',`att6`='[IDMYUSER]',`att9`='3016',`att3`='§toiture§',`attdatmod`='202505041028',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '240')  AND (id_type = '148')  LIMIT 1 
UID:--102859-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-ERNST',`att2`='3015',`attf100`='20250504',`att8`='1520',`att6`='[IDMYUSER]',`att9`='3016',`att3`='§toiture§',`attdatmod`='202505041028',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '240')  AND (id_type = '148')  LIMIT 1 
UID:--102859-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-ERNST',`att2`='3015',`attf100`='20250504',`att8`='1520',`att6`='[IDMYUSER]',`att9`='3016',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505041028',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '240')  AND (id_type = '148')  LIMIT 1 
UID:--102859-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-ERNST',`att2`='3015',`attf100`='20250504',`att8`='1520',`att6`='0',`att9`='3016',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505041028',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '240')  AND (id_type = '148')  LIMIT 1 
UID:--102859-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250504','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-ERNST','<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-ERNST</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, (Mail envoyé au franchiseur lors d\'une création de nouvelle opportunité depuis l\'api lead)<br><br>\r\n                                Une nouvelle opportunité a été enregistrée, vous pouvez aller la consulter avec le bouton ci-dessous.<br><br>\r\n                                Cordialement,</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:--102859-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '140')  LIMIT 1 
UID:--102859--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:--102859-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250504','','1','','Exteco','agence-metz@exteco.fr','','','Exteco - Nouvelle opportunité - OPP-ERNST','<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-ERNST</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 AYAD, (mail envoyé à la personne qui gère le client si le client existe déjà et qu\'il a déjà été affecté)<br><br>\r\n                                Une nouvelle opportunité vous a été affectée, vous pouvez aller la consulter avec le bouton ci-dessous.<br><br>\r\n                                Cordialement,</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:--102859-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '141')  LIMIT 1 
UID:--102859-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-ERNST',`att2`='3015',`attf100`='20250504',`att8`='1520',`att6`='4',`att9`='3016',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505041028',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '240')  AND (id_type = '148')  LIMIT 1 
UID:--102859-- UPDATE  `tier_lig`  SET `lig2`='266',`ligdatmod`='202505041028',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '3')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '6')  LIMIT 1 
UID:--102859-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='ERNST',`att3`='Sophie',`att5`='0675828304',`att6`='fofiee@hotmail.com',`att8`='3015',`att10`='[IDMYUSER]',`att4`='0675828304',`attdatmod`='202505041028',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3016')  AND (id_type = '149')  LIMIT 1 
UID:--102859-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Sophie',`att1`='ERNST',`att8`='non_défini',`att12`='fofiee@hotmail.com',`att21`='4',`att14`='22 le clos des vignes',`att7`='57310',`att17`='Bousse',`att18`='France',`att5`='0675828304',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att24`='3',`att19`='49.286228',`att20`='6.192795',`att22`='CL-METZ-266',`attf100`='1',`attdatmod`='202505041028',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3015')  AND (id_type = '80')  LIMIT 1 
UID:--102859-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Sophie',`att1`='ERNST',`att8`='non_défini',`att12`='fofiee@hotmail.com',`att21`='4',`att14`='22 le clos des vignes',`att7`='57310',`att17`='Bousse',`att18`='France',`att5`='0675828304',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att24`='3',`att19`='49.286228',`att20`='6.192795',`att22`='CL-EPI-2588',`attf100`='1',`attdatmod`='202505041028',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3015')  AND (id_type = '80')  LIMIT 1 
UID:--102859-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Sophie',`att1`='ERNST',`att8`='non_défini',`att12`='fofiee@hotmail.com',`att21`='4',`att14`='22 le clos des vignes',`att7`='57310',`att17`='Bousse',`att18`='France',`att5`='0675828304',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att24`='3',`att19`='49.286228',`att20`='6.192795',`att22`='CL-EPI-2588',`attf100`='1',`attdatmod`='202505041028',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3015')  AND (id_type = '80')  LIMIT 1 
UID:--102859-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Sophie',`att1`='ERNST',`att8`='non_défini',`att12`='fofiee@hotmail.com',`att21`='4',`att14`='22 le clos des vignes',`att7`='57310',`att17`='Bousse',`att18`='France',`att5`='0675828304',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att24`='3',`att19`='49.286228',`att20`='6.192795',`att22`='CL-EPI-2588',`attf100`='1',`att6`='0675828304',`attdatmod`='202505041028',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3015')  AND (id_type = '80')  LIMIT 1 
UID:--102859-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-ERNST',`att2`='3015',`attf100`='20250504',`att8`='1520',`att6`='4',`att9`='3016',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505041028',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '240')  AND (id_type = '148')  LIMIT 1 
UID:--163018--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:--163018--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--174855--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:--174855--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--185609--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:--185609--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:3--185623--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--185623--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:3--185624--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--185624--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--200136--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:--200136--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--201129--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:--201129--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--201228-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505042012' )
UID:--201228-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Julie',`att1`='Gross',`att8`='non_défini',`att12`='julie.chatel0503@gmail.com',`att14`='5 rue jean moulin',`att7`='54630',`att17`='Richardmenil',`att18`='France',`att5`='0632245109',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`attdatmod`='202505042012',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3017')  AND (id_type = '80')  LIMIT 1 
UID:--201228-- INSERT INTO  `tier_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3017','202505042012','202505042012' )
UID:--201228-- UPDATE  `tier_lig`  SET `actif`='1',`lig7`='Adresse principale',`lig2`='5 rue jean moulin',`lig4`='54630',`lig5`='Richardmenil',`lig6`='France',`ligdatmod`='202505042012',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '3017')  AND ( id_type = '80')  AND ( id_tlig = '147')  AND ( id_lig = '1521')  LIMIT 1 
UID:--201228-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Julie',`att1`='Gross',`att8`='non_défini',`att12`='julie.chatel0503@gmail.com',`att14`='5 rue jean moulin',`att7`='54630',`att17`='Richardmenil',`att18`='France',`att5`='0632245109',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att19`='48.593687',`att20`='6.165556',`attf100`='1',`attdatmod`='202505042012',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3017')  AND (id_type = '80')  LIMIT 1 
UID:--201228-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Julie',`att1`='Gross',`att8`='non_défini',`att12`='julie.chatel0503@gmail.com',`att14`='5 rue jean moulin',`att7`='54630',`att17`='Richardmenil',`att18`='France',`att5`='0632245109',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att19`='48.593687',`att20`='6.165556',`attf100`='1',`attdatmod`='202505042012',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3017')  AND (id_type = '80')  LIMIT 1 
UID:--201228-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505042012' )
UID:--201228-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Gross',`att3`='Julie',`att5`='0632245109',`att6`='julie.chatel0503@gmail.com',`att8`='3017',`att10`='[IDMYUSER]',`attdatmod`='202505042012',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3018')  AND (id_type = '149')  LIMIT 1 
UID:--201228-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505042012' )
UID:--201228-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-',`att2`='3017',`attf100`='20250504',`att8`='1521',`att6`='[IDMYUSER]',`att9`='3018',`att3`='§toiture§',`attdatmod`='202505042012',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '241')  AND (id_type = '148')  LIMIT 1 
UID:--201228-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Gross',`att2`='3017',`attf100`='20250504',`att8`='1521',`att6`='[IDMYUSER]',`att9`='3018',`att3`='§toiture§',`attdatmod`='202505042012',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '241')  AND (id_type = '148')  LIMIT 1 
UID:--201228-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Gross',`att2`='3017',`attf100`='20250504',`att8`='1521',`att6`='[IDMYUSER]',`att9`='3018',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505042012',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '241')  AND (id_type = '148')  LIMIT 1 
UID:--201228-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Gross',`att2`='3017',`attf100`='20250504',`att8`='1521',`att6`='0',`att9`='3018',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505042012',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '241')  AND (id_type = '148')  LIMIT 1 
UID:--201228-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250504','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Gross','<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-Gross</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, (Mail envoyé au franchiseur lors d\'une création de nouvelle opportunité depuis l\'api lead)<br><br>\r\n                                Une nouvelle opportunité a été enregistrée, vous pouvez aller la consulter avec le bouton ci-dessous.<br><br>\r\n                                Cordialement,</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:--201228-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '142')  LIMIT 1 
UID:--201228--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:--201228-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Gross',`att3`='Julie',`att5`='0632245109',`att6`='julie.chatel0503@gmail.com',`att8`='3017',`att10`='[IDMYUSER]',`att4`='0632245109',`attdatmod`='202505042012',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3018')  AND (id_type = '149')  LIMIT 1 
UID:--201228-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Julie',`att1`='Gross',`att8`='non_défini',`att12`='julie.chatel0503@gmail.com',`att14`='5 rue jean moulin',`att7`='54630',`att17`='Richardmenil',`att18`='France',`att5`='0632245109',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att19`='48.593687',`att20`='6.165556',`attf100`='1',`attdatmod`='202505042012',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3017')  AND (id_type = '80')  LIMIT 1 
UID:--201228-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Julie',`att1`='Gross',`att8`='non_défini',`att12`='julie.chatel0503@gmail.com',`att14`='5 rue jean moulin',`att7`='54630',`att17`='Richardmenil',`att18`='France',`att5`='0632245109',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att19`='48.593687',`att20`='6.165556',`attf100`='1',`attdatmod`='202505042012',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3017')  AND (id_type = '80')  LIMIT 1 
UID:--201228-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Julie',`att1`='Gross',`att8`='non_défini',`att12`='julie.chatel0503@gmail.com',`att14`='5 rue jean moulin',`att7`='54630',`att17`='Richardmenil',`att18`='France',`att5`='0632245109',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att19`='48.593687',`att20`='6.165556',`attf100`='1',`att6`='0632245109',`attdatmod`='202505042012',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3017')  AND (id_type = '80')  LIMIT 1 
UID:--201228-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Gross',`att2`='3017',`attf100`='20250504',`att8`='1521',`att6`='0',`att9`='3018',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505042012',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '241')  AND (id_type = '148')  LIMIT 1 
UID:--203629-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505042036' )
UID:--203629-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Ludovic',`att1`='Noret',`att8`='non_défini',`att12`='noret.ludovic@free.fr',`att21`='10',`att14`='Rue des noisetiers',`att7`='85190',`att17`='AIZENAY',`att18`='France',`att5`='0670422281',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att24`='4',`attdatmod`='202505042036',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3019')  AND (id_type = '80')  LIMIT 1 
UID:--203629-- INSERT INTO  `tier_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3019','202505042036','202505042036' )
UID:--203629-- UPDATE  `tier_lig`  SET `actif`='1',`lig7`='Adresse principale',`lig2`='Rue des noisetiers',`lig4`='85190',`lig5`='AIZENAY',`lig6`='France',`ligdatmod`='202505042036',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '3019')  AND ( id_type = '80')  AND ( id_tlig = '147')  AND ( id_lig = '1522')  LIMIT 1 
UID:--203629-- UPDATE  `tier_lig`  SET `lig2`='57',`ligdatmod`='202505042036',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '4')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '11')  LIMIT 1 
UID:--203629-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Ludovic',`att1`='Noret',`att8`='non_défini',`att12`='noret.ludovic@free.fr',`att21`='10',`att14`='Rue des noisetiers',`att7`='85190',`att17`='AIZENAY',`att18`='France',`att5`='0670422281',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att24`='4',`att19`='46.752276',`att20`='-1.617077',`att22`='CL-LSDO-57',`attf100`='1',`attdatmod`='202505042036',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3019')  AND (id_type = '80')  LIMIT 1 
UID:--203630-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Ludovic',`att1`='Noret',`att8`='non_défini',`att12`='noret.ludovic@free.fr',`att21`='10',`att14`='Rue des noisetiers',`att7`='85190',`att17`='AIZENAY',`att18`='France',`att5`='0670422281',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att24`='4',`att19`='46.752276',`att20`='-1.617077',`att22`='-1',`attf100`='1',`attdatmod`='202505042036',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3019')  AND (id_type = '80')  LIMIT 1 
UID:--203630-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Ludovic',`att1`='Noret',`att8`='non_défini',`att12`='noret.ludovic@free.fr',`att21`='10',`att14`='Rue des noisetiers',`att7`='85190',`att17`='AIZENAY',`att18`='France',`att5`='0670422281',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att24`='4',`att19`='46.752276',`att20`='-1.617077',`att22`='-1',`attf100`='1',`attdatmod`='202505042036',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3019')  AND (id_type = '80')  LIMIT 1 
UID:--203630-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505042036' )
UID:--203630-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Noret',`att3`='Ludovic',`att5`='0670422281',`att6`='noret.ludovic@free.fr',`att8`='3019',`att10`='[IDMYUSER]',`attdatmod`='202505042036',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3020')  AND (id_type = '149')  LIMIT 1 
UID:--203630-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505042036' )
UID:--203630-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-',`att2`='3019',`attf100`='20250504',`att8`='1522',`att6`='[IDMYUSER]',`att9`='3020',`att3`='§toiture§',`attdatmod`='202505042036',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '242')  AND (id_type = '148')  LIMIT 1 
UID:--203630-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Noret',`att2`='3019',`attf100`='20250504',`att8`='1522',`att6`='[IDMYUSER]',`att9`='3020',`att3`='§toiture§',`attdatmod`='202505042036',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '242')  AND (id_type = '148')  LIMIT 1 
UID:--203630-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Noret',`att2`='3019',`attf100`='20250504',`att8`='1522',`att6`='[IDMYUSER]',`att9`='3020',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505042036',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '242')  AND (id_type = '148')  LIMIT 1 
UID:--203630-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Noret',`att2`='3019',`attf100`='20250504',`att8`='1522',`att6`='0',`att9`='3020',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505042036',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '242')  AND (id_type = '148')  LIMIT 1 
UID:--203630-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250504','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Noret','<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-Noret</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, (Mail envoyé au franchiseur lors d\'une création de nouvelle opportunité depuis l\'api lead)<br><br>\r\n                                Une nouvelle opportunité a été enregistrée, vous pouvez aller la consulter avec le bouton ci-dessous.<br><br>\r\n                                Cordialement,</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:--203630-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '143')  LIMIT 1 
UID:--203630--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:--203630-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250504','','1','','Exteco','mathieutheo@yahoo.fr','','','Exteco - Nouvelle opportunité - OPP-Noret','<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-Noret</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 MATHIEU, (mail envoyé à la personne qui gère le client si le client existe déjà et qu\'il a déjà été affecté)<br><br>\r\n                                Une nouvelle opportunité vous a été affectée, vous pouvez aller la consulter avec le bouton ci-dessous.<br><br>\r\n                                Cordialement,</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:--203630-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '144')  LIMIT 1 
UID:--203630-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Noret',`att2`='3019',`attf100`='20250504',`att8`='1522',`att6`='10',`att9`='3020',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505042036',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '242')  AND (id_type = '148')  LIMIT 1 
UID:--203630-- UPDATE  `tier_lig`  SET `lig2`='58',`ligdatmod`='202505042036',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '4')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '11')  LIMIT 1 
UID:--203630-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Noret',`att3`='Ludovic',`att5`='0670422281',`att6`='noret.ludovic@free.fr',`att8`='3019',`att10`='[IDMYUSER]',`att4`='0670422281',`attdatmod`='202505042036',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3020')  AND (id_type = '149')  LIMIT 1 
UID:--203630-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Ludovic',`att1`='Noret',`att8`='non_défini',`att12`='noret.ludovic@free.fr',`att21`='10',`att14`='Rue des noisetiers',`att7`='85190',`att17`='AIZENAY',`att18`='France',`att5`='0670422281',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att24`='4',`att19`='46.752276',`att20`='-1.617077',`att22`='CL-LSDO-58',`attf100`='1',`attdatmod`='202505042036',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3019')  AND (id_type = '80')  LIMIT 1 
UID:--203630-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Ludovic',`att1`='Noret',`att8`='non_défini',`att12`='noret.ludovic@free.fr',`att21`='10',`att14`='Rue des noisetiers',`att7`='85190',`att17`='AIZENAY',`att18`='France',`att5`='0670422281',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att24`='4',`att19`='46.752276',`att20`='-1.617077',`att22`='CL-EPI-2588',`attf100`='1',`attdatmod`='202505042036',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3019')  AND (id_type = '80')  LIMIT 1 
UID:--203630-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Ludovic',`att1`='Noret',`att8`='non_défini',`att12`='noret.ludovic@free.fr',`att21`='10',`att14`='Rue des noisetiers',`att7`='85190',`att17`='AIZENAY',`att18`='France',`att5`='0670422281',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att24`='4',`att19`='46.752276',`att20`='-1.617077',`att22`='CL-EPI-2588',`attf100`='1',`attdatmod`='202505042036',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3019')  AND (id_type = '80')  LIMIT 1 
UID:--203630-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Ludovic',`att1`='Noret',`att8`='non_défini',`att12`='noret.ludovic@free.fr',`att21`='10',`att14`='Rue des noisetiers',`att7`='85190',`att17`='AIZENAY',`att18`='France',`att5`='0670422281',`attf102`='20250504',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250504',`att24`='4',`att19`='46.752276',`att20`='-1.617077',`att22`='CL-EPI-2588',`attf100`='1',`att6`='0670422281',`attdatmod`='202505042036',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3019')  AND (id_type = '80')  LIMIT 1 
UID:--203630-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Noret',`att2`='3019',`attf100`='20250504',`att8`='1522',`att6`='10',`att9`='3020',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505042036',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '242')  AND (id_type = '148')  LIMIT 1