UID:--064315-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505070643' ) UID:--064315-- UPDATE `tier_att` SET `id_work`='259',`att3`='Thomas',`att1`='Velscher',`att8`='non_défini',`att12`='admin@sas-velscher.com',`att21`='4',`att14`='14 Rd 172',`att7`='54720',`att17`='Lexy',`att18`='France',`att5`='0382232084',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250507',`att24`='3',`attdatmod`='202505070643',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3061') AND (id_type = '80') LIMIT 1 UID:--064315-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3061','202505070643','202505070643' ) UID:--064315-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='14 Rd 172',`lig4`='54720',`lig5`='Lexy',`lig6`='France',`ligdatmod`='202505070643',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3061') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1542') LIMIT 1 UID:--064315-- UPDATE `tier_lig` SET `lig2`='281',`ligdatmod`='202505070643',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '6') LIMIT 1 UID:--064315-- UPDATE `tier_att` SET `id_work`='259',`att3`='Thomas',`att1`='Velscher',`att8`='non_défini',`att12`='admin@sas-velscher.com',`att21`='4',`att14`='14 Rd 172',`att7`='54720',`att17`='Lexy',`att18`='France',`att5`='0382232084',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250507',`att24`='3',`att19`='49.499227',`att20`='5.723916',`att22`='CL-METZ-281',`attf100`='1',`attdatmod`='202505070643',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3061') AND (id_type = '80') LIMIT 1 UID:--064316-- UPDATE `tier_att` SET `id_work`='259',`att3`='Thomas',`att1`='Velscher',`att8`='non_défini',`att12`='admin@sas-velscher.com',`att21`='4',`att14`='14 Rd 172',`att7`='54720',`att17`='Lexy',`att18`='France',`att5`='0382232084',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250507',`att24`='3',`att19`='49.499227',`att20`='5.723916',`att22`='-1',`attf100`='1',`attdatmod`='202505070643',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3061') AND (id_type = '80') LIMIT 1 UID:--064316-- UPDATE `tier_att` SET `id_work`='259',`att3`='Thomas',`att1`='Velscher',`att8`='non_défini',`att12`='admin@sas-velscher.com',`att21`='4',`att14`='14 Rd 172',`att7`='54720',`att17`='Lexy',`att18`='France',`att5`='0382232084',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250507',`att24`='3',`att19`='49.499227',`att20`='5.723916',`att22`='-1',`attf100`='1',`attdatmod`='202505070643',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3061') AND (id_type = '80') LIMIT 1 UID:--064316-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505070643' ) UID:--064316-- UPDATE `tier_att` SET `id_work`='367',`att2`='Velscher',`att3`='Thomas',`att5`='0382232084',`att6`='admin@sas-velscher.com',`att8`='3061',`att10`='[IDMYUSER]',`attdatmod`='202505070643',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3062') AND (id_type = '149') LIMIT 1 UID:--064316-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505070643' ) UID:--064316-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-',`att2`='3061',`attf100`='20250507',`att8`='1542',`att6`='[IDMYUSER]',`att9`='3062',`att3`='§façade§',`attdatmod`='202505070643',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '286') AND (id_type = '148') LIMIT 1 UID:--064316-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Velscher',`att2`='3061',`attf100`='20250507',`att8`='1542',`att6`='[IDMYUSER]',`att9`='3062',`att3`='§façade§',`attdatmod`='202505070643',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '286') AND (id_type = '148') LIMIT 1 UID:--064316-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Velscher',`att2`='3061',`attf100`='20250507',`att8`='1542',`att6`='[IDMYUSER]',`att9`='3062',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505070643',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '286') AND (id_type = '148') LIMIT 1 UID:--064316-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Velscher',`att2`='3061',`attf100`='20250507',`att8`='1542',`att6`='0',`att9`='3062',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505070643',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '286') AND (id_type = '148') LIMIT 1 UID:--064316-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250507','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Velscher','\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-Velscher

\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:--064316-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '184') LIMIT 1 UID:--064316--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:--064316-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250507','','1','','Exteco','agence-metz@exteco.fr','','','Exteco - Nouvelle opportunité - OPP-Velscher','\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-Velscher

\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:--064316-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '185') LIMIT 1 UID:--064316-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Velscher',`att2`='3061',`attf100`='20250507',`att8`='1542',`att6`='4',`att9`='3062',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505070643',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '286') AND (id_type = '148') LIMIT 1 UID:--064316-- UPDATE `tier_lig` SET `lig2`='282',`ligdatmod`='202505070643',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '6') LIMIT 1 UID:--064316-- UPDATE `tier_att` SET `id_work`='367',`att2`='Velscher',`att3`='Thomas',`att5`='0382232084',`att6`='admin@sas-velscher.com',`att8`='3061',`att10`='[IDMYUSER]',`att4`='0382232084',`attdatmod`='202505070643',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3062') AND (id_type = '149') LIMIT 1 UID:--064316-- UPDATE `tier_att` SET `id_work`='259',`att3`='Thomas',`att1`='Velscher',`att8`='non_défini',`att12`='admin@sas-velscher.com',`att21`='4',`att14`='14 Rd 172',`att7`='54720',`att17`='Lexy',`att18`='France',`att5`='0382232084',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250507',`att24`='3',`att19`='49.499227',`att20`='5.723916',`att22`='CL-METZ-282',`attf100`='1',`attdatmod`='202505070643',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3061') AND (id_type = '80') LIMIT 1 UID:--064316-- UPDATE `tier_att` SET `id_work`='259',`att3`='Thomas',`att1`='Velscher',`att8`='non_défini',`att12`='admin@sas-velscher.com',`att21`='4',`att14`='14 Rd 172',`att7`='54720',`att17`='Lexy',`att18`='France',`att5`='0382232084',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250507',`att24`='3',`att19`='49.499227',`att20`='5.723916',`att22`='CL-EPI-2616',`attf100`='1',`attdatmod`='202505070643',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3061') AND (id_type = '80') LIMIT 1 UID:--064316-- UPDATE `tier_att` SET `id_work`='259',`att3`='Thomas',`att1`='Velscher',`att8`='non_défini',`att12`='admin@sas-velscher.com',`att21`='4',`att14`='14 Rd 172',`att7`='54720',`att17`='Lexy',`att18`='France',`att5`='0382232084',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250507',`att24`='3',`att19`='49.499227',`att20`='5.723916',`att22`='CL-EPI-2616',`attf100`='1',`attdatmod`='202505070643',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3061') AND (id_type = '80') LIMIT 1 UID:--064316-- UPDATE `tier_att` SET `id_work`='259',`att3`='Thomas',`att1`='Velscher',`att8`='non_défini',`att12`='admin@sas-velscher.com',`att21`='4',`att14`='14 Rd 172',`att7`='54720',`att17`='Lexy',`att18`='France',`att5`='0382232084',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250507',`att24`='3',`att19`='49.499227',`att20`='5.723916',`att22`='CL-EPI-2616',`attf100`='1',`att6`='0382232084',`attdatmod`='202505070643',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3061') AND (id_type = '80') LIMIT 1 UID:--064316-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Velscher',`att2`='3061',`attf100`='20250507',`att8`='1542',`att6`='4',`att9`='3062',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505070643',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '286') AND (id_type = '148') LIMIT 1 UID:--083300--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:--083300--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--085906--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:--085906--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--091332--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:--091332--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--091342--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:--091342--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--091521--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:--091521--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--091928-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505070919' ) UID:--091928-- UPDATE `tier_att` SET `id_work`='259',`att3`='Rezwon',`att1`='Rezwon',`att8`='non_défini',`att12`='rezwon.0422@gmail.com',`att14`='Nancy',`att7`='52145',`att17`='Nancy',`att18`='France',`att5`='0954657771',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250507',`attdatmod`='202505070919',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3063') AND (id_type = '80') LIMIT 1 UID:--091928-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3063','202505070919','202505070919' ) UID:--091928-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='Nancy',`lig4`='52145',`lig5`='Nancy',`lig6`='France',`ligdatmod`='202505070919',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3063') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1543') LIMIT 1 UID:--091928-- UPDATE `tier_att` SET `id_work`='259',`att3`='Rezwon',`att1`='Rezwon',`att8`='non_défini',`att12`='rezwon.0422@gmail.com',`att14`='Nancy',`att7`='52145',`att17`='Nancy',`att18`='France',`att5`='0954657771',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250507',`att19`='48.63645',`att20`='4.978067',`attf100`='1',`attdatmod`='202505070919',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3063') AND (id_type = '80') LIMIT 1 UID:--091928-- UPDATE `tier_att` SET `id_work`='259',`att3`='Rezwon',`att1`='Rezwon',`att8`='non_défini',`att12`='rezwon.0422@gmail.com',`att14`='Nancy',`att7`='52145',`att17`='Nancy',`att18`='France',`att5`='0954657771',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250507',`att19`='48.63645',`att20`='4.978067',`attf100`='1',`attdatmod`='202505070919',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3063') AND (id_type = '80') LIMIT 1 UID:--091928-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505070919' ) UID:--091928-- UPDATE `tier_att` SET `id_work`='367',`att2`='Rezwon',`att3`='Rezwon',`att5`='0954657771',`att6`='rezwon.0422@gmail.com',`att8`='3063',`att10`='[IDMYUSER]',`attdatmod`='202505070919',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3064') AND (id_type = '149') LIMIT 1 UID:--091928-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505070919' ) UID:--091928-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-',`att2`='3063',`attf100`='20250507',`att8`='1543',`att6`='[IDMYUSER]',`att9`='3064',`att3`='§toiture§',`attdatmod`='202505070919',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '287') AND (id_type = '148') LIMIT 1 UID:--091928-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Rezwon',`att2`='3063',`attf100`='20250507',`att8`='1543',`att6`='[IDMYUSER]',`att9`='3064',`att3`='§toiture§',`attdatmod`='202505070919',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '287') AND (id_type = '148') LIMIT 1 UID:--091928-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Rezwon',`att2`='3063',`attf100`='20250507',`att8`='1543',`att6`='[IDMYUSER]',`att9`='3064',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505070919',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '287') AND (id_type = '148') LIMIT 1 UID:--091928-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Rezwon',`att2`='3063',`attf100`='20250507',`att8`='1543',`att6`='0',`att9`='3064',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505070919',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '287') AND (id_type = '148') LIMIT 1 UID:--091928-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250507','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Rezwon','\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-Rezwon

\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:--091928-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '186') LIMIT 1 UID:--091928--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:--091928-- UPDATE `tier_att` SET `id_work`='367',`att2`='Rezwon',`att3`='Rezwon',`att5`='0954657771',`att6`='rezwon.0422@gmail.com',`att8`='3063',`att10`='[IDMYUSER]',`att4`='0954657771',`attdatmod`='202505070919',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3064') AND (id_type = '149') LIMIT 1 UID:--091928-- UPDATE `tier_att` SET `id_work`='259',`att3`='Rezwon',`att1`='Rezwon',`att8`='non_défini',`att12`='rezwon.0422@gmail.com',`att14`='Nancy',`att7`='52145',`att17`='Nancy',`att18`='France',`att5`='0954657771',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250507',`att19`='48.63645',`att20`='4.978067',`attf100`='1',`attdatmod`='202505070919',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3063') AND (id_type = '80') LIMIT 1 UID:--091928-- UPDATE `tier_att` SET `id_work`='259',`att3`='Rezwon',`att1`='Rezwon',`att8`='non_défini',`att12`='rezwon.0422@gmail.com',`att14`='Nancy',`att7`='52145',`att17`='Nancy',`att18`='France',`att5`='0954657771',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250507',`att19`='48.63645',`att20`='4.978067',`attf100`='1',`attdatmod`='202505070919',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3063') AND (id_type = '80') LIMIT 1 UID:--091928-- UPDATE `tier_att` SET `id_work`='259',`att3`='Rezwon',`att1`='Rezwon',`att8`='non_défini',`att12`='rezwon.0422@gmail.com',`att14`='Nancy',`att7`='52145',`att17`='Nancy',`att18`='France',`att5`='0954657771',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250507',`att19`='48.63645',`att20`='4.978067',`attf100`='1',`att6`='0954657771',`attdatmod`='202505070919',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3063') AND (id_type = '80') LIMIT 1 UID:--091928-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Rezwon',`att2`='3063',`attf100`='20250507',`att8`='1543',`att6`='0',`att9`='3064',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505070919',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '287') AND (id_type = '148') LIMIT 1 UID:--092016--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:--092016--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:2--092437--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--092437--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--092645--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:--092645-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202505070926' ) UID:--092645-- UPDATE `vent_att` SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='test envoi',`att90`='rr894zv3nxyd3t6a',`attf100`='20250505',`att5`='2835',`att8`='12',`att9`='280',`att10`='56',`att11`='336',`att13`='virement',`att14`='244',`att15`='\n

Rainea Exteco TooSmart

\n
\n

33 rue Paul Duvivier
\n 69007 Lyon

\n <',`att16`=' 66 rue coste 69300 Caluire et cuire',`att18`='0',`att24`='336',`att25`='66 rue coste',`att26`='',`att27`='69300',`att28`='Caluire et cuire',`attdatmod`='202505070926',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '290') AND (id_type = '168') LIMIT 1 UID:--092645-- UPDATE `vent_att` SET `newobj`='new' WHERE 1=1 AND (id_type = '168') AND (id_vent = '290') LIMIT 1 UID:--092645-- UPDATE `tier_lig` SET `lig2`='8',`ligdatmod`='202505070926',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '7') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '32') LIMIT 1 UID:--092645-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-TOO-8',`att3`='',`att2`='test envoi',`att90`='rr894zv3nxyd3t6a',`attf100`='20250505',`att5`='2835',`att8`='12',`att9`='280',`att10`='56',`att11`='336',`att13`='virement',`att14`='244',`att15`='\n

Rainea Exteco TooSmart

\n
\n

33 rue Paul Duvivier
\n 69007 Lyon

\n <',`att16`=' 66 rue coste 69300 Caluire et cuire',`att18`='0',`att24`='336',`att25`='66 rue coste',`att26`='',`att27`='69300',`att28`='Caluire et cuire',`attdatmod`='202505070926',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '290') AND (id_type = '168') LIMIT 1 UID:--092645-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','290','202505070926','202505070926' ) UID:--092645-- UPDATE `vent_lig` SET `actif`='1',`lig1`='163',`lig7`='56.00',`lig9`='163',`lig16`='Unite',`lig3`='1',`lig2`='280.00',`lig5`='20',`lig4`='280.00',`lig8`='336.00',`lig10`='euro',`lig6`='336.00',`lig90`='<p><br></p>',`ligdatmod`='202505070926',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '290') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '409') LIMIT 1 UID:--092645-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('72','1','2','Devis_DV-TOO-11_07_05_2025_09h_24m_signe.pdf','20250507','99','devis_signe','168','290','-2','-1','' ) UID:--092645-- UPDATE `file` SET `size`='138084' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '231') LIMIT 1 UID:--092646-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('73','1','2','Attestation_fiscale_DV_TOO_11_07_05_2025_09h_23m_signe.pdf','20250507','727','attestation_signe','168','290','-2','-1','' ) UID:--092646-- UPDATE `file` SET `size`='437021' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '232') LIMIT 1 UID:--092646-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250507','','1','tete_de_reseau@toosmart.fr','Exteco','morganetestapi@toosmart.fr','','','Merci pour votre commande : Devis N°DV-TOO-11','\r\n\r\nNouveau Devis EXTECO\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 Merci pour votre commande (Devis N° DV-TOO-11)\r\n

\r\n\r\n

\r\n Bonjour Test,

Nous vous remercions pour votre commande. Vous trouverez ci-joint le devis que vous avez signé.

Nous prendrons contact avec vous rapidement pour programmer l\'intervention. En attendant, n\'hésitez pas à nous contacter si vous avez la moindre question ou besoin de clarification sur certains points.

\r\n Nous vous remercions de votre confiance et restons à votre disposition pour toute information complémentaire.

\r\n Cordialement,
\r\n

\r\n\r\n

\r\n Votre équipe Exteco

\r\n

\r\n
\r\n \r\n\r\n
\r\n
\r\n','/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/231-72-99-1§Devis_DV-TOO-11_07_05_2025_09h_24m_signe.pdf;/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/232-73-727-1§Attestation_fiscale_DV_TOO_11_07_05_2025_09h_23m_signe.pdf','0','v2017b' ) UID:--092646-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '188') LIMIT 1 UID:--092646-- UPDATE `vent_lig` SET `lig1`='163',`lig7`='56.00',`lig9`='163',`lig16`='Unite',`lig3`='1',`lig2`='280.00',`lig5`='20',`lig4`='280.00',`lig8`='336.00',`lig10`='euro',`lig6`='336.00',`lig90`='<p><br></p>',`ligdatmod`='202505070926',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '290') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '409') LIMIT 1 UID:--092646-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-TOO-8',`att3`='',`att2`='test envoi',`att90`='rr894zv3nxyd3t6a',`attf100`='20250505',`att5`='2835',`att8`='12',`att9`='280',`att10`='56',`att11`='336',`att13`='virement',`att14`='244',`att15`='\n

Rainea Exteco TooSmart

\n
\n

33 rue Paul Duvivier
\n 69007 Lyon

\n <',`att16`=' 66 rue coste 69300 Caluire et cuire',`att18`='0',`att24`='336',`att25`='66 rue coste',`att26`='',`att27`='69300',`att28`='Caluire et cuire',`att31`='56',`att29`='280',`attdatmod`='202505070926',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '290') AND (id_type = '168') LIMIT 1 UID:--092646-- UPDATE `vent_att` SET `id_work`='417',`att4`='12',`attdatmod`='202505070926',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '77') AND (id_type = '148') LIMIT 1 UID:--092646-- UPDATE `vent_att` SET `id_work`='412',`attf107`='202505070926',`attdatmod`='202505070926',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '244') AND (id_type = '165') LIMIT 1 UID:--092646-- UPDATE `tier_att` SET `id_work`='205',`attdatmod`='202505070926',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '2835') AND (id_type = '80') LIMIT 1 UID:1--092722--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--092722--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--093750--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--093750--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--094408--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:--094408--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--094437--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:--094437--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--094608--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--094608--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--094935--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--094935--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--101604--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:--101604--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--101820--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:--101820--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--102419-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505071024' ) UID:--102419-- UPDATE `tier_att` SET `id_work`='259',`att3`='ludi test',`att1`='Ludi test',`att8`='non_défini',`att12`='ludivine@exteco.fr',`att21`='4',`att14`='3 allée des Roches',`att7`='54600',`att17`='Nancy',`att18`='France',`att5`='0633411317',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250507',`att24`='3',`attdatmod`='202505071024',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3067') AND (id_type = '80') LIMIT 1 UID:--102420-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3067','202505071024','202505071024' ) UID:--102420-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='3 allée des Roches',`lig4`='54600',`lig5`='Nancy',`lig6`='France',`ligdatmod`='202505071024',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3067') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1545') LIMIT 1 UID:--102420-- UPDATE `tier_lig` SET `lig2`='286',`ligdatmod`='202505071024',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '6') LIMIT 1 UID:--102420-- UPDATE `tier_att` SET `id_work`='259',`att3`='ludi test',`att1`='Ludi test',`att8`='non_défini',`att12`='ludivine@exteco.fr',`att21`='4',`att14`='3 allée des Roches',`att7`='54600',`att17`='Nancy',`att18`='France',`att5`='0633411317',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250507',`att24`='3',`att19`='48.660424',`att20`='6.111404',`att22`='CL-METZ-286',`attf100`='1',`attdatmod`='202505071024',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3067') AND (id_type = '80') LIMIT 1 UID:--102420-- UPDATE `tier_att` SET `id_work`='259',`att3`='ludi test',`att1`='Ludi test',`att8`='non_défini',`att12`='ludivine@exteco.fr',`att21`='4',`att14`='3 allée des Roches',`att7`='54600',`att17`='Nancy',`att18`='France',`att5`='0633411317',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250507',`att24`='3',`att19`='48.660424',`att20`='6.111404',`att22`='-1',`attf100`='1',`attdatmod`='202505071024',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3067') AND (id_type = '80') LIMIT 1 UID:--102420-- UPDATE `tier_att` SET `id_work`='259',`att3`='ludi test',`att1`='Ludi test',`att8`='non_défini',`att12`='ludivine@exteco.fr',`att21`='4',`att14`='3 allée des Roches',`att7`='54600',`att17`='Nancy',`att18`='France',`att5`='0633411317',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250507',`att24`='3',`att19`='48.660424',`att20`='6.111404',`att22`='-1',`attf100`='1',`attdatmod`='202505071024',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3067') AND (id_type = '80') LIMIT 1 UID:--102420-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505071024' ) UID:--102420-- UPDATE `tier_att` SET `id_work`='367',`att2`='Ludi test',`att3`='ludi test',`att5`='0633411317',`att6`='ludivine@exteco.fr',`att8`='3067',`att10`='[IDMYUSER]',`attdatmod`='202505071024',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3068') AND (id_type = '149') LIMIT 1 UID:--102420-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505071024' ) UID:--102420-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-',`att2`='3067',`attf100`='20250507',`att8`='1545',`att6`='[IDMYUSER]',`att9`='3068',`att3`='§toiture§',`attdatmod`='202505071024',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '294') AND (id_type = '148') LIMIT 1 UID:--102420-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Ludi test',`att2`='3067',`attf100`='20250507',`att8`='1545',`att6`='[IDMYUSER]',`att9`='3068',`att3`='§toiture§',`attdatmod`='202505071024',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '294') AND (id_type = '148') LIMIT 1 UID:--102420-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Ludi test',`att2`='3067',`attf100`='20250507',`att8`='1545',`att6`='[IDMYUSER]',`att9`='3068',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505071024',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '294') AND (id_type = '148') LIMIT 1 UID:--102420-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Ludi test',`att2`='3067',`attf100`='20250507',`att8`='1545',`att6`='0',`att9`='3068',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505071024',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '294') AND (id_type = '148') LIMIT 1 UID:--102420-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250507','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Ludi test','\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-Ludi test

\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:--102420-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '190') LIMIT 1 UID:--102420--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:--102420-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250507','','1','','Exteco','agence-metz@exteco.fr','','','Exteco - Nouvelle opportunité - OPP-Ludi test','\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-Ludi test

\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:--102420-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '191') LIMIT 1 UID:--102420-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Ludi test',`att2`='3067',`attf100`='20250507',`att8`='1545',`att6`='4',`att9`='3068',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505071024',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '294') AND (id_type = '148') LIMIT 1 UID:--102420-- UPDATE `tier_lig` SET `lig2`='287',`ligdatmod`='202505071024',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '6') LIMIT 1 UID:--102420-- UPDATE `tier_att` SET `id_work`='367',`att2`='Ludi test',`att3`='ludi test',`att5`='0633411317',`att6`='ludivine@exteco.fr',`att8`='3067',`att10`='[IDMYUSER]',`att4`='0633411317',`attdatmod`='202505071024',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3068') AND (id_type = '149') LIMIT 1 UID:--102420-- UPDATE `tier_att` SET `id_work`='259',`att3`='ludi test',`att1`='Ludi test',`att8`='non_défini',`att12`='ludivine@exteco.fr',`att21`='4',`att14`='3 allée des Roches',`att7`='54600',`att17`='Nancy',`att18`='France',`att5`='0633411317',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250507',`att24`='3',`att19`='48.660424',`att20`='6.111404',`att22`='CL-METZ-287',`attf100`='1',`attdatmod`='202505071024',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3067') AND (id_type = '80') LIMIT 1 UID:--102420-- UPDATE `tier_att` SET `id_work`='259',`att3`='ludi test',`att1`='Ludi test',`att8`='non_défini',`att12`='ludivine@exteco.fr',`att21`='4',`att14`='3 allée des Roches',`att7`='54600',`att17`='Nancy',`att18`='France',`att5`='0633411317',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250507',`att24`='3',`att19`='48.660424',`att20`='6.111404',`att22`='CL-EPI-2616',`attf100`='1',`attdatmod`='202505071024',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3067') AND (id_type = '80') LIMIT 1 UID:--102420-- UPDATE `tier_att` SET `id_work`='259',`att3`='ludi test',`att1`='Ludi test',`att8`='non_défini',`att12`='ludivine@exteco.fr',`att21`='4',`att14`='3 allée des Roches',`att7`='54600',`att17`='Nancy',`att18`='France',`att5`='0633411317',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250507',`att24`='3',`att19`='48.660424',`att20`='6.111404',`att22`='CL-EPI-2616',`attf100`='1',`attdatmod`='202505071024',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3067') AND (id_type = '80') LIMIT 1 UID:--102420-- UPDATE `tier_att` SET `id_work`='259',`att3`='ludi test',`att1`='Ludi test',`att8`='non_défini',`att12`='ludivine@exteco.fr',`att21`='4',`att14`='3 allée des Roches',`att7`='54600',`att17`='Nancy',`att18`='France',`att5`='0633411317',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250507',`att24`='3',`att19`='48.660424',`att20`='6.111404',`att22`='CL-EPI-2616',`attf100`='1',`att6`='0633411317',`attdatmod`='202505071024',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3067') AND (id_type = '80') LIMIT 1 UID:--102420-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Ludi test',`att2`='3067',`attf100`='20250507',`att8`='1545',`att6`='4',`att9`='3068',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505071024',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '294') AND (id_type = '148') LIMIT 1 UID:--102700--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:--102700--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:2--103214--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('159','1','2','Inscription au service Avance Immédiate-586 - EPINAL.pdf','20250507','277','2','-3','-2') UID:2--103214--UPDATE `file` SET `last`='1' , `size`='593158' , `fol_id`='2' , `esp_id`='1' WHERE file_id=236 UID:2--103214--UPDATE `file` SET `id_type`='165' , `id_obje`='292' , `specif`='' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=236 UID:2--103214--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=236 UID:2--103214--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1 UID:2--103214--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','2','2','236','159','Inscription au service Avance Immédiate-586 - EPINAL.pdf','1','20250507','10:32:14','upload') UID:--104717--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:--104717--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--110354--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:--110354--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--122046--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:--122046--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--152047--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:--152047--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--152121-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505071521' ) UID:--152121-- UPDATE `tier_att` SET `id_work`='259',`att3`='Henri',`att1`='DONIAS',`att8`='non_défini',`att12`='diamjeld@gmail.com',`att14`='Plouhinec',`att7`='56680',`att17`='PLOUHINEC',`att18`='France',`att5`='0628345181',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250507',`attdatmod`='202505071521',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3071') AND (id_type = '80') LIMIT 1 UID:--152121-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3071','202505071521','202505071521' ) UID:--152121-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='Plouhinec',`lig4`='56680',`lig5`='PLOUHINEC',`lig6`='France',`ligdatmod`='202505071521',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3071') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1547') LIMIT 1 UID:--152121-- UPDATE `tier_att` SET `id_work`='259',`att3`='Henri',`att1`='DONIAS',`att8`='non_défini',`att12`='diamjeld@gmail.com',`att14`='Plouhinec',`att7`='56680',`att17`='PLOUHINEC',`att18`='France',`att5`='0628345181',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250507',`att19`='47.693989',`att20`='-3.24097',`attf100`='1',`attdatmod`='202505071521',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3071') AND (id_type = '80') LIMIT 1 UID:--152121-- UPDATE `tier_att` SET `id_work`='259',`att3`='Henri',`att1`='DONIAS',`att8`='non_défini',`att12`='diamjeld@gmail.com',`att14`='Plouhinec',`att7`='56680',`att17`='PLOUHINEC',`att18`='France',`att5`='0628345181',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250507',`att19`='47.693989',`att20`='-3.24097',`attf100`='1',`attdatmod`='202505071521',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3071') AND (id_type = '80') LIMIT 1 UID:--152121-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505071521' ) UID:--152121-- UPDATE `tier_att` SET `id_work`='367',`att2`='DONIAS',`att3`='Henri',`att5`='0628345181',`att6`='diamjeld@gmail.com',`att8`='3071',`att10`='[IDMYUSER]',`attdatmod`='202505071521',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3072') AND (id_type = '149') LIMIT 1 UID:--152121-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505071521' ) UID:--152121-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-',`att2`='3071',`attf100`='20250507',`att8`='1547',`att6`='[IDMYUSER]',`att9`='3072',`att3`='§toiture§',`attdatmod`='202505071521',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '302') AND (id_type = '148') LIMIT 1 UID:--152121-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-DONIAS',`att2`='3071',`attf100`='20250507',`att8`='1547',`att6`='[IDMYUSER]',`att9`='3072',`att3`='§toiture§',`attdatmod`='202505071521',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '302') AND (id_type = '148') LIMIT 1 UID:--152121-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-DONIAS',`att2`='3071',`attf100`='20250507',`att8`='1547',`att6`='[IDMYUSER]',`att9`='3072',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505071521',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '302') AND (id_type = '148') LIMIT 1 UID:--152121-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-DONIAS',`att2`='3071',`attf100`='20250507',`att8`='1547',`att6`='0',`att9`='3072',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505071521',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '302') AND (id_type = '148') LIMIT 1 UID:--152121-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250507','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-DONIAS','\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-DONIAS

\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:--152121-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '194') LIMIT 1 UID:--152121--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:--152121-- UPDATE `tier_att` SET `id_work`='367',`att2`='DONIAS',`att3`='Henri',`att5`='0628345181',`att6`='diamjeld@gmail.com',`att8`='3071',`att10`='[IDMYUSER]',`att4`='0628345181',`attdatmod`='202505071521',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3072') AND (id_type = '149') LIMIT 1 UID:--152121-- UPDATE `tier_att` SET `id_work`='259',`att3`='Henri',`att1`='DONIAS',`att8`='non_défini',`att12`='diamjeld@gmail.com',`att14`='Plouhinec',`att7`='56680',`att17`='PLOUHINEC',`att18`='France',`att5`='0628345181',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250507',`att19`='47.693989',`att20`='-3.24097',`attf100`='1',`attdatmod`='202505071521',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3071') AND (id_type = '80') LIMIT 1 UID:--152121-- UPDATE `tier_att` SET `id_work`='259',`att3`='Henri',`att1`='DONIAS',`att8`='non_défini',`att12`='diamjeld@gmail.com',`att14`='Plouhinec',`att7`='56680',`att17`='PLOUHINEC',`att18`='France',`att5`='0628345181',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250507',`att19`='47.693989',`att20`='-3.24097',`attf100`='1',`attdatmod`='202505071521',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3071') AND (id_type = '80') LIMIT 1 UID:--152121-- UPDATE `tier_att` SET `id_work`='259',`att3`='Henri',`att1`='DONIAS',`att8`='non_défini',`att12`='diamjeld@gmail.com',`att14`='Plouhinec',`att7`='56680',`att17`='PLOUHINEC',`att18`='France',`att5`='0628345181',`attf102`='20250507',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250507',`att19`='47.693989',`att20`='-3.24097',`attf100`='1',`att6`='0628345181',`attdatmod`='202505071521',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3071') AND (id_type = '80') LIMIT 1 UID:--152121-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-DONIAS',`att2`='3071',`attf100`='20250507',`att8`='1547',`att6`='0',`att9`='3072',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505071521',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '302') AND (id_type = '148') LIMIT 1 UID:--153110--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:--153110--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--154351--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:--154351--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--154639--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:--154639--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:10--160634--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--160634--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--162312--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:--162312--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--163754--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:--163754--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--165800--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:--165800--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--165829--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:--165829--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:9--170203--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--170203--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--175615--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:--175615--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--180020--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:--180020--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:8--180116--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:8--180116--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:8--180117--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:8--180117--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:8--180119--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:8--180119--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:8--180120--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:8--180120--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:8--180121--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:8--180121--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:8--181925--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:8--181925--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--221732--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:--221732--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre