UID:--004411-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202506100044' )
UID:--004411-- UPDATE `tier_att` SET `id_work`='259',`att3`='Martine',`att1`='Rominger',`att8`='non_défini',`att12`='martine.rominger@sfr.fr',`att14`='4 Rue de Berne, Lingolsheim, France',`att7`='67380',`att17`='Lingolsheim',`att18`='France',`att5`='+330619574826',`attf102`='20250610',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250610',`att26`='',`attdatmod`='202506100044',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3406') AND (id_type = '80') LIMIT 1
UID:--004411-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3406','202506100044','202506100044' )
UID:--004411-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='4 Rue de Berne, Lingolsheim, France',`lig4`='67380',`lig5`='Lingolsheim',`lig6`='France',`ligdatmod`='202506100044',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3406') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1710') LIMIT 1
UID:--004411-- UPDATE `tier_att` SET `id_work`='259',`att3`='Martine',`att1`='Rominger',`att8`='non_défini',`att12`='martine.rominger@sfr.fr',`att14`='4 Rue de Berne, Lingolsheim, France',`att7`='67380',`att17`='Lingolsheim',`att18`='France',`att5`='+330619574826',`attf102`='20250610',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250610',`att26`='',`att19`='48.565867',`att20`='7.695132',`attf100`='1',`attdatmod`='202506100044',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3406') AND (id_type = '80') LIMIT 1
UID:--004411-- UPDATE `tier_att` SET `id_work`='259',`att3`='Martine',`att1`='Rominger',`att8`='non_défini',`att12`='martine.rominger@sfr.fr',`att14`='4 Rue de Berne, Lingolsheim, France',`att7`='67380',`att17`='Lingolsheim',`att18`='France',`att5`='+330619574826',`attf102`='20250610',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250610',`att26`='',`att19`='48.565867',`att20`='7.695132',`attf100`='1',`attdatmod`='202506100044',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3406') AND (id_type = '80') LIMIT 1
UID:--004411-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202506100044' )
UID:--004411-- UPDATE `tier_att` SET `id_work`='367',`att2`='Rominger',`att3`='Martine',`att5`='+330619574826',`att6`='martine.rominger@sfr.fr',`att8`='3406',`att10`='[IDMYUSER]',`attdatmod`='202506100044',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3407') AND (id_type = '149') LIMIT 1
UID:--004411-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202506100044' )
UID:--004411-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-',`att2`='3406',`att90`='Ça serait pour le nettoyage des dalles de la terrasse ( ~15m©)\r\nPouvez vous me donner un devis ?\r\nMerci d'avance',`attf100`='20250610',`att8`='1710',`att6`='[IDMYUSER]',`att9`='3407',`att3`='§terrasse§',`attdatmod`='202506100044',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '741') AND (id_type = '148') LIMIT 1
UID:--004411-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Rominger',`att2`='3406',`att90`='Ça serait pour le nettoyage des dalles de la terrasse ( ~15m©)\r\nPouvez vous me donner un devis ?\r\nMerci d'avance',`attf100`='20250610',`att8`='1710',`att6`='[IDMYUSER]',`att9`='3407',`att3`='§terrasse§',`attdatmod`='202506100044',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '741') AND (id_type = '148') LIMIT 1
UID:--004411-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Rominger',`att2`='3406',`att90`='Ça serait pour le nettoyage des dalles de la terrasse ( ~15m©)\r\nPouvez vous me donner un devis ?\r\nMerci d'avance',`attf100`='20250610',`att8`='1710',`att6`='[IDMYUSER]',`att9`='3407',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202506100044',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '741') AND (id_type = '148') LIMIT 1
UID:--004411-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Rominger',`att2`='3406',`att90`='Ça serait pour le nettoyage des dalles de la terrasse ( ~15m©)\r\nPouvez vous me donner un devis ?\r\nMerci d'avance',`attf100`='20250610',`att8`='1710',`att6`='0',`att9`='3407',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202506100044',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '741') AND (id_type = '148') LIMIT 1
UID:--004411-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250610','','1','','Exteco','contact@exteco.fr','','','Exteco - Nouvelle opportunité - OPP-Rominger','\r\n\r\n
\n Rainea Exteco Metz
\n
\n 10 Rue Rochambeau
\n 57000 Metz
\n
<',`att16`=' 19 rue des Millefeuilles 57190 Florange',`att18`='0',`att29`='3290',`att24`='3619',`att25`='19 rue des Millefeuilles',`att26`='',`att27`='57190',`att28`='Florange',`attdatmod`='202506101306',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '745') AND (id_type = '168') LIMIT 1
UID:--130656-- UPDATE `vent_att` SET `newobj`='new' WHERE 1=1 AND (id_type = '168') AND (id_vent = '745') LIMIT 1
UID:--130656-- UPDATE `tier_lig` SET `lig2`='19',`ligdatmod`='202506101306',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '8') LIMIT 1
UID:--130656-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-METZ-19',`att3`='',`att2`='Maison individuelle - Terrasse & Panneaux Photovoltaique - Florange',`att90`='jwqklglu0hcj76he',`attf100`='20250604',`att5`='3364',`att8`='8',`att9`='3290',`att10`='329',`att11`='3619',`att13`='',`att14`='702',`att15`='\n Rainea Exteco Metz
\n
\n 10 Rue Rochambeau
\n 57000 Metz
\n
<',`att16`=' 19 rue des Millefeuilles 57190 Florange',`att18`='0',`att29`='3290',`att24`='3619',`att25`='19 rue des Millefeuilles',`att26`='',`att27`='57190',`att28`='Florange',`attdatmod`='202506101306',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '745') AND (id_type = '168') LIMIT 1
UID:--130656-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','745','202506101306','202506101306' )
UID:--130656-- UPDATE `vent_lig` SET `actif`='1',`lig1`='122',`lig7`='270.00',`lig9`='122',`lig16`='M2',`lig22`='Terrasse',`lig91`='Terrasse
Nettoyage et désinfection du support via un procédé vapeur basse pression
',`lig3`='150',`lig2`='18.00',`lig5`='10',`lig4`='2700.00',`lig8`='2970.00',`lig10`='euro',`lig6`='2970.00',`lig90`='<p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`ligdatmod`='202506101306',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '745') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '1360') LIMIT 1
UID:--130656-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','745','202506101306','202506101306' )
UID:--130656-- UPDATE `vent_lig` SET `actif`='1',`lig1`='146',`lig7`='59.00',`lig9`='146',`lig16`='Unite',`lig22`='Panneaux Photovoltaiques',`lig91`='Panneaux Photovoltaiques
Nettoyage des panneaux photovoltaïques
',`lig3`='1',`lig2`='590.00',`lig5`='10',`lig4`='590.00',`lig8`='649.00',`lig10`='euro',`lig6`='649.00',`lig90`='<p>Nettoyage des panneaux photovoltaïques</p>',`ligdatmod`='202506101306',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '745') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '1361') LIMIT 1
UID:--130657-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('278','1','2','Devis_DV-METZ-69_04_06_2025_16h_36m_signe.pdf','20250610','768','devis_signe','168','745','-2','-1','' )
UID:--130657-- UPDATE `file` SET `size`='557808' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '865') LIMIT 1
UID:--130657-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('279','1','2','Attestation_fiscale_DV_METZ_69_04_06_2025_16h_34m_signe.pdf','20250610','598','attestation_signe','168','745','-2','-1','' )
UID:--130657-- UPDATE `file` SET `size`='854606' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '866') LIMIT 1
UID:--130657-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250610','','1','contact@exteco.fr','Exteco','said-boutlioua@wanadoo.fr','','','Merci pour votre commande : Devis N°DV-METZ-69','\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 Merci pour votre commande (Devis N° DV-METZ-69)\r\n \r\n\r\n \r\n Bonjour monsieur BOUTLIOUA,
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 \r\n\r\n \r\n | \r\n
\r\n
\r\n','/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/865-278-768-1§Devis_DV-METZ-69_04_06_2025_16h_36m_signe.pdf;/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/866-279-598-1§Attestation_fiscale_DV_METZ_69_04_06_2025_16h_34m_signe.pdf','0','v2017b' )
UID:--130657-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '643') LIMIT 1
UID:--130657-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250610','','1','contact@exteco.fr','Exteco','agence-metz@exteco.fr','','','Devis signé - N° DV-METZ-69','\r\n\r\nDevis signé\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 Devis signé (Devis N° DV-METZ-69)\r\n \r\n\r\n \r\n Bonjour,
Le devis n°DV-METZ-69 de a été signé électroniquement.
\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 \r\n\r\n \r\n | \r\n
\r\n
','','0','v2017b' )
UID:--130657-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '644') LIMIT 1
UID:--130657-- UPDATE `vent_lig` SET `lig1`='122',`lig7`='270.00',`lig9`='122',`lig16`='M2',`lig22`='Terrasse',`lig91`='Terrasse
Nettoyage et désinfection du support via un procédé vapeur basse pression
',`lig3`='150',`lig2`='18.00',`lig5`='10',`lig4`='2700.00',`lig8`='2970.00',`lig10`='euro',`lig6`='2970.00',`lig90`='<p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`ligdatmod`='202506101306',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '745') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '1360') LIMIT 1
UID:--130657-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-METZ-19',`att3`='',`att2`='Maison individuelle - Terrasse & Panneaux Photovoltaique - Florange',`att90`='jwqklglu0hcj76he',`attf100`='20250604',`att5`='3364',`att8`='8',`att9`='3290',`att10`='329',`att11`='3619',`att13`='',`att14`='702',`att15`='\n Rainea Exteco Metz
\n
\n 10 Rue Rochambeau
\n 57000 Metz
\n
<',`att16`=' 19 rue des Millefeuilles 57190 Florange',`att18`='0',`att29`='3290',`att24`='3619',`att25`='19 rue des Millefeuilles',`att26`='',`att27`='57190',`att28`='Florange',`att31`='329',`attdatmod`='202506101306',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '745') AND (id_type = '168') LIMIT 1
UID:--130657-- UPDATE `vent_att` SET `id_work`='417',`att4`='6',`attdatmod`='202506101306',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '701') AND (id_type = '148') LIMIT 1
UID:--130657-- UPDATE `vent_att` SET `id_work`='412',`attf107`='202506101306',`attdatmod`='202506101306',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '702') AND (id_type = '165') LIMIT 1
UID:--130657-- UPDATE `tier_att` SET `id_work`='205',`att26`='',`attdatmod`='202506101306',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3364') AND (id_type = '80') LIMIT 1
UID:--132322--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:--132322--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--142909--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:--142909--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:3--151749--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:3--151749--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--160735--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:--160735--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--162500--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)
ORDER BY pm.ordre
UID:--162500--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--162920--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:--162920--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--163753--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)
ORDER BY pm.ordre
UID:1--163753--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--165347--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)
ORDER BY pm.ordre
UID:1--165347--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--165612--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)
ORDER BY pm.ordre
UID:1--165612--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--170157--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)
ORDER BY pm.ordre
UID:1--170157--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--170712--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)
ORDER BY pm.ordre
UID:1--170712--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--170835--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:--170835--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--170857--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)
ORDER BY pm.ordre
UID:--170857--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--171404--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)
ORDER BY pm.ordre
UID:1--171404--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--171604--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)
ORDER BY pm.ordre
UID:1--171604--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--171720-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202506101717' )
UID:--171720-- UPDATE `tier_att` SET `id_work`='259',`att3`='TEST',`att1`='TOOSMART',`att8`='non_défini',`att12`='test1006@toosmart.fr',`att14`='33 Rue Paul Duvivier, Lyon, France',`att7`='69007',`att17`='Lyon',`att18`='France',`att5`='0102030405',`attf102`='20250610',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250610',`att26`='',`attdatmod`='202506101717',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3416') AND (id_type = '80') LIMIT 1
UID:--171720-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3416','202506101717','202506101717' )
UID:--171720-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='33 Rue Paul Duvivier, Lyon, France',`lig4`='69007',`lig5`='Lyon',`lig6`='France',`ligdatmod`='202506101717',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3416') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1715') LIMIT 1
UID:--171720-- UPDATE `tier_att` SET `id_work`='259',`att3`='TEST',`att1`='TOOSMART',`att8`='non_défini',`att12`='test1006@toosmart.fr',`att14`='33 Rue Paul Duvivier, Lyon, France',`att7`='69007',`att17`='Lyon',`att18`='France',`att5`='0102030405',`attf102`='20250610',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250610',`att26`='',`att19`='45.741567',`att20`='4.848298',`attf100`='1',`attdatmod`='202506101717',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3416') AND (id_type = '80') LIMIT 1
UID:--171720-- UPDATE `tier_att` SET `id_work`='259',`att3`='TEST',`att1`='TOOSMART',`att8`='non_défini',`att12`='test1006@toosmart.fr',`att14`='33 Rue Paul Duvivier, Lyon, France',`att7`='69007',`att17`='Lyon',`att18`='France',`att5`='0102030405',`attf102`='20250610',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250610',`att26`='',`att19`='45.741567',`att20`='4.848298',`attf100`='1',`attdatmod`='202506101717',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3416') AND (id_type = '80') LIMIT 1
UID:--171720-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202506101717' )
UID:--171720-- UPDATE `tier_att` SET `id_work`='367',`att2`='TOOSMART',`att3`='TEST',`att5`='0102030405',`att6`='test1006@toosmart.fr',`att8`='3416',`att10`='[IDMYUSER]',`attdatmod`='202506101717',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3417') AND (id_type = '149') LIMIT 1
UID:--171720-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202506101717' )
UID:--171720-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-',`att2`='3416',`att90`='TEST TOOSMART NE PAS EFFECTUER D'ACTION',`attf100`='20250610',`att8`='1715',`att6`='[IDMYUSER]',`att9`='3417',`att3`='§autres§',`attdatmod`='202506101717',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '746') AND (id_type = '148') LIMIT 1
UID:--171720-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-TOOSMART',`att2`='3416',`att90`='TEST TOOSMART NE PAS EFFECTUER D'ACTION',`attf100`='20250610',`att8`='1715',`att6`='[IDMYUSER]',`att9`='3417',`att3`='§autres§',`attdatmod`='202506101717',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '746') AND (id_type = '148') LIMIT 1
UID:--171720-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-TOOSMART',`att2`='3416',`att90`='TEST TOOSMART NE PAS EFFECTUER D'ACTION',`attf100`='20250610',`att8`='1715',`att6`='[IDMYUSER]',`att9`='3417',`att3`='§autres§',`att5`='',`att10`='non_défini',`attdatmod`='202506101717',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '746') AND (id_type = '148') LIMIT 1
UID:--171720-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-TOOSMART',`att2`='3416',`att90`='TEST TOOSMART NE PAS EFFECTUER D'ACTION',`attf100`='20250610',`att8`='1715',`att6`='0',`att9`='3417',`att3`='§autres§',`att5`='',`att10`='non_défini',`attdatmod`='202506101717',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '746') AND (id_type = '148') LIMIT 1
UID:--171720-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250610','','1','','Exteco','contact@exteco.fr','','','Exteco - Nouvelle opportunité - OPP-TOOSMART','\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-TOOSMART \r\n\r\n \r\n Bonjour Exteco, Vous avez reçu une nouvelle demande de contact.
Coordonnées du contact : Nom : TOOSMART Prénom : TEST Téléphone : 0102030405 Mail : test1006@toosmart.fr Service : autres Adresse : 33 Rue Paul Duvivier, Lyon, France Code Postal : 69007 Ville : Lyon Message : TEST TOOSMART NE PAS EFFECTUER D'ACTION
Bonne prise de contact !
\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:--171720-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '645') LIMIT 1
UID:--171720--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:--171720-- UPDATE `tier_att` SET `id_work`='367',`att2`='TOOSMART',`att3`='TEST',`att5`='0102030405',`att6`='test1006@toosmart.fr',`att8`='3416',`att10`='[IDMYUSER]',`att4`='0102030405',`attdatmod`='202506101717',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3417') AND (id_type = '149') LIMIT 1
UID:--171720-- UPDATE `tier_att` SET `id_work`='259',`att3`='TEST',`att1`='TOOSMART',`att8`='non_défini',`att12`='test1006@toosmart.fr',`att14`='33 Rue Paul Duvivier, Lyon, France',`att7`='69007',`att17`='Lyon',`att18`='France',`att5`='0102030405',`attf102`='20250610',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250610',`att26`='',`att19`='45.741567',`att20`='4.848298',`attf100`='1',`attdatmod`='202506101717',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3416') AND (id_type = '80') LIMIT 1
UID:--171720-- UPDATE `tier_att` SET `id_work`='259',`att3`='TEST',`att1`='TOOSMART',`att8`='non_défini',`att12`='test1006@toosmart.fr',`att14`='33 Rue Paul Duvivier, Lyon, France',`att7`='69007',`att17`='Lyon',`att18`='France',`att5`='0102030405',`attf102`='20250610',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250610',`att26`='',`att19`='45.741567',`att20`='4.848298',`attf100`='1',`attdatmod`='202506101717',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3416') AND (id_type = '80') LIMIT 1
UID:--171720-- UPDATE `tier_att` SET `id_work`='259',`att3`='TEST',`att1`='TOOSMART',`att8`='non_défini',`att12`='test1006@toosmart.fr',`att14`='33 Rue Paul Duvivier, Lyon, France',`att7`='69007',`att17`='Lyon',`att18`='France',`att5`='0102030405',`attf102`='20250610',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250610',`att26`='',`att19`='45.741567',`att20`='4.848298',`attf100`='1',`att6`='0102030405',`attdatmod`='202506101717',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3416') AND (id_type = '80') LIMIT 1
UID:--171720-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-TOOSMART',`att2`='3416',`att90`='TEST TOOSMART NE PAS EFFECTUER D'ACTION',`attf100`='20250610',`att8`='1715',`att6`='0',`att9`='3417',`att3`='§autres§',`att5`='',`att10`='non_défini',`attdatmod`='202506101717',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '746') AND (id_type = '148') LIMIT 1
UID:--185153--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:--185153--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:10--193800--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--193800--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre