UID:--024512-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505180245' )
UID:--024512-- UPDATE `tier_att` SET `id_work`='259',`att3`='Valérie',`att1`='Grosse',`att8`='non_défini',`att12`='vgrosse@hotmail.fr',`att14`='9 Lotissement Le Clos Du Henin',`att7`='57935',`att17`='Luttange',`att18`='France',`att5`='0687311781',`attf102`='20250518',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250518',`attdatmod`='202505180245',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3180') AND (id_type = '80') LIMIT 1
UID:--024512-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3180','202505180245','202505180245' )
UID:--024512-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='9 Lotissement Le Clos Du Henin',`lig4`='57935',`lig5`='Luttange',`lig6`='France',`ligdatmod`='202505180245',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3180') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1602') LIMIT 1
UID:--024512-- UPDATE `tier_att` SET `id_work`='259',`att3`='Valérie',`att1`='Grosse',`att8`='non_défini',`att12`='vgrosse@hotmail.fr',`att14`='9 Lotissement Le Clos Du Henin',`att7`='57935',`att17`='Luttange',`att18`='France',`att5`='0687311781',`attf102`='20250518',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250518',`att19`='49.269433',`att20`='6.306044',`attf100`='1',`attdatmod`='202505180245',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3180') AND (id_type = '80') LIMIT 1
UID:--024512-- UPDATE `tier_att` SET `id_work`='259',`att3`='Valérie',`att1`='Grosse',`att8`='non_défini',`att12`='vgrosse@hotmail.fr',`att14`='9 Lotissement Le Clos Du Henin',`att7`='57935',`att17`='Luttange',`att18`='France',`att5`='0687311781',`attf102`='20250518',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250518',`att19`='49.269433',`att20`='6.306044',`attf100`='1',`attdatmod`='202505180245',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3180') AND (id_type = '80') LIMIT 1
UID:--024512-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505180245' )
UID:--024512-- UPDATE `tier_att` SET `id_work`='367',`att2`='Grosse',`att3`='Valérie',`att5`='0687311781',`att6`='vgrosse@hotmail.fr',`att8`='3180',`att10`='[IDMYUSER]',`attdatmod`='202505180245',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3181') AND (id_type = '149') LIMIT 1
UID:--024512-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505180245' )
UID:--024512-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-',`att2`='3180',`att90`='Bonjour\r\nJe souhaiterai un devis pour nettoyage et imperméabilisation de façades sur une maison individuelle.\r\n\r\nCordon',`attf100`='20250518',`att8`='1602',`att6`='[IDMYUSER]',`att9`='3181',`att3`='§façade§',`attdatmod`='202505180245',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '470') AND (id_type = '148') LIMIT 1
UID:--024512-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Grosse',`att2`='3180',`att90`='Bonjour\r\nJe souhaiterai un devis pour nettoyage et imperméabilisation de façades sur une maison individuelle.\r\n\r\nCordon',`attf100`='20250518',`att8`='1602',`att6`='[IDMYUSER]',`att9`='3181',`att3`='§façade§',`attdatmod`='202505180245',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '470') AND (id_type = '148') LIMIT 1
UID:--024512-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Grosse',`att2`='3180',`att90`='Bonjour\r\nJe souhaiterai un devis pour nettoyage et imperméabilisation de façades sur une maison individuelle.\r\n\r\nCordon',`attf100`='20250518',`att8`='1602',`att6`='[IDMYUSER]',`att9`='3181',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505180245',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '470') AND (id_type = '148') LIMIT 1
UID:--024512-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Grosse',`att2`='3180',`att90`='Bonjour\r\nJe souhaiterai un devis pour nettoyage et imperméabilisation de façades sur une maison individuelle.\r\n\r\nCordon',`attf100`='20250518',`att8`='1602',`att6`='0',`att9`='3181',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505180245',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '470') AND (id_type = '148') LIMIT 1
UID:--024512-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250518','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Grosse','\r\n\r\n
Nouvelle 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 Nouvelle opportunité - OPP-Grosse \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 | \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n | \r\n
\r\n
','','0','v2017b' )
UID:--024512-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '342') LIMIT 1
UID:--024512--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:--024512-- UPDATE `tier_att` SET `id_work`='367',`att2`='Grosse',`att3`='Valérie',`att5`='0687311781',`att6`='vgrosse@hotmail.fr',`att8`='3180',`att10`='[IDMYUSER]',`att4`='0687311781',`attdatmod`='202505180245',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3181') AND (id_type = '149') LIMIT 1
UID:--024512-- UPDATE `tier_att` SET `id_work`='259',`att3`='Valérie',`att1`='Grosse',`att8`='non_défini',`att12`='vgrosse@hotmail.fr',`att14`='9 Lotissement Le Clos Du Henin',`att7`='57935',`att17`='Luttange',`att18`='France',`att5`='0687311781',`attf102`='20250518',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250518',`att19`='49.269433',`att20`='6.306044',`attf100`='1',`attdatmod`='202505180245',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3180') AND (id_type = '80') LIMIT 1
UID:--024512-- UPDATE `tier_att` SET `id_work`='259',`att3`='Valérie',`att1`='Grosse',`att8`='non_défini',`att12`='vgrosse@hotmail.fr',`att14`='9 Lotissement Le Clos Du Henin',`att7`='57935',`att17`='Luttange',`att18`='France',`att5`='0687311781',`attf102`='20250518',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250518',`att19`='49.269433',`att20`='6.306044',`attf100`='1',`attdatmod`='202505180245',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3180') AND (id_type = '80') LIMIT 1
UID:--024512-- UPDATE `tier_att` SET `id_work`='259',`att3`='Valérie',`att1`='Grosse',`att8`='non_défini',`att12`='vgrosse@hotmail.fr',`att14`='9 Lotissement Le Clos Du Henin',`att7`='57935',`att17`='Luttange',`att18`='France',`att5`='0687311781',`attf102`='20250518',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250518',`att19`='49.269433',`att20`='6.306044',`attf100`='1',`att6`='0687311781',`attdatmod`='202505180245',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3180') AND (id_type = '80') LIMIT 1
UID:--024512-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Grosse',`att2`='3180',`att90`='Bonjour\r\nJe souhaiterai un devis pour nettoyage et imperméabilisation de façades sur une maison individuelle.\r\n\r\nCordon',`attf100`='20250518',`att8`='1602',`att6`='0',`att9`='3181',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505180245',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '470') AND (id_type = '148') LIMIT 1
UID:--164838--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:--164838--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--204858-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505182048' )
UID:--204858-- UPDATE `tier_att` SET `id_work`='259',`att3`='Jean-Pierre',`att1`='Valadas',`att8`='non_défini',`att12`='valadasjp@gmail.com',`att14`='4 Rue du Lux en Roc, Brem-sur-Mer, France',`att7`='85470',`att17`='Brem-sur-Mer',`att18`='France',`att5`='0612054427',`attf102`='20250518',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250518',`attdatmod`='202505182048',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3182') AND (id_type = '80') LIMIT 1
UID:--204858-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3182','202505182048','202505182048' )
UID:--204858-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='4 Rue du Lux en Roc, Brem-sur-Mer, France',`lig4`='85470',`lig5`='Brem-sur-Mer',`lig6`='France',`ligdatmod`='202505182048',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3182') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1603') LIMIT 1
UID:--204858-- UPDATE `tier_att` SET `id_work`='259',`att3`='Jean-Pierre',`att1`='Valadas',`att8`='non_défini',`att12`='valadasjp@gmail.com',`att14`='4 Rue du Lux en Roc, Brem-sur-Mer, France',`att7`='85470',`att17`='Brem-sur-Mer',`att18`='France',`att5`='0612054427',`attf102`='20250518',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250518',`att19`='46.607311',`att20`='-1.829707',`attf100`='1',`attdatmod`='202505182048',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3182') AND (id_type = '80') LIMIT 1
UID:--204858-- UPDATE `tier_att` SET `id_work`='259',`att3`='Jean-Pierre',`att1`='Valadas',`att8`='non_défini',`att12`='valadasjp@gmail.com',`att14`='4 Rue du Lux en Roc, Brem-sur-Mer, France',`att7`='85470',`att17`='Brem-sur-Mer',`att18`='France',`att5`='0612054427',`attf102`='20250518',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250518',`att19`='46.607311',`att20`='-1.829707',`attf100`='1',`attdatmod`='202505182048',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3182') AND (id_type = '80') LIMIT 1
UID:--204858-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505182048' )
UID:--204858-- UPDATE `tier_att` SET `id_work`='367',`att2`='Valadas',`att3`='Jean-Pierre',`att5`='0612054427',`att6`='valadasjp@gmail.com',`att8`='3182',`att10`='[IDMYUSER]',`attdatmod`='202505182048',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3183') AND (id_type = '149') LIMIT 1
UID:--204858-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505182048' )
UID:--204858-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-',`att2`='3182',`attf100`='20250518',`att8`='1603',`att6`='[IDMYUSER]',`att9`='3183',`att3`='§toiture§',`attdatmod`='202505182048',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '471') AND (id_type = '148') LIMIT 1
UID:--204858-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Valadas',`att2`='3182',`attf100`='20250518',`att8`='1603',`att6`='[IDMYUSER]',`att9`='3183',`att3`='§toiture§',`attdatmod`='202505182048',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '471') AND (id_type = '148') LIMIT 1
UID:--204858-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Valadas',`att2`='3182',`attf100`='20250518',`att8`='1603',`att6`='[IDMYUSER]',`att9`='3183',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505182048',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '471') AND (id_type = '148') LIMIT 1
UID:--204858-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Valadas',`att2`='3182',`attf100`='20250518',`att8`='1603',`att6`='0',`att9`='3183',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505182048',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '471') AND (id_type = '148') LIMIT 1
UID:--204858-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250518','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Valadas','\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 Nouvelle opportunité - OPP-Valadas \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 | \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n | \r\n
\r\n
','','0','v2017b' )
UID:--204858-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '343') LIMIT 1
UID:--204858--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:--204858-- UPDATE `tier_att` SET `id_work`='367',`att2`='Valadas',`att3`='Jean-Pierre',`att5`='0612054427',`att6`='valadasjp@gmail.com',`att8`='3182',`att10`='[IDMYUSER]',`att4`='0612054427',`attdatmod`='202505182048',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3183') AND (id_type = '149') LIMIT 1
UID:--204858-- UPDATE `tier_att` SET `id_work`='259',`att3`='Jean-Pierre',`att1`='Valadas',`att8`='non_défini',`att12`='valadasjp@gmail.com',`att14`='4 Rue du Lux en Roc, Brem-sur-Mer, France',`att7`='85470',`att17`='Brem-sur-Mer',`att18`='France',`att5`='0612054427',`attf102`='20250518',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250518',`att19`='46.607311',`att20`='-1.829707',`attf100`='1',`attdatmod`='202505182048',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3182') AND (id_type = '80') LIMIT 1
UID:--204858-- UPDATE `tier_att` SET `id_work`='259',`att3`='Jean-Pierre',`att1`='Valadas',`att8`='non_défini',`att12`='valadasjp@gmail.com',`att14`='4 Rue du Lux en Roc, Brem-sur-Mer, France',`att7`='85470',`att17`='Brem-sur-Mer',`att18`='France',`att5`='0612054427',`attf102`='20250518',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250518',`att19`='46.607311',`att20`='-1.829707',`attf100`='1',`attdatmod`='202505182048',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3182') AND (id_type = '80') LIMIT 1
UID:--204858-- UPDATE `tier_att` SET `id_work`='259',`att3`='Jean-Pierre',`att1`='Valadas',`att8`='non_défini',`att12`='valadasjp@gmail.com',`att14`='4 Rue du Lux en Roc, Brem-sur-Mer, France',`att7`='85470',`att17`='Brem-sur-Mer',`att18`='France',`att5`='0612054427',`attf102`='20250518',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250518',`att19`='46.607311',`att20`='-1.829707',`attf100`='1',`att6`='0612054427',`attdatmod`='202505182048',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3182') AND (id_type = '80') LIMIT 1
UID:--204858-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Valadas',`att2`='3182',`attf100`='20250518',`att8`='1603',`att6`='0',`att9`='3183',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505182048',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '471') AND (id_type = '148') LIMIT 1
UID:--212008--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:--212008--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre