UID:--095622--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:--095622--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--123109--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:--123109--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--142039--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:--142039--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--151821--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:--151821--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:8--154552--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('173','1','2','Inscription au service Avance Immédiate-587 - METZ.pdf','20250508','296','8','-3','-2') UID:8--154552--UPDATE `file` SET `last`='1' , `size`='593071' , `fol_id`='2' , `esp_id`='1' WHERE file_id=257 UID:8--154552--UPDATE `file` SET `id_type`='165' , `id_obje`='309' , `specif`='' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=257 UID:8--154552--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=257 UID:8--154552--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1 UID:8--154552--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','8','2','257','173','Inscription au service Avance Immédiate-587 - METZ.pdf','1','20250508','15:45:52','upload') UID:8--155300--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('176','1','2','Inscription au service Avance Immédiate-587 - METZ.pdf','20250508','497','8','-3','-2') UID:8--155300--UPDATE `file` SET `last`='1' , `size`='593071' , `fol_id`='2' , `esp_id`='1' WHERE file_id=261 UID:8--155300--UPDATE `file` SET `id_type`='165' , `id_obje`='310' , `specif`='' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=261 UID:8--155300--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=261 UID:8--155300--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1 UID:8--155300--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','8','2','261','176','Inscription au service Avance Immédiate-587 - METZ.pdf','1','20250508','15:53:00','upload') UID:8--161022--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('181','1','2','Inscription au service Avance Immédiate-587 - METZ.pdf','20250508','328','8','-3','-2') UID:8--161022--UPDATE `file` SET `last`='1' , `size`='593071' , `fol_id`='2' , `esp_id`='1' WHERE file_id=268 UID:8--161022--UPDATE `file` SET `id_type`='165' , `id_obje`='314' , `specif`='' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=268 UID:8--161022--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=268 UID:8--161022--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1 UID:8--161022--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','8','2','268','181','Inscription au service Avance Immédiate-587 - METZ.pdf','1','20250508','16:10:22','upload') UID:--172341-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505081723' ) UID:--172341-- UPDATE `tier_att` SET `id_work`='259',`att3`='Patrick',`att1`='FISCHER',`att8`='non_défini',`att12`='patrickfischer5757@gmail.com',`att14`='17 Rue de Chenevières',`att7`='57420',`att17`='CUVRY',`att18`='France',`att5`='0782216746',`attf102`='20250508',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250508',`attdatmod`='202505081723',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3073') AND (id_type = '80') LIMIT 1 UID:--172341-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3073','202505081723','202505081723' ) UID:--172341-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='17 Rue de Chenevières',`lig4`='57420',`lig5`='CUVRY',`lig6`='France',`ligdatmod`='202505081723',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3073') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1548') LIMIT 1 UID:--172341-- UPDATE `tier_att` SET `id_work`='259',`att3`='Patrick',`att1`='FISCHER',`att8`='non_défini',`att12`='patrickfischer5757@gmail.com',`att14`='17 Rue de Chenevières',`att7`='57420',`att17`='CUVRY',`att18`='France',`att5`='0782216746',`attf102`='20250508',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250508',`att19`='49.041913',`att20`='6.160745',`attf100`='1',`attdatmod`='202505081723',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3073') AND (id_type = '80') LIMIT 1 UID:--172341-- UPDATE `tier_att` SET `id_work`='259',`att3`='Patrick',`att1`='FISCHER',`att8`='non_défini',`att12`='patrickfischer5757@gmail.com',`att14`='17 Rue de Chenevières',`att7`='57420',`att17`='CUVRY',`att18`='France',`att5`='0782216746',`attf102`='20250508',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250508',`att19`='49.041913',`att20`='6.160745',`attf100`='1',`attdatmod`='202505081723',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3073') AND (id_type = '80') LIMIT 1 UID:--172341-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505081723' ) UID:--172341-- UPDATE `tier_att` SET `id_work`='367',`att2`='FISCHER',`att3`='Patrick',`att5`='0782216746',`att6`='patrickfischer5757@gmail.com',`att8`='3073',`att10`='[IDMYUSER]',`attdatmod`='202505081723',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3074') AND (id_type = '149') LIMIT 1 UID:--172341-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505081723' ) UID:--172341-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-',`att2`='3073',`attf100`='20250508',`att8`='1548',`att6`='[IDMYUSER]',`att9`='3074',`att3`='§toiture§',`attdatmod`='202505081723',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '317') AND (id_type = '148') LIMIT 1 UID:--172341-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-FISCHER',`att2`='3073',`attf100`='20250508',`att8`='1548',`att6`='[IDMYUSER]',`att9`='3074',`att3`='§toiture§',`attdatmod`='202505081723',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '317') AND (id_type = '148') LIMIT 1 UID:--172341-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-FISCHER',`att2`='3073',`attf100`='20250508',`att8`='1548',`att6`='[IDMYUSER]',`att9`='3074',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505081723',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '317') AND (id_type = '148') LIMIT 1 UID:--172341-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-FISCHER',`att2`='3073',`attf100`='20250508',`att8`='1548',`att6`='0',`att9`='3074',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505081723',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '317') AND (id_type = '148') LIMIT 1 UID:--172341-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250508','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-FISCHER','\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-FISCHER

\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:--172341-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '209') LIMIT 1 UID:--172341--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:--172342-- UPDATE `tier_att` SET `id_work`='367',`att2`='FISCHER',`att3`='Patrick',`att5`='0782216746',`att6`='patrickfischer5757@gmail.com',`att8`='3073',`att10`='[IDMYUSER]',`att4`='0782216746',`attdatmod`='202505081723',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3074') AND (id_type = '149') LIMIT 1 UID:--172342-- UPDATE `tier_att` SET `id_work`='259',`att3`='Patrick',`att1`='FISCHER',`att8`='non_défini',`att12`='patrickfischer5757@gmail.com',`att14`='17 Rue de Chenevières',`att7`='57420',`att17`='CUVRY',`att18`='France',`att5`='0782216746',`attf102`='20250508',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250508',`att19`='49.041913',`att20`='6.160745',`attf100`='1',`attdatmod`='202505081723',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3073') AND (id_type = '80') LIMIT 1 UID:--172342-- UPDATE `tier_att` SET `id_work`='259',`att3`='Patrick',`att1`='FISCHER',`att8`='non_défini',`att12`='patrickfischer5757@gmail.com',`att14`='17 Rue de Chenevières',`att7`='57420',`att17`='CUVRY',`att18`='France',`att5`='0782216746',`attf102`='20250508',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250508',`att19`='49.041913',`att20`='6.160745',`attf100`='1',`attdatmod`='202505081723',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3073') AND (id_type = '80') LIMIT 1 UID:--172342-- UPDATE `tier_att` SET `id_work`='259',`att3`='Patrick',`att1`='FISCHER',`att8`='non_défini',`att12`='patrickfischer5757@gmail.com',`att14`='17 Rue de Chenevières',`att7`='57420',`att17`='CUVRY',`att18`='France',`att5`='0782216746',`attf102`='20250508',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250508',`att19`='49.041913',`att20`='6.160745',`attf100`='1',`att6`='0782216746',`attdatmod`='202505081723',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3073') AND (id_type = '80') LIMIT 1 UID:--172342-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-FISCHER',`att2`='3073',`attf100`='20250508',`att8`='1548',`att6`='0',`att9`='3074',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505081723',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '317') AND (id_type = '148') LIMIT 1 UID:--181901--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:--181901--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--190017--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:--190017--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--200917--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:--200917--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--232205--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:--232205--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre