UID:--002633--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:--002633--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--101723-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505111017' ) UID:--101723-- UPDATE `tier_att` SET `id_work`='259',`att3`='francine',`att1`='lorrain',`att8`='non_défini',`att12`='francinelorrain@live.fr',`att14`='25B Rue Du Renaulrupt',`att7`='57155',`att17`='MARLY',`att18`='France',`att5`='0660358343',`attf102`='20250511',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250511',`attdatmod`='202505111017',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3081') AND (id_type = '80') LIMIT 1 UID:--101723-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3081','202505111017','202505111017' ) UID:--101723-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='25B Rue Du Renaulrupt',`lig4`='57155',`lig5`='MARLY',`lig6`='France',`ligdatmod`='202505111017',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3081') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1552') LIMIT 1 UID:--101723-- UPDATE `tier_att` SET `id_work`='259',`att3`='francine',`att1`='lorrain',`att8`='non_défini',`att12`='francinelorrain@live.fr',`att14`='25B Rue Du Renaulrupt',`att7`='57155',`att17`='MARLY',`att18`='France',`att5`='0660358343',`attf102`='20250511',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250511',`att19`='49.065592',`att20`='6.151298',`attf100`='1',`attdatmod`='202505111017',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3081') AND (id_type = '80') LIMIT 1 UID:--101723-- UPDATE `tier_att` SET `id_work`='259',`att3`='francine',`att1`='lorrain',`att8`='non_défini',`att12`='francinelorrain@live.fr',`att14`='25B Rue Du Renaulrupt',`att7`='57155',`att17`='MARLY',`att18`='France',`att5`='0660358343',`attf102`='20250511',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250511',`att19`='49.065592',`att20`='6.151298',`attf100`='1',`attdatmod`='202505111017',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3081') AND (id_type = '80') LIMIT 1 UID:--101723-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505111017' ) UID:--101723-- UPDATE `tier_att` SET `id_work`='367',`att2`='lorrain',`att3`='francine',`att5`='0660358343',`att6`='francinelorrain@live.fr',`att8`='3081',`att10`='[IDMYUSER]',`attdatmod`='202505111017',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3082') AND (id_type = '149') LIMIT 1 UID:--101723-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505111017' ) UID:--101723-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-',`att2`='3081',`attf100`='20250511',`att8`='1552',`att6`='[IDMYUSER]',`att9`='3082',`att3`='§terrasse§',`attdatmod`='202505111017',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '327') AND (id_type = '148') LIMIT 1 UID:--101723-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-lorrain',`att2`='3081',`attf100`='20250511',`att8`='1552',`att6`='[IDMYUSER]',`att9`='3082',`att3`='§terrasse§',`attdatmod`='202505111017',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '327') AND (id_type = '148') LIMIT 1 UID:--101723-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-lorrain',`att2`='3081',`attf100`='20250511',`att8`='1552',`att6`='[IDMYUSER]',`att9`='3082',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505111017',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '327') AND (id_type = '148') LIMIT 1 UID:--101723-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-lorrain',`att2`='3081',`attf100`='20250511',`att8`='1552',`att6`='0',`att9`='3082',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505111017',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '327') AND (id_type = '148') LIMIT 1 UID:--101723-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250511','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-lorrain','\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-lorrain

\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:--101723-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '218') LIMIT 1 UID:--101723--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:--101723-- UPDATE `tier_att` SET `id_work`='367',`att2`='lorrain',`att3`='francine',`att5`='0660358343',`att6`='francinelorrain@live.fr',`att8`='3081',`att10`='[IDMYUSER]',`att4`='0660358343',`attdatmod`='202505111017',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3082') AND (id_type = '149') LIMIT 1 UID:--101723-- UPDATE `tier_att` SET `id_work`='259',`att3`='francine',`att1`='lorrain',`att8`='non_défini',`att12`='francinelorrain@live.fr',`att14`='25B Rue Du Renaulrupt',`att7`='57155',`att17`='MARLY',`att18`='France',`att5`='0660358343',`attf102`='20250511',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250511',`att19`='49.065592',`att20`='6.151298',`attf100`='1',`attdatmod`='202505111017',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3081') AND (id_type = '80') LIMIT 1 UID:--101723-- UPDATE `tier_att` SET `id_work`='259',`att3`='francine',`att1`='lorrain',`att8`='non_défini',`att12`='francinelorrain@live.fr',`att14`='25B Rue Du Renaulrupt',`att7`='57155',`att17`='MARLY',`att18`='France',`att5`='0660358343',`attf102`='20250511',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250511',`att19`='49.065592',`att20`='6.151298',`attf100`='1',`attdatmod`='202505111017',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3081') AND (id_type = '80') LIMIT 1 UID:--101723-- UPDATE `tier_att` SET `id_work`='259',`att3`='francine',`att1`='lorrain',`att8`='non_défini',`att12`='francinelorrain@live.fr',`att14`='25B Rue Du Renaulrupt',`att7`='57155',`att17`='MARLY',`att18`='France',`att5`='0660358343',`attf102`='20250511',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250511',`att19`='49.065592',`att20`='6.151298',`attf100`='1',`att6`='0660358343',`attdatmod`='202505111017',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3081') AND (id_type = '80') LIMIT 1 UID:--101723-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-lorrain',`att2`='3081',`attf100`='20250511',`att8`='1552',`att6`='0',`att9`='3082',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202505111017',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '327') AND (id_type = '148') LIMIT 1 UID:--132011--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:--132011--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--184508--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:--184508--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--192058-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505111920' ) UID:--192058-- UPDATE `tier_att` SET `id_work`='259',`att3`='Jorge',`att1`='De vasconcelos',`att8`='non_défini',`att12`='margotte75@orange.fr',`att14`='301 rie du gras',`att7`='88800',`att17`='Parey sous montfort',`att18`='France',`att5`='0638466209',`attf102`='20250511',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250511',`attdatmod`='202505111920',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3083') AND (id_type = '80') LIMIT 1 UID:--192058-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3083','202505111920','202505111920' ) UID:--192058-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='301 rie du gras',`lig4`='88800',`lig5`='Parey sous montfort',`lig6`='France',`ligdatmod`='202505111920',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3083') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1553') LIMIT 1 UID:--192058-- UPDATE `tier_att` SET `id_work`='259',`att3`='Jorge',`att1`='De vasconcelos',`att8`='non_défini',`att12`='margotte75@orange.fr',`att14`='301 rie du gras',`att7`='88800',`att17`='Parey sous montfort',`att18`='France',`att5`='0638466209',`attf102`='20250511',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250511',`att19`='48.253495',`att20`='5.945252',`attf100`='1',`attdatmod`='202505111920',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3083') AND (id_type = '80') LIMIT 1 UID:--192058-- UPDATE `tier_att` SET `id_work`='259',`att3`='Jorge',`att1`='De vasconcelos',`att8`='non_défini',`att12`='margotte75@orange.fr',`att14`='301 rie du gras',`att7`='88800',`att17`='Parey sous montfort',`att18`='France',`att5`='0638466209',`attf102`='20250511',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250511',`att19`='48.253495',`att20`='5.945252',`attf100`='1',`attdatmod`='202505111920',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3083') AND (id_type = '80') LIMIT 1 UID:--192058-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505111920' ) UID:--192058-- UPDATE `tier_att` SET `id_work`='367',`att2`='De vasconcelos',`att3`='Jorge',`att5`='0638466209',`att6`='margotte75@orange.fr',`att8`='3083',`att10`='[IDMYUSER]',`attdatmod`='202505111920',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3084') AND (id_type = '149') LIMIT 1 UID:--192058-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505111920' ) UID:--192058-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-',`att2`='3083',`attf100`='20250511',`att8`='1553',`att6`='[IDMYUSER]',`att9`='3084',`att3`='§toiture§',`attdatmod`='202505111920',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '328') AND (id_type = '148') LIMIT 1 UID:--192058-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-De vasconcelos',`att2`='3083',`attf100`='20250511',`att8`='1553',`att6`='[IDMYUSER]',`att9`='3084',`att3`='§toiture§',`attdatmod`='202505111920',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '328') AND (id_type = '148') LIMIT 1 UID:--192058-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-De vasconcelos',`att2`='3083',`attf100`='20250511',`att8`='1553',`att6`='[IDMYUSER]',`att9`='3084',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505111920',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '328') AND (id_type = '148') LIMIT 1 UID:--192058-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-De vasconcelos',`att2`='3083',`attf100`='20250511',`att8`='1553',`att6`='0',`att9`='3084',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505111920',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '328') AND (id_type = '148') LIMIT 1 UID:--192058-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250511','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-De vasconcelos','\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-De vasconcelos

\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:--192058-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '219') LIMIT 1 UID:--192058--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:--192058-- UPDATE `tier_att` SET `id_work`='367',`att2`='De vasconcelos',`att3`='Jorge',`att5`='0638466209',`att6`='margotte75@orange.fr',`att8`='3083',`att10`='[IDMYUSER]',`att4`='0638466209',`attdatmod`='202505111920',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3084') AND (id_type = '149') LIMIT 1 UID:--192058-- UPDATE `tier_att` SET `id_work`='259',`att3`='Jorge',`att1`='De vasconcelos',`att8`='non_défini',`att12`='margotte75@orange.fr',`att14`='301 rie du gras',`att7`='88800',`att17`='Parey sous montfort',`att18`='France',`att5`='0638466209',`attf102`='20250511',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250511',`att19`='48.253495',`att20`='5.945252',`attf100`='1',`attdatmod`='202505111920',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3083') AND (id_type = '80') LIMIT 1 UID:--192058-- UPDATE `tier_att` SET `id_work`='259',`att3`='Jorge',`att1`='De vasconcelos',`att8`='non_défini',`att12`='margotte75@orange.fr',`att14`='301 rie du gras',`att7`='88800',`att17`='Parey sous montfort',`att18`='France',`att5`='0638466209',`attf102`='20250511',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250511',`att19`='48.253495',`att20`='5.945252',`attf100`='1',`attdatmod`='202505111920',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3083') AND (id_type = '80') LIMIT 1 UID:--192058-- UPDATE `tier_att` SET `id_work`='259',`att3`='Jorge',`att1`='De vasconcelos',`att8`='non_défini',`att12`='margotte75@orange.fr',`att14`='301 rie du gras',`att7`='88800',`att17`='Parey sous montfort',`att18`='France',`att5`='0638466209',`attf102`='20250511',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250511',`att19`='48.253495',`att20`='5.945252',`attf100`='1',`att6`='0638466209',`attdatmod`='202505111920',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3083') AND (id_type = '80') LIMIT 1 UID:--192058-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-De vasconcelos',`att2`='3083',`attf100`='20250511',`att8`='1553',`att6`='0',`att9`='3084',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505111920',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '328') AND (id_type = '148') LIMIT 1 UID:--204728--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:--204728--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--205939--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:--205939--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre