UID:--075329-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505130753' ) UID:--075329-- UPDATE `tier_att` SET `id_work`='259',`att3`='Marc',`att1`='Lavigne',`att8`='non_défini',`att12`='marc.lavigne@numericable.fr',`att14`='91 rue de l'égalité',`att7`='59640',`att17`='Dunkerque',`att18`='France',`att5`='0671415062',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250513',`attdatmod`='202505130753',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3113') AND (id_type = '80') LIMIT 1 UID:--075329-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3113','202505130753','202505130753' ) UID:--075329-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='91 rue de l'égalité',`lig4`='59640',`lig5`='Dunkerque',`lig6`='France',`ligdatmod`='202505130753',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3113') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1568') LIMIT 1 UID:--075329-- UPDATE `tier_att` SET `id_work`='259',`att3`='Marc',`att1`='Lavigne',`att8`='non_défini',`att12`='marc.lavigne@numericable.fr',`att14`='91 rue de l'égalité',`att7`='59640',`att17`='Dunkerque',`att18`='France',`att5`='0671415062',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250513',`att19`='51.015001',`att20`='2.325463',`attf100`='1',`attdatmod`='202505130753',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3113') AND (id_type = '80') LIMIT 1 UID:--075329-- UPDATE `tier_att` SET `id_work`='259',`att3`='Marc',`att1`='Lavigne',`att8`='non_défini',`att12`='marc.lavigne@numericable.fr',`att14`='91 rue de l'égalité',`att7`='59640',`att17`='Dunkerque',`att18`='France',`att5`='0671415062',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250513',`att19`='51.015001',`att20`='2.325463',`attf100`='1',`attdatmod`='202505130753',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3113') AND (id_type = '80') LIMIT 1 UID:--075329-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505130753' ) UID:--075329-- UPDATE `tier_att` SET `id_work`='367',`att2`='Lavigne',`att3`='Marc',`att5`='0671415062',`att6`='marc.lavigne@numericable.fr',`att8`='3113',`att10`='[IDMYUSER]',`attdatmod`='202505130753',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3114') AND (id_type = '149') LIMIT 1 UID:--075329-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505130753' ) UID:--075329-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-',`att2`='3113',`attf100`='20250513',`att8`='1568',`att6`='[IDMYUSER]',`att9`='3114',`att3`='§toiture§',`attdatmod`='202505130753',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '359') AND (id_type = '148') LIMIT 1 UID:--075329-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Lavigne',`att2`='3113',`attf100`='20250513',`att8`='1568',`att6`='[IDMYUSER]',`att9`='3114',`att3`='§toiture§',`attdatmod`='202505130753',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '359') AND (id_type = '148') LIMIT 1 UID:--075329-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Lavigne',`att2`='3113',`attf100`='20250513',`att8`='1568',`att6`='[IDMYUSER]',`att9`='3114',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505130753',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '359') AND (id_type = '148') LIMIT 1 UID:--075329-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Lavigne',`att2`='3113',`attf100`='20250513',`att8`='1568',`att6`='0',`att9`='3114',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505130753',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '359') AND (id_type = '148') LIMIT 1 UID:--075329-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250513','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Lavigne','\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-Lavigne

\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:--075329-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '239') LIMIT 1 UID:--075329--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:--075329-- UPDATE `tier_att` SET `id_work`='367',`att2`='Lavigne',`att3`='Marc',`att5`='0671415062',`att6`='marc.lavigne@numericable.fr',`att8`='3113',`att10`='[IDMYUSER]',`att4`='0671415062',`attdatmod`='202505130753',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3114') AND (id_type = '149') LIMIT 1 UID:--075329-- UPDATE `tier_att` SET `id_work`='259',`att3`='Marc',`att1`='Lavigne',`att8`='non_défini',`att12`='marc.lavigne@numericable.fr',`att14`='91 rue de l'égalité',`att7`='59640',`att17`='Dunkerque',`att18`='France',`att5`='0671415062',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250513',`att19`='51.015001',`att20`='2.325463',`attf100`='1',`attdatmod`='202505130753',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3113') AND (id_type = '80') LIMIT 1 UID:--075329-- UPDATE `tier_att` SET `id_work`='259',`att3`='Marc',`att1`='Lavigne',`att8`='non_défini',`att12`='marc.lavigne@numericable.fr',`att14`='91 rue de l'égalité',`att7`='59640',`att17`='Dunkerque',`att18`='France',`att5`='0671415062',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250513',`att19`='51.015001',`att20`='2.325463',`attf100`='1',`attdatmod`='202505130753',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3113') AND (id_type = '80') LIMIT 1 UID:--075329-- UPDATE `tier_att` SET `id_work`='259',`att3`='Marc',`att1`='Lavigne',`att8`='non_défini',`att12`='marc.lavigne@numericable.fr',`att14`='91 rue de l'égalité',`att7`='59640',`att17`='Dunkerque',`att18`='France',`att5`='0671415062',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250513',`att19`='51.015001',`att20`='2.325463',`attf100`='1',`att6`='0671415062',`attdatmod`='202505130753',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3113') AND (id_type = '80') LIMIT 1 UID:--075329-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Lavigne',`att2`='3113',`attf100`='20250513',`att8`='1568',`att6`='0',`att9`='3114',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505130753',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '359') AND (id_type = '148') LIMIT 1 UID:--083857--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:--083857--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:9--084458--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--084458--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--085105--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:--085105--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--094723--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:--094723--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--095121-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505130951' ) UID:--095121-- UPDATE `tier_att` SET `id_work`='259',`att3`='Patrick',`att1`='Jacquot',`att8`='non_défini',`att12`='patkine@yahoo.fr',`att14`='rue Jacques Callot',`att7`='54550',`att17`='Bainville sur madon',`att18`='France',`att5`='0665557611',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250513',`attdatmod`='202505130951',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3115') AND (id_type = '80') LIMIT 1 UID:--095121-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3115','202505130951','202505130951' ) UID:--095121-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='rue Jacques Callot',`lig4`='54550',`lig5`='Bainville sur madon',`lig6`='France',`ligdatmod`='202505130951',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3115') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1569') LIMIT 1 UID:--095122-- UPDATE `tier_att` SET `id_work`='259',`att3`='Patrick',`att1`='Jacquot',`att8`='non_défini',`att12`='patkine@yahoo.fr',`att14`='rue Jacques Callot',`att7`='54550',`att17`='Bainville sur madon',`att18`='France',`att5`='0665557611',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250513',`att19`='48.586875',`att20`='6.093258',`attf100`='1',`attdatmod`='202505130951',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3115') AND (id_type = '80') LIMIT 1 UID:--095122-- UPDATE `tier_att` SET `id_work`='259',`att3`='Patrick',`att1`='Jacquot',`att8`='non_défini',`att12`='patkine@yahoo.fr',`att14`='rue Jacques Callot',`att7`='54550',`att17`='Bainville sur madon',`att18`='France',`att5`='0665557611',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250513',`att19`='48.586875',`att20`='6.093258',`attf100`='1',`attdatmod`='202505130951',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3115') AND (id_type = '80') LIMIT 1 UID:--095122-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505130951' ) UID:--095122-- UPDATE `tier_att` SET `id_work`='367',`att2`='Jacquot',`att3`='Patrick',`att5`='0665557611',`att6`='patkine@yahoo.fr',`att8`='3115',`att10`='[IDMYUSER]',`attdatmod`='202505130951',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3116') AND (id_type = '149') LIMIT 1 UID:--095122-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505130951' ) UID:--095122-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-',`att2`='3115',`attf100`='20250513',`att8`='1569',`att6`='[IDMYUSER]',`att9`='3116',`att3`='§toiture§',`attdatmod`='202505130951',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '360') AND (id_type = '148') LIMIT 1 UID:--095122-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Jacquot',`att2`='3115',`attf100`='20250513',`att8`='1569',`att6`='[IDMYUSER]',`att9`='3116',`att3`='§toiture§',`attdatmod`='202505130951',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '360') AND (id_type = '148') LIMIT 1 UID:--095122-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Jacquot',`att2`='3115',`attf100`='20250513',`att8`='1569',`att6`='[IDMYUSER]',`att9`='3116',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505130951',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '360') AND (id_type = '148') LIMIT 1 UID:--095122-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Jacquot',`att2`='3115',`attf100`='20250513',`att8`='1569',`att6`='0',`att9`='3116',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505130951',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '360') AND (id_type = '148') LIMIT 1 UID:--095122-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250513','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Jacquot','\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-Jacquot

\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:--095122-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '240') LIMIT 1 UID:--095122--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:--095122-- UPDATE `tier_att` SET `id_work`='367',`att2`='Jacquot',`att3`='Patrick',`att5`='0665557611',`att6`='patkine@yahoo.fr',`att8`='3115',`att10`='[IDMYUSER]',`att4`='0665557611',`attdatmod`='202505130951',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3116') AND (id_type = '149') LIMIT 1 UID:--095122-- UPDATE `tier_att` SET `id_work`='259',`att3`='Patrick',`att1`='Jacquot',`att8`='non_défini',`att12`='patkine@yahoo.fr',`att14`='rue Jacques Callot',`att7`='54550',`att17`='Bainville sur madon',`att18`='France',`att5`='0665557611',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250513',`att19`='48.586875',`att20`='6.093258',`attf100`='1',`attdatmod`='202505130951',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3115') AND (id_type = '80') LIMIT 1 UID:--095122-- UPDATE `tier_att` SET `id_work`='259',`att3`='Patrick',`att1`='Jacquot',`att8`='non_défini',`att12`='patkine@yahoo.fr',`att14`='rue Jacques Callot',`att7`='54550',`att17`='Bainville sur madon',`att18`='France',`att5`='0665557611',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250513',`att19`='48.586875',`att20`='6.093258',`attf100`='1',`attdatmod`='202505130951',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3115') AND (id_type = '80') LIMIT 1 UID:--095122-- UPDATE `tier_att` SET `id_work`='259',`att3`='Patrick',`att1`='Jacquot',`att8`='non_défini',`att12`='patkine@yahoo.fr',`att14`='rue Jacques Callot',`att7`='54550',`att17`='Bainville sur madon',`att18`='France',`att5`='0665557611',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250513',`att19`='48.586875',`att20`='6.093258',`attf100`='1',`att6`='0665557611',`attdatmod`='202505130951',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3115') AND (id_type = '80') LIMIT 1 UID:--095122-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Jacquot',`att2`='3115',`attf100`='20250513',`att8`='1569',`att6`='0',`att9`='3116',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505130951',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '360') AND (id_type = '148') LIMIT 1 UID:--095658--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:--095658--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:2--100653--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--100653--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--100848--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:--100848--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--101936--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:--101936--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--102615--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:--102615--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--102656--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:--102656--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--104537--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:--104537--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--104602--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:--104602--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--105655--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:--105655--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--111859--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:--111859--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--112133--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--112133--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--112140--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--112140--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--112154-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505131121' ) UID:--112154-- UPDATE `tier_att` SET `id_work`='259',`att3`='TEST COMMENTAIRE',`att1`='TOOSMART',`att8`='non_défini',`att12`='testcommentaire@toosmart.fr',`att14`='33 Rue Paul Duvivier',`att7`='69003',`att17`='Lyon',`att18`='France',`att5`='0748868107',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250513',`attdatmod`='202505131121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3119') AND (id_type = '80') LIMIT 1 UID:--112154-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3119','202505131121','202505131121' ) UID:--112154-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='33 Rue Paul Duvivier',`lig4`='69003',`lig5`='Lyon',`lig6`='France',`ligdatmod`='202505131121',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3119') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1571') LIMIT 1 UID:--112154-- UPDATE `tier_att` SET `id_work`='259',`att3`='TEST COMMENTAIRE',`att1`='TOOSMART',`att8`='non_défini',`att12`='testcommentaire@toosmart.fr',`att14`='33 Rue Paul Duvivier',`att7`='69003',`att17`='Lyon',`att18`='France',`att5`='0748868107',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250513',`att19`='45.75251',`att20`='4.856402',`attf100`='1',`attdatmod`='202505131121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3119') AND (id_type = '80') LIMIT 1 UID:--112154-- UPDATE `tier_att` SET `id_work`='259',`att3`='TEST COMMENTAIRE',`att1`='TOOSMART',`att8`='non_défini',`att12`='testcommentaire@toosmart.fr',`att14`='33 Rue Paul Duvivier',`att7`='69003',`att17`='Lyon',`att18`='France',`att5`='0748868107',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250513',`att19`='45.75251',`att20`='4.856402',`attf100`='1',`attdatmod`='202505131121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3119') AND (id_type = '80') LIMIT 1 UID:--112154-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505131121' ) UID:--112154-- UPDATE `tier_att` SET `id_work`='367',`att2`='TOOSMART',`att3`='TEST COMMENTAIRE',`att5`='0748868107',`att6`='testcommentaire@toosmart.fr',`att8`='3119',`att10`='[IDMYUSER]',`attdatmod`='202505131121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3120') AND (id_type = '149') LIMIT 1 UID:--112154-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505131121' ) UID:--112154-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-',`att2`='3119',`att90`='TEST COMMENTAIRE API LEAD',`attf100`='20250513',`att8`='1571',`att6`='[IDMYUSER]',`att9`='3120',`att3`='§autres§',`attdatmod`='202505131121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '363') AND (id_type = '148') LIMIT 1 UID:--112154-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-TOOSMART',`att2`='3119',`att90`='TEST COMMENTAIRE API LEAD',`attf100`='20250513',`att8`='1571',`att6`='[IDMYUSER]',`att9`='3120',`att3`='§autres§',`attdatmod`='202505131121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '363') AND (id_type = '148') LIMIT 1 UID:--112154-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-TOOSMART',`att2`='3119',`att90`='TEST COMMENTAIRE API LEAD',`attf100`='20250513',`att8`='1571',`att6`='[IDMYUSER]',`att9`='3120',`att3`='§autres§',`att5`='',`att10`='non_défini',`attdatmod`='202505131121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '363') AND (id_type = '148') LIMIT 1 UID:--112154-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-TOOSMART',`att2`='3119',`att90`='TEST COMMENTAIRE API LEAD',`attf100`='20250513',`att8`='1571',`att6`='0',`att9`='3120',`att3`='§autres§',`att5`='',`att10`='non_défini',`attdatmod`='202505131121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '363') AND (id_type = '148') LIMIT 1 UID:--112154-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250513','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-TOOSMART','\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-TOOSMART

\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:--112154-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '245') LIMIT 1 UID:--112154--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:--112154-- UPDATE `tier_att` SET `id_work`='367',`att2`='TOOSMART',`att3`='TEST COMMENTAIRE',`att5`='0748868107',`att6`='testcommentaire@toosmart.fr',`att8`='3119',`att10`='[IDMYUSER]',`att4`='0748868107',`attdatmod`='202505131121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3120') AND (id_type = '149') LIMIT 1 UID:--112154-- UPDATE `tier_att` SET `id_work`='259',`att3`='TEST COMMENTAIRE',`att1`='TOOSMART',`att8`='non_défini',`att12`='testcommentaire@toosmart.fr',`att14`='33 Rue Paul Duvivier',`att7`='69003',`att17`='Lyon',`att18`='France',`att5`='0748868107',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250513',`att19`='45.75251',`att20`='4.856402',`attf100`='1',`attdatmod`='202505131121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3119') AND (id_type = '80') LIMIT 1 UID:--112154-- UPDATE `tier_att` SET `id_work`='259',`att3`='TEST COMMENTAIRE',`att1`='TOOSMART',`att8`='non_défini',`att12`='testcommentaire@toosmart.fr',`att14`='33 Rue Paul Duvivier',`att7`='69003',`att17`='Lyon',`att18`='France',`att5`='0748868107',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250513',`att19`='45.75251',`att20`='4.856402',`attf100`='1',`attdatmod`='202505131121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3119') AND (id_type = '80') LIMIT 1 UID:--112154-- UPDATE `tier_att` SET `id_work`='259',`att3`='TEST COMMENTAIRE',`att1`='TOOSMART',`att8`='non_défini',`att12`='testcommentaire@toosmart.fr',`att14`='33 Rue Paul Duvivier',`att7`='69003',`att17`='Lyon',`att18`='France',`att5`='0748868107',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250513',`att19`='45.75251',`att20`='4.856402',`attf100`='1',`att6`='0748868107',`attdatmod`='202505131121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3119') AND (id_type = '80') LIMIT 1 UID:--112154-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-TOOSMART',`att2`='3119',`att90`='TEST COMMENTAIRE API LEAD',`attf100`='20250513',`att8`='1571',`att6`='0',`att9`='3120',`att3`='§autres§',`att5`='',`att10`='non_défini',`attdatmod`='202505131121',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '363') AND (id_type = '148') LIMIT 1 UID:--114207--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:--114207--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--115926--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:--115926--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:2--121212--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('200','1','2','IMG_2293.jpg','20250513','43','2','-3','-2') UID:2--121212--UPDATE `file` SET `last`='1' , `size`='2702669' , `fol_id`='2' , `esp_id`='1' WHERE file_id=304 UID:2--121212--UPDATE `file` SET `id_type`='168' , `id_obje`='366' , `specif`='devis_signe' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=304 UID:2--121212--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=304 UID:2--121212--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1 UID:2--121212--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','2','2','304','200','IMG_2293.jpg','1','20250513','12:12:12','upload') UID:2--121223--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('201','1','2','IMG_2294.jpg','20250513','414','2','-3','-2') UID:2--121223--UPDATE `file` SET `last`='1' , `size`='2751957' , `fol_id`='2' , `esp_id`='1' WHERE file_id=305 UID:2--121223--UPDATE `file` SET `id_type`='168' , `id_obje`='366' , `specif`='devis_signe' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=305 UID:2--121223--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=305 UID:2--121223--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1 UID:2--121223--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','2','2','305','201','IMG_2294.jpg','1','20250513','12:12:23','upload') UID:2--121315--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('202','1','2','IMG_2294.jpg','20250513','992','2','-3','-2') UID:2--121315--UPDATE `file` SET `last`='1' , `size`='2751957' , `fol_id`='2' , `esp_id`='1' WHERE file_id=306 UID:2--121315--UPDATE `file` SET `id_type`='168' , `id_obje`='367' , `specif`='attestation_signe' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=306 UID:2--121315--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=306 UID:2--121315--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1 UID:2--121315--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','2','2','306','202','IMG_2294.jpg','1','20250513','12:13:15','upload') UID:2--121344--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('203','1','2','IMG_2294.jpg','20250513','836','2','-3','-2') UID:2--121344--UPDATE `file` SET `last`='1' , `size`='2751957' , `fol_id`='2' , `esp_id`='1' WHERE file_id=307 UID:2--121344--UPDATE `file` SET `id_type`='168' , `id_obje`='368' , `specif`='attestation_signe' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=307 UID:2--121344--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=307 UID:2--121344--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1 UID:2--121344--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','2','2','307','203','IMG_2294.jpg','1','20250513','12:13:44','upload') UID:--135825--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:--135825--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--140001--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:--140001--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--140113--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--140113--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--140941--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:--140941--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--141531--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:--141531--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--141832--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--141832--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--142007-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505131420' ) UID:--142007-- UPDATE `tier_att` SET `id_work`='259',`att3`='Clémence',`att1`='BAZARD',`att8`='non_défini',`att12`='clemence.bazard88@gmail.com',`att14`='13 rue René Schvartz',`att7`='54320',`att17`='Maxéville',`att18`='France',`att5`='0675294139',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250513',`attdatmod`='202505131420',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3121') AND (id_type = '80') LIMIT 1 UID:--142007-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3121','202505131420','202505131420' ) UID:--142007-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='13 rue René Schvartz',`lig4`='54320',`lig5`='Maxéville',`lig6`='France',`ligdatmod`='202505131420',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3121') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1572') LIMIT 1 UID:--142007-- UPDATE `tier_att` SET `id_work`='259',`att3`='Clémence',`att1`='BAZARD',`att8`='non_défini',`att12`='clemence.bazard88@gmail.com',`att14`='13 rue René Schvartz',`att7`='54320',`att17`='Maxéville',`att18`='France',`att5`='0675294139',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250513',`att19`='48.711515',`att20`='6.17092',`attf100`='1',`attdatmod`='202505131420',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3121') AND (id_type = '80') LIMIT 1 UID:--142007-- UPDATE `tier_att` SET `id_work`='259',`att3`='Clémence',`att1`='BAZARD',`att8`='non_défini',`att12`='clemence.bazard88@gmail.com',`att14`='13 rue René Schvartz',`att7`='54320',`att17`='Maxéville',`att18`='France',`att5`='0675294139',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250513',`att19`='48.711515',`att20`='6.17092',`attf100`='1',`attdatmod`='202505131420',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3121') AND (id_type = '80') LIMIT 1 UID:--142007-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505131420' ) UID:--142007-- UPDATE `tier_att` SET `id_work`='367',`att2`='BAZARD',`att3`='Clémence',`att5`='0675294139',`att6`='clemence.bazard88@gmail.com',`att8`='3121',`att10`='[IDMYUSER]',`attdatmod`='202505131420',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3122') AND (id_type = '149') LIMIT 1 UID:--142007-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505131420' ) UID:--142007-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-',`att2`='3121',`att90`='Bonjour, Façade difficile à nettoyer et un aspect mousse qui revient chaque année depuis la rénovation extérieure de la maison et des escaliers de l’entrée.',`attf100`='20250513',`att8`='1572',`att6`='[IDMYUSER]',`att9`='3122',`att3`='§façade§',`attdatmod`='202505131420',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '370') AND (id_type = '148') LIMIT 1 UID:--142007-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-BAZARD',`att2`='3121',`att90`='Bonjour, Façade difficile à nettoyer et un aspect mousse qui revient chaque année depuis la rénovation extérieure de la maison et des escaliers de l’entrée.',`attf100`='20250513',`att8`='1572',`att6`='[IDMYUSER]',`att9`='3122',`att3`='§façade§',`attdatmod`='202505131420',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '370') AND (id_type = '148') LIMIT 1 UID:--142007-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-BAZARD',`att2`='3121',`att90`='Bonjour, Façade difficile à nettoyer et un aspect mousse qui revient chaque année depuis la rénovation extérieure de la maison et des escaliers de l’entrée.',`attf100`='20250513',`att8`='1572',`att6`='[IDMYUSER]',`att9`='3122',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505131420',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '370') AND (id_type = '148') LIMIT 1 UID:--142007-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-BAZARD',`att2`='3121',`att90`='Bonjour, Façade difficile à nettoyer et un aspect mousse qui revient chaque année depuis la rénovation extérieure de la maison et des escaliers de l’entrée.',`attf100`='20250513',`att8`='1572',`att6`='0',`att9`='3122',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505131420',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '370') AND (id_type = '148') LIMIT 1 UID:--142007-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250513','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-BAZARD','\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-BAZARD

\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:--142007-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '246') LIMIT 1 UID:--142007--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:--142008-- UPDATE `tier_att` SET `id_work`='367',`att2`='BAZARD',`att3`='Clémence',`att5`='0675294139',`att6`='clemence.bazard88@gmail.com',`att8`='3121',`att10`='[IDMYUSER]',`att4`='0675294139',`attdatmod`='202505131420',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3122') AND (id_type = '149') LIMIT 1 UID:--142008-- UPDATE `tier_att` SET `id_work`='259',`att3`='Clémence',`att1`='BAZARD',`att8`='non_défini',`att12`='clemence.bazard88@gmail.com',`att14`='13 rue René Schvartz',`att7`='54320',`att17`='Maxéville',`att18`='France',`att5`='0675294139',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250513',`att19`='48.711515',`att20`='6.17092',`attf100`='1',`attdatmod`='202505131420',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3121') AND (id_type = '80') LIMIT 1 UID:--142008-- UPDATE `tier_att` SET `id_work`='259',`att3`='Clémence',`att1`='BAZARD',`att8`='non_défini',`att12`='clemence.bazard88@gmail.com',`att14`='13 rue René Schvartz',`att7`='54320',`att17`='Maxéville',`att18`='France',`att5`='0675294139',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250513',`att19`='48.711515',`att20`='6.17092',`attf100`='1',`attdatmod`='202505131420',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3121') AND (id_type = '80') LIMIT 1 UID:--142008-- UPDATE `tier_att` SET `id_work`='259',`att3`='Clémence',`att1`='BAZARD',`att8`='non_défini',`att12`='clemence.bazard88@gmail.com',`att14`='13 rue René Schvartz',`att7`='54320',`att17`='Maxéville',`att18`='France',`att5`='0675294139',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250513',`att19`='48.711515',`att20`='6.17092',`attf100`='1',`att6`='0675294139',`attdatmod`='202505131420',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3121') AND (id_type = '80') LIMIT 1 UID:--142008-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-BAZARD',`att2`='3121',`att90`='Bonjour, Façade difficile à nettoyer et un aspect mousse qui revient chaque année depuis la rénovation extérieure de la maison et des escaliers de l’entrée.',`attf100`='20250513',`att8`='1572',`att6`='0',`att9`='3122',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505131420',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '370') AND (id_type = '148') LIMIT 1 UID:--143026--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:--143026--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--143519--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:--143519--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--144447--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--144447--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--144457--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:--144457--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--145022--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:--145022--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--145238--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:--145238--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--153312-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505131533' ) UID:--153312-- UPDATE `tier_att` SET `id_work`='259',`att3`='Daniel',`att1`='Lecoanet',`att8`='non_défini',`att12`='lecoanetdaniel@hotmail.fr',`att14`='21 route de Saint Die',`att7`='88600',`att17`='Aydoilles',`att18`='France',`att5`='0625491114',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='google_ads',`attf105`='20250513',`attdatmod`='202505131533',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3123') AND (id_type = '80') LIMIT 1 UID:--153312-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3123','202505131533','202505131533' ) UID:--153312-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='21 route de Saint Die',`lig4`='88600',`lig5`='Aydoilles',`lig6`='France',`ligdatmod`='202505131533',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3123') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1573') LIMIT 1 UID:--153312-- UPDATE `tier_att` SET `id_work`='259',`att3`='Daniel',`att1`='Lecoanet',`att8`='non_défini',`att12`='lecoanetdaniel@hotmail.fr',`att14`='21 route de Saint Die',`att7`='88600',`att17`='Aydoilles',`att18`='France',`att5`='0625491114',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='google_ads',`attf105`='20250513',`att19`='48.21252',`att20`='6.567257',`attf100`='1',`attdatmod`='202505131533',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3123') AND (id_type = '80') LIMIT 1 UID:--153312-- UPDATE `tier_att` SET `id_work`='259',`att3`='Daniel',`att1`='Lecoanet',`att8`='non_défini',`att12`='lecoanetdaniel@hotmail.fr',`att14`='21 route de Saint Die',`att7`='88600',`att17`='Aydoilles',`att18`='France',`att5`='0625491114',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='google_ads',`attf105`='20250513',`att19`='48.21252',`att20`='6.567257',`attf100`='1',`attdatmod`='202505131533',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3123') AND (id_type = '80') LIMIT 1 UID:--153312-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505131533' ) UID:--153312-- UPDATE `tier_att` SET `id_work`='367',`att2`='Lecoanet',`att3`='Daniel',`att5`='0625491114',`att6`='lecoanetdaniel@hotmail.fr',`att8`='3123',`att10`='[IDMYUSER]',`attdatmod`='202505131533',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3124') AND (id_type = '149') LIMIT 1 UID:--153312-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505131533' ) UID:--153312-- UPDATE `vent_att` SET `att7`='google_ads',`att1`='OPP-',`att2`='3123',`att90`='Bonjour nettoyer mon toit et mettre une couche de protection ou de la peinture',`attf100`='20250513',`att8`='1573',`att6`='[IDMYUSER]',`att9`='3124',`att3`='§toiture§',`attdatmod`='202505131533',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '371') AND (id_type = '148') LIMIT 1 UID:--153312-- UPDATE `vent_att` SET `att7`='google_ads',`att1`='OPP-Lecoanet',`att2`='3123',`att90`='Bonjour nettoyer mon toit et mettre une couche de protection ou de la peinture',`attf100`='20250513',`att8`='1573',`att6`='[IDMYUSER]',`att9`='3124',`att3`='§toiture§',`attdatmod`='202505131533',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '371') AND (id_type = '148') LIMIT 1 UID:--153312-- UPDATE `vent_att` SET `att7`='google_ads',`att1`='OPP-Lecoanet',`att2`='3123',`att90`='Bonjour nettoyer mon toit et mettre une couche de protection ou de la peinture',`attf100`='20250513',`att8`='1573',`att6`='[IDMYUSER]',`att9`='3124',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505131533',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '371') AND (id_type = '148') LIMIT 1 UID:--153312-- UPDATE `vent_att` SET `att7`='google_ads',`att1`='OPP-Lecoanet',`att2`='3123',`att90`='Bonjour nettoyer mon toit et mettre une couche de protection ou de la peinture',`attf100`='20250513',`att8`='1573',`att6`='0',`att9`='3124',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505131533',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '371') AND (id_type = '148') LIMIT 1 UID:--153312-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250513','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Lecoanet','\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-Lecoanet

\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:--153312-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '249') LIMIT 1 UID:--153312--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:--153312-- UPDATE `tier_att` SET `id_work`='367',`att2`='Lecoanet',`att3`='Daniel',`att5`='0625491114',`att6`='lecoanetdaniel@hotmail.fr',`att8`='3123',`att10`='[IDMYUSER]',`att4`='0625491114',`attdatmod`='202505131533',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3124') AND (id_type = '149') LIMIT 1 UID:--153312-- UPDATE `tier_att` SET `id_work`='259',`att3`='Daniel',`att1`='Lecoanet',`att8`='non_défini',`att12`='lecoanetdaniel@hotmail.fr',`att14`='21 route de Saint Die',`att7`='88600',`att17`='Aydoilles',`att18`='France',`att5`='0625491114',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='google_ads',`attf105`='20250513',`att19`='48.21252',`att20`='6.567257',`attf100`='1',`attdatmod`='202505131533',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3123') AND (id_type = '80') LIMIT 1 UID:--153312-- UPDATE `tier_att` SET `id_work`='259',`att3`='Daniel',`att1`='Lecoanet',`att8`='non_défini',`att12`='lecoanetdaniel@hotmail.fr',`att14`='21 route de Saint Die',`att7`='88600',`att17`='Aydoilles',`att18`='France',`att5`='0625491114',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='google_ads',`attf105`='20250513',`att19`='48.21252',`att20`='6.567257',`attf100`='1',`attdatmod`='202505131533',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3123') AND (id_type = '80') LIMIT 1 UID:--153312-- UPDATE `tier_att` SET `id_work`='259',`att3`='Daniel',`att1`='Lecoanet',`att8`='non_défini',`att12`='lecoanetdaniel@hotmail.fr',`att14`='21 route de Saint Die',`att7`='88600',`att17`='Aydoilles',`att18`='France',`att5`='0625491114',`attf102`='20250513',`attf103`='1',`attf104`='1',`att11`='google_ads',`attf105`='20250513',`att19`='48.21252',`att20`='6.567257',`attf100`='1',`att6`='0625491114',`attdatmod`='202505131533',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3123') AND (id_type = '80') LIMIT 1 UID:--153312-- UPDATE `vent_att` SET `att7`='google_ads',`att1`='OPP-Lecoanet',`att2`='3123',`att90`='Bonjour nettoyer mon toit et mettre une couche de protection ou de la peinture',`attf100`='20250513',`att8`='1573',`att6`='0',`att9`='3124',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505131533',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '371') AND (id_type = '148') LIMIT 1 UID:--153859--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:--153859--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--153950--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:--153950--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--160307--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:--160307--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--160419--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:--160419--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--160455--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:--160455--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:8--161319--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('206','1','2','Inscription au service Avance Immédiate-587 - METZ.pdf','20250513','149','8','-3','-2') UID:8--161319--UPDATE `file` SET `last`='1' , `size`='593071' , `fol_id`='2' , `esp_id`='1' WHERE file_id=315 UID:8--161319--UPDATE `file` SET `id_type`='165' , `id_obje`='377' , `specif`='' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=315 UID:8--161319--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=315 UID:8--161319--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1 UID:8--161319--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','8','2','315','206','Inscription au service Avance Immédiate-587 - METZ.pdf','1','20250513','16:13:19','upload') UID:--161702--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:--161702--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:6--162142--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('210','1','2','Inscription au service Avance Immédiate-586 - EPINAL (1).pdf','20250513','891','6','-3','-2') UID:6--162142--UPDATE `file` SET `last`='1' , `size`='593158' , `fol_id`='2' , `esp_id`='1' WHERE file_id=321 UID:6--162142--UPDATE `file` SET `id_type`='165' , `id_obje`='382' , `specif`='' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=321 UID:6--162142--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=321 UID:6--162142--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1 UID:6--162142--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','6','2','321','210','Inscription au service Avance Immédiate-586 - EPINAL (1).pdf','1','20250513','16:21:42','upload') UID:10--164934--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--164934--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--171505--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:--171505--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--171519--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--171519--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--172640--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:--172640--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--173055--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:--173055--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--174629--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:--174629--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:8--181358--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('215','1','2','Inscription au service Avance Immédiate-587 - METZ.pdf','20250513','516','8','-3','-2') UID:8--181358--UPDATE `file` SET `last`='1' , `size`='593071' , `fol_id`='2' , `esp_id`='1' WHERE file_id=328 UID:8--181358--UPDATE `file` SET `id_type`='165' , `id_obje`='383' , `specif`='' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=328 UID:8--181358--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=328 UID:8--181358--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1 UID:8--181358--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','8','2','328','215','Inscription au service Avance Immédiate-587 - METZ.pdf','1','20250513','18:13:58','upload') UID:--195313--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:--195313--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre