UID:--095304--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--095304--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--095308--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--095308--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--095446--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--095446--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--100000--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--100000--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--100045--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--100045--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--100229--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--100229--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--100448--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--100448--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--100949--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--100949--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--100949--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:--101021-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202504221010' )
UID:--101021-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Boudilmi',`att1`='Test',`att8`='professionnel',`att12`='boudilmitest@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250422',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250422',`att24`='7',`attdatmod`='202504221010',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '8')  AND (id_type = '80')  LIMIT 1 
UID:--101021-- INSERT INTO  `tier_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','8','202504221010','202504221010' )
UID:--101021-- UPDATE  `tier_lig`  SET `actif`='1',`lig7`='Adresse principale',`lig2`='66 rue coste',`lig4`='69300',`lig5`='Caluire et cuire',`lig6`='France',`ligdatmod`='202504221010',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '8')  AND ( id_type = '80')  AND ( id_tlig = '147')  AND ( id_lig = '35')  LIMIT 1 
UID:--101021-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Boudilmi',`att1`='Test',`att8`='professionnel',`att12`='boudilmitest@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250422',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250422',`att24`='7',`att19`='45.786944',`att20`='4.834154',`attf100`='1',`attdatmod`='202504221010',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '8')  AND (id_type = '80')  LIMIT 1 
UID:--101022-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Boudilmi',`att1`='Test',`att8`='professionnel',`att12`='boudilmitest@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250422',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250422',`att24`='7',`att19`='45.786944',`att20`='4.834154',`attf100`='1',`attdatmod`='202504221010',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '8')  AND (id_type = '80')  LIMIT 1 
UID:--101022-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202504221010' )
UID:--101022-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Test',`att3`='Boudilmi',`att5`='0909090909',`att6`='boudilmitest@toosmart.fr',`att8`='8',`att10`='[IDMYUSER]',`attdatmod`='202504221010',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '9')  AND (id_type = '149')  LIMIT 1 
UID:--101022-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202504221010' )
UID:--101022-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-',`att2`='8',`att90`='devis pour démoussage toiture',`attf100`='20250422',`att8`='35',`att6`='[IDMYUSER]',`att9`='9',`att3`='§toiture§',`attdatmod`='202504221010',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2')  AND (id_type = '148')  LIMIT 1 
UID:--101022-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='8',`att90`='devis pour démoussage toiture',`attf100`='20250422',`att8`='35',`att6`='[IDMYUSER]',`att9`='9',`att3`='§toiture§',`attdatmod`='202504221010',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2')  AND (id_type = '148')  LIMIT 1 
UID:--101022-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='8',`att90`='devis pour démoussage toiture',`attf100`='20250422',`att8`='35',`att6`='[IDMYUSER]',`att9`='9',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504221010',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2')  AND (id_type = '148')  LIMIT 1 
UID:--101022-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='8',`att90`='devis pour démoussage toiture',`attf100`='20250422',`att8`='35',`att6`='0',`att9`='9',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504221010',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2')  AND (id_type = '148')  LIMIT 1 
UID:--101022-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250422','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Test','<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-Test</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://prod.egiteko.net/toosmart_exteco/soft/www/\" 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:--101022-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '7')  LIMIT 1 
UID:--101022--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:--101022-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Test',`att3`='Boudilmi',`att5`='0909090909',`att6`='boudilmitest@toosmart.fr',`att8`='8',`att10`='[IDMYUSER]',`att4`='0909090909',`attdatmod`='202504221010',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '9')  AND (id_type = '149')  LIMIT 1 
UID:--101022-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Boudilmi',`att1`='Test',`att8`='professionnel',`att12`='boudilmitest@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250422',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250422',`att24`='7',`att19`='45.786944',`att20`='4.834154',`attf100`='1',`attdatmod`='202504221010',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '8')  AND (id_type = '80')  LIMIT 1 
UID:--101022-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Boudilmi',`att1`='Test',`att8`='professionnel',`att12`='boudilmitest@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250422',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250422',`att24`='7',`att19`='45.786944',`att20`='4.834154',`attf100`='1',`attdatmod`='202504221010',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '8')  AND (id_type = '80')  LIMIT 1 
UID:--101022-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Boudilmi',`att1`='Test',`att8`='professionnel',`att12`='boudilmitest@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250422',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250422',`att24`='7',`att19`='45.786944',`att20`='4.834154',`attf100`='1',`att6`='0909090909',`attdatmod`='202504221010',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '8')  AND (id_type = '80')  LIMIT 1 
UID:--101022-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='8',`att90`='devis pour démoussage toiture',`attf100`='20250422',`att8`='35',`att6`='0',`att9`='9',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504221010',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2')  AND (id_type = '148')  LIMIT 1 
UID:1--101546--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--101546--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--101816-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202504221018' )
UID:--101816-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-',`att2`='8',`att90`='devis pour démoussage toiture',`attf100`='20250422',`att8`='35',`att6`='[IDMYUSER]',`att9`='Array',`att3`='§toiture§',`attdatmod`='202504221018',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '3')  AND (id_type = '148')  LIMIT 1 
UID:--101816-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='8',`att90`='devis pour démoussage toiture',`attf100`='20250422',`att8`='35',`att6`='[IDMYUSER]',`att9`='Array',`att3`='§toiture§',`attdatmod`='202504221018',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '3')  AND (id_type = '148')  LIMIT 1 
UID:--101816-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='8',`att90`='devis pour démoussage toiture',`attf100`='20250422',`att8`='35',`att6`='[IDMYUSER]',`att9`='Array',`att3`='§toiture§',`att5`='',`att10`='professionnel',`attdatmod`='202504221018',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '3')  AND (id_type = '148')  LIMIT 1 
UID:--101816-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='8',`att90`='devis pour démoussage toiture',`attf100`='20250422',`att8`='35',`att6`='0',`att9`='Array',`att3`='§toiture§',`att5`='',`att10`='professionnel',`attdatmod`='202504221018',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '3')  AND (id_type = '148')  LIMIT 1 
UID:--101816-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250422','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Test','<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-Test</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://prod.egiteko.net/toosmart_exteco/soft/www/\" 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:--101816-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '8')  LIMIT 1 
UID:--101816--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:--101816-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250422','','1','','Exteco','franchise@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Test','<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-Test</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 Franchisé , (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://prod.egiteko.net/toosmart_exteco/soft/www/\" 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:--101816-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '9')  LIMIT 1 
UID:--101816-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='8',`att90`='devis pour démoussage toiture',`attf100`='20250422',`att8`='35',`att6`='0',`att9`='Array',`att3`='§toiture§',`att5`='',`att10`='professionnel',`attdatmod`='202504221018',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '3')  AND (id_type = '148')  LIMIT 1 
UID:--101831-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202504221018' )
UID:--101831-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Boudilmi',`att1`='Test',`att8`='professionnel',`att12`='boudilmitest2@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250422',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250422',`att24`='7',`attdatmod`='202504221018',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '10')  AND (id_type = '80')  LIMIT 1 
UID:--101831-- INSERT INTO  `tier_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','10','202504221018','202504221018' )
UID:--101831-- UPDATE  `tier_lig`  SET `actif`='1',`lig7`='Adresse principale',`lig2`='66 rue coste',`lig4`='69300',`lig5`='Caluire et cuire',`lig6`='France',`ligdatmod`='202504221018',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '10')  AND ( id_type = '80')  AND ( id_tlig = '147')  AND ( id_lig = '36')  LIMIT 1 
UID:--101831-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Boudilmi',`att1`='Test',`att8`='professionnel',`att12`='boudilmitest2@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250422',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250422',`att24`='7',`att19`='45.786944',`att20`='4.834154',`attf100`='1',`attdatmod`='202504221018',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '10')  AND (id_type = '80')  LIMIT 1 
UID:--101831-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Boudilmi',`att1`='Test',`att8`='professionnel',`att12`='boudilmitest2@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250422',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250422',`att24`='7',`att19`='45.786944',`att20`='4.834154',`attf100`='1',`attdatmod`='202504221018',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '10')  AND (id_type = '80')  LIMIT 1 
UID:--101831-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202504221018' )
UID:--101831-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Test',`att3`='Boudilmi',`att5`='0909090909',`att6`='boudilmitest2@toosmart.fr',`att8`='10',`att10`='[IDMYUSER]',`attdatmod`='202504221018',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '11')  AND (id_type = '149')  LIMIT 1 
UID:--101831-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202504221018' )
UID:--101831-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-',`att2`='10',`att90`='devis pour démoussage toiture',`attf100`='20250422',`att8`='36',`att6`='[IDMYUSER]',`att9`='11',`att3`='§toiture§',`attdatmod`='202504221018',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '4')  AND (id_type = '148')  LIMIT 1 
UID:--101831-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='10',`att90`='devis pour démoussage toiture',`attf100`='20250422',`att8`='36',`att6`='[IDMYUSER]',`att9`='11',`att3`='§toiture§',`attdatmod`='202504221018',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '4')  AND (id_type = '148')  LIMIT 1 
UID:--101831-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='10',`att90`='devis pour démoussage toiture',`attf100`='20250422',`att8`='36',`att6`='[IDMYUSER]',`att9`='11',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504221018',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '4')  AND (id_type = '148')  LIMIT 1 
UID:--101831-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='10',`att90`='devis pour démoussage toiture',`attf100`='20250422',`att8`='36',`att6`='0',`att9`='11',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504221018',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '4')  AND (id_type = '148')  LIMIT 1 
UID:--101831-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250422','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Test','<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-Test</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://prod.egiteko.net/toosmart_exteco/soft/www/\" 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:--101831-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '10')  LIMIT 1 
UID:--101831--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:--101831-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Test',`att3`='Boudilmi',`att5`='0909090909',`att6`='boudilmitest2@toosmart.fr',`att8`='10',`att10`='[IDMYUSER]',`att4`='0909090909',`attdatmod`='202504221018',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '11')  AND (id_type = '149')  LIMIT 1 
UID:--101831-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Boudilmi',`att1`='Test',`att8`='professionnel',`att12`='boudilmitest2@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250422',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250422',`att24`='7',`att19`='45.786944',`att20`='4.834154',`attf100`='1',`attdatmod`='202504221018',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '10')  AND (id_type = '80')  LIMIT 1 
UID:--101831-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Boudilmi',`att1`='Test',`att8`='professionnel',`att12`='boudilmitest2@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250422',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250422',`att24`='7',`att19`='45.786944',`att20`='4.834154',`attf100`='1',`attdatmod`='202504221018',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '10')  AND (id_type = '80')  LIMIT 1 
UID:--101831-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Boudilmi',`att1`='Test',`att8`='professionnel',`att12`='boudilmitest2@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250422',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250422',`att24`='7',`att19`='45.786944',`att20`='4.834154',`attf100`='1',`att6`='0909090909',`attdatmod`='202504221018',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '10')  AND (id_type = '80')  LIMIT 1 
UID:--101831-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='10',`att90`='devis pour démoussage toiture',`attf100`='20250422',`att8`='36',`att6`='0',`att9`='11',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504221018',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '4')  AND (id_type = '148')  LIMIT 1 
UID:--101914-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202504221019' )
UID:--101914-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Boudilmi',`att1`='Test',`att8`='professionnel',`att12`='boudilmitest3@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250422',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250422',`att24`='7',`attdatmod`='202504221019',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '12')  AND (id_type = '80')  LIMIT 1 
UID:--101914-- INSERT INTO  `tier_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','12','202504221019','202504221019' )
UID:--101914-- UPDATE  `tier_lig`  SET `actif`='1',`lig7`='Adresse principale',`lig2`='66 rue coste',`lig4`='69300',`lig5`='Caluire et cuire',`lig6`='France',`ligdatmod`='202504221019',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '12')  AND ( id_type = '80')  AND ( id_tlig = '147')  AND ( id_lig = '37')  LIMIT 1 
UID:--101914-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Boudilmi',`att1`='Test',`att8`='professionnel',`att12`='boudilmitest3@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250422',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250422',`att24`='7',`att19`='45.786944',`att20`='4.834154',`attf100`='1',`attdatmod`='202504221019',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '12')  AND (id_type = '80')  LIMIT 1 
UID:--101914-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Boudilmi',`att1`='Test',`att8`='professionnel',`att12`='boudilmitest3@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250422',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250422',`att24`='7',`att19`='45.786944',`att20`='4.834154',`attf100`='1',`attdatmod`='202504221019',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '12')  AND (id_type = '80')  LIMIT 1 
UID:--101914-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202504221019' )
UID:--101914-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Test',`att3`='Boudilmi',`att5`='0909090909',`att6`='boudilmitest3@toosmart.fr',`att8`='12',`att10`='[IDMYUSER]',`attdatmod`='202504221019',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '13')  AND (id_type = '149')  LIMIT 1 
UID:--101914-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202504221019' )
UID:--101915-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-',`att2`='12',`att90`='devis pour démoussage toiture',`attf100`='20250422',`att8`='37',`att6`='[IDMYUSER]',`att9`='13',`att3`='§toiture§',`attdatmod`='202504221019',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '5')  AND (id_type = '148')  LIMIT 1 
UID:--101915-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='12',`att90`='devis pour démoussage toiture',`attf100`='20250422',`att8`='37',`att6`='[IDMYUSER]',`att9`='13',`att3`='§toiture§',`attdatmod`='202504221019',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '5')  AND (id_type = '148')  LIMIT 1 
UID:--101915-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='12',`att90`='devis pour démoussage toiture',`attf100`='20250422',`att8`='37',`att6`='[IDMYUSER]',`att9`='13',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504221019',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '5')  AND (id_type = '148')  LIMIT 1 
UID:--101915-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='12',`att90`='devis pour démoussage toiture',`attf100`='20250422',`att8`='37',`att6`='0',`att9`='13',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504221019',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '5')  AND (id_type = '148')  LIMIT 1 
UID:--101915-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250422','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Test','<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-Test</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://prod.egiteko.net/toosmart_exteco/soft/www/\" 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:--101915-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '11')  LIMIT 1 
UID:--101915--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:--101915-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Test',`att3`='Boudilmi',`att5`='0909090909',`att6`='boudilmitest3@toosmart.fr',`att8`='12',`att10`='[IDMYUSER]',`att4`='0909090909',`attdatmod`='202504221019',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '13')  AND (id_type = '149')  LIMIT 1 
UID:--101915-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Boudilmi',`att1`='Test',`att8`='professionnel',`att12`='boudilmitest3@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250422',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250422',`att24`='7',`att19`='45.786944',`att20`='4.834154',`attf100`='1',`attdatmod`='202504221019',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '12')  AND (id_type = '80')  LIMIT 1 
UID:--101915-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Boudilmi',`att1`='Test',`att8`='professionnel',`att12`='boudilmitest3@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250422',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250422',`att24`='7',`att19`='45.786944',`att20`='4.834154',`attf100`='1',`attdatmod`='202504221019',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '12')  AND (id_type = '80')  LIMIT 1 
UID:--101915-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Boudilmi',`att1`='Test',`att8`='professionnel',`att12`='boudilmitest3@toosmart.fr',`att14`='66 rue coste',`att7`='69300',`att17`='Caluire et cuire',`att18`='France',`att5`='0909090909',`attf102`='20250422',`attf103`='1',`attf104`='1',`att11`='facebook',`attf105`='20250422',`att24`='7',`att19`='45.786944',`att20`='4.834154',`attf100`='1',`att6`='0909090909',`attdatmod`='202504221019',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '12')  AND (id_type = '80')  LIMIT 1 
UID:--101915-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='12',`att90`='devis pour démoussage toiture',`attf100`='20250422',`att8`='37',`att6`='0',`att9`='13',`att3`='§toiture§',`att10`='professionnel',`attdatmod`='202504221019',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '5')  AND (id_type = '148')  LIMIT 1 
UID:--102018-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202504221020' )
UID:--102018-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-',`att2`='12',`att90`='devis pour démoussage toiture',`attf100`='20250422',`att8`='37',`att6`='[IDMYUSER]',`att9`='Array',`att3`='§toiture§',`attdatmod`='202504221020',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '6')  AND (id_type = '148')  LIMIT 1 
UID:--102018-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='12',`att90`='devis pour démoussage toiture',`attf100`='20250422',`att8`='37',`att6`='[IDMYUSER]',`att9`='Array',`att3`='§toiture§',`attdatmod`='202504221020',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '6')  AND (id_type = '148')  LIMIT 1 
UID:--102018-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='12',`att90`='devis pour démoussage toiture',`attf100`='20250422',`att8`='37',`att6`='[IDMYUSER]',`att9`='Array',`att3`='§toiture§',`att5`='',`att10`='professionnel',`attdatmod`='202504221020',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '6')  AND (id_type = '148')  LIMIT 1 
UID:--102018-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='12',`att90`='devis pour démoussage toiture',`attf100`='20250422',`att8`='37',`att6`='0',`att9`='Array',`att3`='§toiture§',`att5`='',`att10`='professionnel',`attdatmod`='202504221020',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '6')  AND (id_type = '148')  LIMIT 1 
UID:--102018-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250422','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Test','<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-Test</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://prod.egiteko.net/toosmart_exteco/soft/www/\" 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:--102018-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '12')  LIMIT 1 
UID:--102018--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:--102018-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250422','','1','','Exteco','franchise@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Test','<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-Test</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 Franchisé , (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://prod.egiteko.net/toosmart_exteco/soft/www/\" 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:--102018-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '13')  LIMIT 1 
UID:--102018-- UPDATE  `vent_att`  SET `att7`='facebook',`att1`='OPP-Test',`att2`='12',`att90`='devis pour démoussage toiture',`attf100`='20250422',`att8`='37',`att6`='0',`att9`='Array',`att3`='§toiture§',`att5`='',`att10`='professionnel',`attdatmod`='202504221020',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '6')  AND (id_type = '148')  LIMIT 1 
UID:1--105511--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--105511--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--110434--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--110434--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--112116--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--112116--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--114101--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--114101--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--144304--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--144304--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--154252--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--154252--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--154426--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--154426--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--154555--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--154555--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--154645--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--154645--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--154721--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--154721--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--154748--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--154748--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--154753--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--154753--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--161052--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--161052--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--161809--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--161809--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--161848--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--161848--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--170145--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--170145--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--171135--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:--171135--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--171442--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--171442--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--171445--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90,88)
        ORDER BY pm.ordre
UID:1--171445--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--175622--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:--175622--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--180443--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:--180443--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--181049--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:--181049--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--190433--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:--190433--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--190512--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:--190512--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--194820--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:--194820--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--211628--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:--211628--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre