UID:--073502--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:--073502--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--073625--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:--073625--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--080012--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:--080012--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--080312--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:--080312--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--080835--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--080835--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--081922--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--081922--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--081937--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:--081937--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:12--082002--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:12--082002--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--082007--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:--082007--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--082108--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--082108--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--082434-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505050824' ) UID:--082434-- UPDATE `tier_att` SET `id_work`='259',`att3`='Marie caroline',`att1`='Hurard',`att8`='non_défini',`att12`='mariecaro_6@hotmail.com',`att21`='4',`att14`='7 chemin sous les vignes',`att7`='57645',`att17`='Ogy-montoy-flanville',`att18`='France',`att5`='0788457255',`attf102`='20250505',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250505',`att24`='3',`attdatmod`='202505050824',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3021') AND (id_type = '80') LIMIT 1 UID:--082434-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3021','202505050824','202505050824' ) UID:--082434-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='7 chemin sous les vignes',`lig4`='57645',`lig5`='Ogy-montoy-flanville',`lig6`='France',`ligdatmod`='202505050824',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3021') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1523') LIMIT 1 UID:--082434-- UPDATE `tier_lig` SET `lig2`='267',`ligdatmod`='202505050824',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '6') LIMIT 1 UID:--082434-- UPDATE `tier_att` SET `id_work`='259',`att3`='Marie caroline',`att1`='Hurard',`att8`='non_défini',`att12`='mariecaro_6@hotmail.com',`att21`='4',`att14`='7 chemin sous les vignes',`att7`='57645',`att17`='Ogy-montoy-flanville',`att18`='France',`att5`='0788457255',`attf102`='20250505',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250505',`att24`='3',`att19`='49.12244',`att20`='6.29471',`att22`='CL-METZ-267',`attf100`='1',`attdatmod`='202505050824',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3021') AND (id_type = '80') LIMIT 1 UID:--082434-- UPDATE `tier_att` SET `id_work`='259',`att3`='Marie caroline',`att1`='Hurard',`att8`='non_défini',`att12`='mariecaro_6@hotmail.com',`att21`='4',`att14`='7 chemin sous les vignes',`att7`='57645',`att17`='Ogy-montoy-flanville',`att18`='France',`att5`='0788457255',`attf102`='20250505',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250505',`att24`='3',`att19`='49.12244',`att20`='6.29471',`att22`='-1',`attf100`='1',`attdatmod`='202505050824',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3021') AND (id_type = '80') LIMIT 1 UID:--082434-- UPDATE `tier_att` SET `id_work`='259',`att3`='Marie caroline',`att1`='Hurard',`att8`='non_défini',`att12`='mariecaro_6@hotmail.com',`att21`='4',`att14`='7 chemin sous les vignes',`att7`='57645',`att17`='Ogy-montoy-flanville',`att18`='France',`att5`='0788457255',`attf102`='20250505',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250505',`att24`='3',`att19`='49.12244',`att20`='6.29471',`att22`='-1',`attf100`='1',`attdatmod`='202505050824',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3021') AND (id_type = '80') LIMIT 1 UID:--082434-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505050824' ) UID:--082434-- UPDATE `tier_att` SET `id_work`='367',`att2`='Hurard',`att3`='Marie caroline',`att5`='0788457255',`att6`='mariecaro_6@hotmail.com',`att8`='3021',`att10`='[IDMYUSER]',`attdatmod`='202505050824',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3022') AND (id_type = '149') LIMIT 1 UID:--082434-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505050824' ) UID:--082434-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-',`att2`='3021',`attf100`='20250505',`att8`='1523',`att6`='[IDMYUSER]',`att9`='3022',`att3`='§façade§',`attdatmod`='202505050824',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '243') AND (id_type = '148') LIMIT 1 UID:--082434-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Hurard',`att2`='3021',`attf100`='20250505',`att8`='1523',`att6`='[IDMYUSER]',`att9`='3022',`att3`='§façade§',`attdatmod`='202505050824',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '243') AND (id_type = '148') LIMIT 1 UID:--082434-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Hurard',`att2`='3021',`attf100`='20250505',`att8`='1523',`att6`='[IDMYUSER]',`att9`='3022',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505050824',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '243') AND (id_type = '148') LIMIT 1 UID:--082434-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Hurard',`att2`='3021',`attf100`='20250505',`att8`='1523',`att6`='0',`att9`='3022',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505050824',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '243') AND (id_type = '148') LIMIT 1 UID:--082434-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250505','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Hurard','\r\n\r\nNouvelle opportunite\r\n\r\n\r\n\r\n\r\n \r\n \r\n \r\n
\r\n\r\n
\r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n\r\n
\r\n\r\n

\r\n Nouvelle opportunité - OPP-Hurard

\r\n\r\n

\r\n Bonjour Exteco, (Mail envoyé au franchiseur lors d\'une création de nouvelle opportunité depuis l\'api lead)

\r\n Une nouvelle opportunité a été enregistrée, vous pouvez aller la consulter avec le bouton ci-dessous.

\r\n Cordialement,


\r\n\r\n \r\n \r\n \r\n \r\n \r\n
\r\n \r\n \r\n \r\n \r\n
\r\n Consulter l\'opportunité\r\n
\r\n
\r\n
\r\n \r\n
\r\n
\r\n \r\n\r\n
\r\n
','','0','v2017b' ) UID:--082434-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '145') LIMIT 1 UID:--082434--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:--082434-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250505','','1','','Exteco','agence-metz@exteco.fr','','','Exteco - Nouvelle opportunité - OPP-Hurard','\r\n\r\nNouvelle opportunite\r\n\r\n\r\n\r\n\r\n \r\n \r\n \r\n
\r\n\r\n
\r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n\r\n
\r\n\r\n

\r\n Nouvelle opportunité - OPP-Hurard

\r\n\r\n

\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é)

\r\n Une nouvelle opportunité vous a été affectée, vous pouvez aller la consulter avec le bouton ci-dessous.

\r\n Cordialement,


\r\n\r\n \r\n \r\n \r\n \r\n \r\n
\r\n \r\n \r\n \r\n \r\n
\r\n Consulter l\'opportunité\r\n
\r\n
\r\n
\r\n \r\n
\r\n
\r\n \r\n\r\n
\r\n
','','0','v2017b' ) UID:--082434-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '146') LIMIT 1 UID:--082434-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Hurard',`att2`='3021',`attf100`='20250505',`att8`='1523',`att6`='4',`att9`='3022',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505050824',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '243') AND (id_type = '148') LIMIT 1 UID:--082434-- UPDATE `tier_lig` SET `lig2`='268',`ligdatmod`='202505050824',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '6') LIMIT 1 UID:--082434-- UPDATE `tier_att` SET `id_work`='367',`att2`='Hurard',`att3`='Marie caroline',`att5`='0788457255',`att6`='mariecaro_6@hotmail.com',`att8`='3021',`att10`='[IDMYUSER]',`att4`='0788457255',`attdatmod`='202505050824',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3022') AND (id_type = '149') LIMIT 1 UID:--082434-- UPDATE `tier_att` SET `id_work`='259',`att3`='Marie caroline',`att1`='Hurard',`att8`='non_défini',`att12`='mariecaro_6@hotmail.com',`att21`='4',`att14`='7 chemin sous les vignes',`att7`='57645',`att17`='Ogy-montoy-flanville',`att18`='France',`att5`='0788457255',`attf102`='20250505',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250505',`att24`='3',`att19`='49.12244',`att20`='6.29471',`att22`='CL-METZ-268',`attf100`='1',`attdatmod`='202505050824',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3021') AND (id_type = '80') LIMIT 1 UID:--082434-- UPDATE `tier_att` SET `id_work`='259',`att3`='Marie caroline',`att1`='Hurard',`att8`='non_défini',`att12`='mariecaro_6@hotmail.com',`att21`='4',`att14`='7 chemin sous les vignes',`att7`='57645',`att17`='Ogy-montoy-flanville',`att18`='France',`att5`='0788457255',`attf102`='20250505',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250505',`att24`='3',`att19`='49.12244',`att20`='6.29471',`att22`='CL-EPI-2588',`attf100`='1',`attdatmod`='202505050824',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3021') AND (id_type = '80') LIMIT 1 UID:--082434-- UPDATE `tier_att` SET `id_work`='259',`att3`='Marie caroline',`att1`='Hurard',`att8`='non_défini',`att12`='mariecaro_6@hotmail.com',`att21`='4',`att14`='7 chemin sous les vignes',`att7`='57645',`att17`='Ogy-montoy-flanville',`att18`='France',`att5`='0788457255',`attf102`='20250505',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250505',`att24`='3',`att19`='49.12244',`att20`='6.29471',`att22`='CL-EPI-2588',`attf100`='1',`attdatmod`='202505050824',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3021') AND (id_type = '80') LIMIT 1 UID:--082434-- UPDATE `tier_att` SET `id_work`='259',`att3`='Marie caroline',`att1`='Hurard',`att8`='non_défini',`att12`='mariecaro_6@hotmail.com',`att21`='4',`att14`='7 chemin sous les vignes',`att7`='57645',`att17`='Ogy-montoy-flanville',`att18`='France',`att5`='0788457255',`attf102`='20250505',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250505',`att24`='3',`att19`='49.12244',`att20`='6.29471',`att22`='CL-EPI-2588',`attf100`='1',`att6`='0788457255',`attdatmod`='202505050824',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3021') AND (id_type = '80') LIMIT 1 UID:--082434-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Hurard',`att2`='3021',`attf100`='20250505',`att8`='1523',`att6`='4',`att9`='3022',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505050824',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '243') AND (id_type = '148') LIMIT 1 UID:--083039--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:--083039--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--083408--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:--083408--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--085816--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:--085816--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:9--090218--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--090218--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:9--092508--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--092508--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:9--092520--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--092520--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--094612--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:--094612--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--095458--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:--095458--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--101548--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:--101548--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--101958--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:--101958--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--102349--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:--102349--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--103858--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:--103858--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--103930--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--103930--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--103943--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:--103943--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--104622--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:--104622--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:9--104650--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--104650--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--105431--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:--105431--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--110622--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:--110622--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--110652--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:--110652--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:6--111406--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:6--111406--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--111431--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:--111431--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--111447--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:--111447--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:6--111535--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:6--111535--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--112117-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505051121' ) UID:--112117-- UPDATE `tier_att` SET `id_work`='259',`att3`='Maxime',`att1`='ANDRES',`att8`='non_défini',`att12`='maxandres@outlook.com',`att21`='4',`att14`='21 Rue Du Rebenot',`att7`='57160',`att17`='Châtel-Saint-Germain',`att18`='France',`att5`='0788038402',`attf102`='20250505',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250505',`att24`='3',`attdatmod`='202505051121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3026') AND (id_type = '80') LIMIT 1 UID:--112117-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3026','202505051121','202505051121' ) UID:--112117-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='21 Rue Du Rebenot',`lig4`='57160',`lig5`='Châtel-Saint-Germain',`lig6`='France',`ligdatmod`='202505051121',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3026') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1526') LIMIT 1 UID:--112117-- UPDATE `tier_lig` SET `lig2`='269',`ligdatmod`='202505051121',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '6') LIMIT 1 UID:--112117-- UPDATE `tier_att` SET `id_work`='259',`att3`='Maxime',`att1`='ANDRES',`att8`='non_défini',`att12`='maxandres@outlook.com',`att21`='4',`att14`='21 Rue Du Rebenot',`att7`='57160',`att17`='Châtel-Saint-Germain',`att18`='France',`att5`='0788038402',`attf102`='20250505',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250505',`att24`='3',`att19`='49.114853',`att20`='6.082925',`att22`='CL-METZ-269',`attf100`='1',`attdatmod`='202505051121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3026') AND (id_type = '80') LIMIT 1 UID:--112117-- UPDATE `tier_att` SET `id_work`='259',`att3`='Maxime',`att1`='ANDRES',`att8`='non_défini',`att12`='maxandres@outlook.com',`att21`='4',`att14`='21 Rue Du Rebenot',`att7`='57160',`att17`='Châtel-Saint-Germain',`att18`='France',`att5`='0788038402',`attf102`='20250505',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250505',`att24`='3',`att19`='49.114853',`att20`='6.082925',`att22`='-1',`attf100`='1',`attdatmod`='202505051121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3026') AND (id_type = '80') LIMIT 1 UID:--112117-- UPDATE `tier_att` SET `id_work`='259',`att3`='Maxime',`att1`='ANDRES',`att8`='non_défini',`att12`='maxandres@outlook.com',`att21`='4',`att14`='21 Rue Du Rebenot',`att7`='57160',`att17`='Châtel-Saint-Germain',`att18`='France',`att5`='0788038402',`attf102`='20250505',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250505',`att24`='3',`att19`='49.114853',`att20`='6.082925',`att22`='-1',`attf100`='1',`attdatmod`='202505051121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3026') AND (id_type = '80') LIMIT 1 UID:--112117-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505051121' ) UID:--112117-- UPDATE `tier_att` SET `id_work`='367',`att2`='ANDRES',`att3`='Maxime',`att5`='0788038402',`att6`='maxandres@outlook.com',`att8`='3026',`att10`='[IDMYUSER]',`attdatmod`='202505051121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3027') AND (id_type = '149') LIMIT 1 UID:--112117-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505051121' ) UID:--112117-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-',`att2`='3026',`attf100`='20250505',`att8`='1526',`att6`='[IDMYUSER]',`att9`='3027',`att3`='§autres§',`attdatmod`='202505051121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '248') AND (id_type = '148') LIMIT 1 UID:--112117-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-ANDRES',`att2`='3026',`attf100`='20250505',`att8`='1526',`att6`='[IDMYUSER]',`att9`='3027',`att3`='§autres§',`attdatmod`='202505051121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '248') AND (id_type = '148') LIMIT 1 UID:--112117-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-ANDRES',`att2`='3026',`attf100`='20250505',`att8`='1526',`att6`='[IDMYUSER]',`att9`='3027',`att3`='§autres§',`att5`='',`att10`='non_défini',`attdatmod`='202505051121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '248') AND (id_type = '148') LIMIT 1 UID:--112117-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-ANDRES',`att2`='3026',`attf100`='20250505',`att8`='1526',`att6`='0',`att9`='3027',`att3`='§autres§',`att5`='',`att10`='non_défini',`attdatmod`='202505051121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '248') AND (id_type = '148') LIMIT 1 UID:--112117-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250505','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-ANDRES','\r\n\r\nNouvelle opportunite\r\n\r\n\r\n\r\n\r\n \r\n \r\n \r\n
\r\n\r\n
\r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n\r\n
\r\n\r\n

\r\n Nouvelle opportunité - OPP-ANDRES

\r\n\r\n

\r\n Bonjour Exteco, (Mail envoyé au franchiseur lors d\'une création de nouvelle opportunité depuis l\'api lead)

\r\n Une nouvelle opportunité a été enregistrée, vous pouvez aller la consulter avec le bouton ci-dessous.

\r\n Cordialement,


\r\n\r\n \r\n \r\n \r\n \r\n \r\n
\r\n \r\n \r\n \r\n \r\n
\r\n Consulter l\'opportunité\r\n
\r\n
\r\n
\r\n \r\n
\r\n
\r\n \r\n\r\n
\r\n
','','0','v2017b' ) UID:--112117-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '148') LIMIT 1 UID:--112117--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:--112117-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250505','','1','','Exteco','agence-metz@exteco.fr','','','Exteco - Nouvelle opportunité - OPP-ANDRES','\r\n\r\nNouvelle opportunite\r\n\r\n\r\n\r\n\r\n \r\n \r\n \r\n
\r\n\r\n
\r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n\r\n
\r\n\r\n

\r\n Nouvelle opportunité - OPP-ANDRES

\r\n\r\n

\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é)

\r\n Une nouvelle opportunité vous a été affectée, vous pouvez aller la consulter avec le bouton ci-dessous.

\r\n Cordialement,


\r\n\r\n \r\n \r\n \r\n \r\n \r\n
\r\n \r\n \r\n \r\n \r\n
\r\n Consulter l\'opportunité\r\n
\r\n
\r\n
\r\n \r\n
\r\n
\r\n \r\n\r\n
\r\n
','','0','v2017b' ) UID:--112117-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '149') LIMIT 1 UID:--112117-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-ANDRES',`att2`='3026',`attf100`='20250505',`att8`='1526',`att6`='4',`att9`='3027',`att3`='§autres§',`att5`='',`att10`='non_défini',`attdatmod`='202505051121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '248') AND (id_type = '148') LIMIT 1 UID:--112117-- UPDATE `tier_lig` SET `lig2`='270',`ligdatmod`='202505051121',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '6') LIMIT 1 UID:--112117-- UPDATE `tier_att` SET `id_work`='367',`att2`='ANDRES',`att3`='Maxime',`att5`='0788038402',`att6`='maxandres@outlook.com',`att8`='3026',`att10`='[IDMYUSER]',`att4`='0788038402',`attdatmod`='202505051121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3027') AND (id_type = '149') LIMIT 1 UID:--112117-- UPDATE `tier_att` SET `id_work`='259',`att3`='Maxime',`att1`='ANDRES',`att8`='non_défini',`att12`='maxandres@outlook.com',`att21`='4',`att14`='21 Rue Du Rebenot',`att7`='57160',`att17`='Châtel-Saint-Germain',`att18`='France',`att5`='0788038402',`attf102`='20250505',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250505',`att24`='3',`att19`='49.114853',`att20`='6.082925',`att22`='CL-METZ-270',`attf100`='1',`attdatmod`='202505051121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3026') AND (id_type = '80') LIMIT 1 UID:--112117-- UPDATE `tier_att` SET `id_work`='259',`att3`='Maxime',`att1`='ANDRES',`att8`='non_défini',`att12`='maxandres@outlook.com',`att21`='4',`att14`='21 Rue Du Rebenot',`att7`='57160',`att17`='Châtel-Saint-Germain',`att18`='France',`att5`='0788038402',`attf102`='20250505',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250505',`att24`='3',`att19`='49.114853',`att20`='6.082925',`att22`='CL-EPI-2591',`attf100`='1',`attdatmod`='202505051121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3026') AND (id_type = '80') LIMIT 1 UID:--112117-- UPDATE `tier_att` SET `id_work`='259',`att3`='Maxime',`att1`='ANDRES',`att8`='non_défini',`att12`='maxandres@outlook.com',`att21`='4',`att14`='21 Rue Du Rebenot',`att7`='57160',`att17`='Châtel-Saint-Germain',`att18`='France',`att5`='0788038402',`attf102`='20250505',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250505',`att24`='3',`att19`='49.114853',`att20`='6.082925',`att22`='CL-EPI-2591',`attf100`='1',`attdatmod`='202505051121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3026') AND (id_type = '80') LIMIT 1 UID:--112117-- UPDATE `tier_att` SET `id_work`='259',`att3`='Maxime',`att1`='ANDRES',`att8`='non_défini',`att12`='maxandres@outlook.com',`att21`='4',`att14`='21 Rue Du Rebenot',`att7`='57160',`att17`='Châtel-Saint-Germain',`att18`='France',`att5`='0788038402',`attf102`='20250505',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250505',`att24`='3',`att19`='49.114853',`att20`='6.082925',`att22`='CL-EPI-2591',`attf100`='1',`att6`='0788038402',`attdatmod`='202505051121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3026') AND (id_type = '80') LIMIT 1 UID:--112117-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-ANDRES',`att2`='3026',`attf100`='20250505',`att8`='1526',`att6`='4',`att9`='3027',`att3`='§autres§',`att5`='',`att10`='non_défini',`attdatmod`='202505051121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '248') AND (id_type = '148') LIMIT 1 UID:1--112211--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--112211--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--112239--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:--112239--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:4--112333--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:4--112333--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--112343--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:--112343--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--112431--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:--112431--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--112831--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:--112831--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:2--112837--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm WHERE pm.id_base=1 AND pm.id_base=pdm.id_base AND pm.id_menu=pdm.id_menu AND pdm.droit>0 AND pdm.id_role IN (89) ORDER BY pm.ordre UID:2--112837--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--112848--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:--112848--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:3--113014--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--113014--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--113922--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:--113922--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--114950--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:--114950--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:4--115010--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:4--115010--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--120334--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:--120334--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--120459--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:--120459--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--120509--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:--120509--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:4--120932--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:4--120932--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--121009--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--121009--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--122808--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:--122808--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--124651-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505051246' ) UID:--124651-- UPDATE `tier_att` SET `id_work`='259',`att3`='Aurelien',`att1`='Merland',`att8`='non_défini',`att12`='amerland@hotmail.fr',`att21`='4',`att14`='5 rue des fleurs',`att7`='57925',`att17`='Distroff',`att18`='France',`att5`='0786091185',`attf102`='20250505',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250505',`att24`='3',`attdatmod`='202505051246',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3037') AND (id_type = '80') LIMIT 1 UID:--124651-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3037','202505051246','202505051246' ) UID:--124651-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='5 rue des fleurs',`lig4`='57925',`lig5`='Distroff',`lig6`='France',`ligdatmod`='202505051246',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3037') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1531') LIMIT 1 UID:--124651-- UPDATE `tier_lig` SET `lig2`='274',`ligdatmod`='202505051246',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '6') LIMIT 1 UID:--124651-- UPDATE `tier_att` SET `id_work`='259',`att3`='Aurelien',`att1`='Merland',`att8`='non_défini',`att12`='amerland@hotmail.fr',`att21`='4',`att14`='5 rue des fleurs',`att7`='57925',`att17`='Distroff',`att18`='France',`att5`='0786091185',`attf102`='20250505',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250505',`att24`='3',`att19`='49.330802',`att20`='6.25953',`att22`='CL-METZ-274',`attf100`='1',`attdatmod`='202505051246',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3037') AND (id_type = '80') LIMIT 1 UID:--124651-- UPDATE `tier_att` SET `id_work`='259',`att3`='Aurelien',`att1`='Merland',`att8`='non_défini',`att12`='amerland@hotmail.fr',`att21`='4',`att14`='5 rue des fleurs',`att7`='57925',`att17`='Distroff',`att18`='France',`att5`='0786091185',`attf102`='20250505',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250505',`att24`='3',`att19`='49.330802',`att20`='6.25953',`att22`='-1',`attf100`='1',`attdatmod`='202505051246',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3037') AND (id_type = '80') LIMIT 1 UID:--124651-- UPDATE `tier_att` SET `id_work`='259',`att3`='Aurelien',`att1`='Merland',`att8`='non_défini',`att12`='amerland@hotmail.fr',`att21`='4',`att14`='5 rue des fleurs',`att7`='57925',`att17`='Distroff',`att18`='France',`att5`='0786091185',`attf102`='20250505',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250505',`att24`='3',`att19`='49.330802',`att20`='6.25953',`att22`='-1',`attf100`='1',`attdatmod`='202505051246',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3037') AND (id_type = '80') LIMIT 1 UID:--124651-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505051246' ) UID:--124651-- UPDATE `tier_att` SET `id_work`='367',`att2`='Merland',`att3`='Aurelien',`att5`='0786091185',`att6`='amerland@hotmail.fr',`att8`='3037',`att10`='[IDMYUSER]',`attdatmod`='202505051246',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3038') AND (id_type = '149') LIMIT 1 UID:--124651-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505051246' ) UID:--124651-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-',`att2`='3037',`attf100`='20250505',`att8`='1531',`att6`='[IDMYUSER]',`att9`='3038',`att3`='§façade§',`attdatmod`='202505051246',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '256') AND (id_type = '148') LIMIT 1 UID:--124651-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Merland',`att2`='3037',`attf100`='20250505',`att8`='1531',`att6`='[IDMYUSER]',`att9`='3038',`att3`='§façade§',`attdatmod`='202505051246',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '256') AND (id_type = '148') LIMIT 1 UID:--124651-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Merland',`att2`='3037',`attf100`='20250505',`att8`='1531',`att6`='[IDMYUSER]',`att9`='3038',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505051246',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '256') AND (id_type = '148') LIMIT 1 UID:--124651-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Merland',`att2`='3037',`attf100`='20250505',`att8`='1531',`att6`='0',`att9`='3038',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505051246',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '256') AND (id_type = '148') LIMIT 1 UID:--124651-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250505','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Merland','\r\n\r\nNouvelle opportunite\r\n\r\n\r\n\r\n\r\n \r\n \r\n \r\n
\r\n\r\n
\r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n\r\n
\r\n\r\n

\r\n Nouvelle opportunité - OPP-Merland

\r\n\r\n

\r\n Bonjour Exteco, (Mail envoyé au franchiseur lors d\'une création de nouvelle opportunité depuis l\'api lead)

\r\n Une nouvelle opportunité a été enregistrée, vous pouvez aller la consulter avec le bouton ci-dessous.

\r\n Cordialement,


\r\n\r\n \r\n \r\n \r\n \r\n \r\n
\r\n \r\n \r\n \r\n \r\n
\r\n Consulter l\'opportunité\r\n
\r\n
\r\n
\r\n \r\n
\r\n
\r\n \r\n\r\n
\r\n
','','0','v2017b' ) UID:--124651-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '155') LIMIT 1 UID:--124651--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:--124651-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250505','','1','','Exteco','agence-metz@exteco.fr','','','Exteco - Nouvelle opportunité - OPP-Merland','\r\n\r\nNouvelle opportunite\r\n\r\n\r\n\r\n\r\n \r\n \r\n \r\n
\r\n\r\n
\r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n\r\n
\r\n\r\n

\r\n Nouvelle opportunité - OPP-Merland

\r\n\r\n

\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é)

\r\n Une nouvelle opportunité vous a été affectée, vous pouvez aller la consulter avec le bouton ci-dessous.

\r\n Cordialement,


\r\n\r\n \r\n \r\n \r\n \r\n \r\n
\r\n \r\n \r\n \r\n \r\n
\r\n Consulter l\'opportunité\r\n
\r\n
\r\n
\r\n \r\n
\r\n
\r\n \r\n\r\n
\r\n
','','0','v2017b' ) UID:--124651-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '156') LIMIT 1 UID:--124651-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Merland',`att2`='3037',`attf100`='20250505',`att8`='1531',`att6`='4',`att9`='3038',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505051246',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '256') AND (id_type = '148') LIMIT 1 UID:--124651-- UPDATE `tier_lig` SET `lig2`='275',`ligdatmod`='202505051246',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '6') LIMIT 1 UID:--124651-- UPDATE `tier_att` SET `id_work`='367',`att2`='Merland',`att3`='Aurelien',`att5`='0786091185',`att6`='amerland@hotmail.fr',`att8`='3037',`att10`='[IDMYUSER]',`att4`='0786091185',`attdatmod`='202505051246',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3038') AND (id_type = '149') LIMIT 1 UID:--124651-- UPDATE `tier_att` SET `id_work`='259',`att3`='Aurelien',`att1`='Merland',`att8`='non_défini',`att12`='amerland@hotmail.fr',`att21`='4',`att14`='5 rue des fleurs',`att7`='57925',`att17`='Distroff',`att18`='France',`att5`='0786091185',`attf102`='20250505',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250505',`att24`='3',`att19`='49.330802',`att20`='6.25953',`att22`='CL-METZ-275',`attf100`='1',`attdatmod`='202505051246',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3037') AND (id_type = '80') LIMIT 1 UID:--124651-- UPDATE `tier_att` SET `id_work`='259',`att3`='Aurelien',`att1`='Merland',`att8`='non_défini',`att12`='amerland@hotmail.fr',`att21`='4',`att14`='5 rue des fleurs',`att7`='57925',`att17`='Distroff',`att18`='France',`att5`='0786091185',`attf102`='20250505',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250505',`att24`='3',`att19`='49.330802',`att20`='6.25953',`att22`='CL-EPI-2601',`attf100`='1',`attdatmod`='202505051246',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3037') AND (id_type = '80') LIMIT 1 UID:--124651-- UPDATE `tier_att` SET `id_work`='259',`att3`='Aurelien',`att1`='Merland',`att8`='non_défini',`att12`='amerland@hotmail.fr',`att21`='4',`att14`='5 rue des fleurs',`att7`='57925',`att17`='Distroff',`att18`='France',`att5`='0786091185',`attf102`='20250505',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250505',`att24`='3',`att19`='49.330802',`att20`='6.25953',`att22`='CL-EPI-2601',`attf100`='1',`attdatmod`='202505051246',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3037') AND (id_type = '80') LIMIT 1 UID:--124651-- UPDATE `tier_att` SET `id_work`='259',`att3`='Aurelien',`att1`='Merland',`att8`='non_défini',`att12`='amerland@hotmail.fr',`att21`='4',`att14`='5 rue des fleurs',`att7`='57925',`att17`='Distroff',`att18`='France',`att5`='0786091185',`attf102`='20250505',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250505',`att24`='3',`att19`='49.330802',`att20`='6.25953',`att22`='CL-EPI-2601',`attf100`='1',`att6`='0786091185',`attdatmod`='202505051246',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3037') AND (id_type = '80') LIMIT 1 UID:--124651-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Merland',`att2`='3037',`attf100`='20250505',`att8`='1531',`att6`='4',`att9`='3038',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505051246',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '256') AND (id_type = '148') LIMIT 1 UID:--125847--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:--125847--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--134605--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:--134605--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:10--135100--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm WHERE pm.id_base=1 AND pm.id_base=pdm.id_base AND pm.id_menu=pdm.id_menu AND pdm.droit>0 AND pdm.id_role IN (89) ORDER BY pm.ordre UID:10--135100--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--142922--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:--142922--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--143144--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:--143144--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--143737--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--143737--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--152206--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:--152206--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:9--154254--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--154254--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:9--154532--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--154532--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--154853--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:--154853--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--154913--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:--154913--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--154949--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:--154949--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--154958--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:--154958--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--155019--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:--155019--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--155424--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:--155424--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:2--155648--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm WHERE pm.id_base=1 AND pm.id_base=pdm.id_base AND pm.id_menu=pdm.id_menu AND pdm.droit>0 AND pdm.id_role IN (89) ORDER BY pm.ordre UID:2--155648--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:9--155923--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--155923--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:9--160340--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--160340--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--161924--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:--161924--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--164708--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--164708--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--164903--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--164903--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--172807--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--172807--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--175326--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:--175326--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--181313--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:--181313--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--192413--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:--192413--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--223219--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:--223219--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre