UID:--141118--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:--141118--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:6--142023--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('1151','1','2','DEVIS MR CLEMENT.pdf','20250705','604','6','-3','-2') UID:6--142023--UPDATE `file` SET `last`='1' , `size`='1357623' , `fol_id`='2' , `esp_id`='1' WHERE file_id=1579 UID:6--142023--UPDATE `file` SET `id_type`='165' , `id_obje`='981' , `specif`='' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=1579 UID:6--142023--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=1579 UID:6--142023--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1 UID:6--142023--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','6','2','1579','1151','DEVIS MR CLEMENT.pdf','1','20250705','14:20:23','upload') UID:--223012-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202507052230' ) UID:--223012-- UPDATE `tier_att` SET `id_work`='259',`att3`='Ludovic',`att1`='Joie',`att8`='non_défini',`att12`='ludovic.joie@hotmail.fr',`att14`='9 Impasse des Hirondelles',`att7`='57640',`att17`='Argancy',`att18`='France',`att5`='0620234873',`attf102`='20250705',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250705',`att26`='',`attdatmod`='202507052230',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3663') AND (id_type = '80') LIMIT 1 UID:--223013-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3663','202507052230','202507052230' ) UID:--223013-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='9 Impasse des Hirondelles',`lig4`='57640',`lig5`='Argancy',`lig6`='France',`ligdatmod`='202507052230',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3663') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1840') LIMIT 1 UID:--223013-- UPDATE `tier_att` SET `id_work`='259',`att3`='Ludovic',`att1`='Joie',`att8`='non_défini',`att12`='ludovic.joie@hotmail.fr',`att14`='9 Impasse des Hirondelles',`att7`='57640',`att17`='Argancy',`att18`='France',`att5`='0620234873',`attf102`='20250705',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250705',`att26`='',`att19`='49.194158',`att20`='6.20328',`attf100`='1',`attdatmod`='202507052230',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3663') AND (id_type = '80') LIMIT 1 UID:--223013-- UPDATE `tier_att` SET `id_work`='259',`att3`='Ludovic',`att1`='Joie',`att8`='non_défini',`att12`='ludovic.joie@hotmail.fr',`att14`='9 Impasse des Hirondelles',`att7`='57640',`att17`='Argancy',`att18`='France',`att5`='0620234873',`attf102`='20250705',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250705',`att26`='',`att19`='49.194158',`att20`='6.20328',`attf100`='1',`attdatmod`='202507052230',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3663') AND (id_type = '80') LIMIT 1 UID:--223013-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202507052230' ) UID:--223013-- UPDATE `tier_att` SET `id_work`='367',`att2`='Joie',`att3`='Ludovic',`att5`='0620234873',`att6`='ludovic.joie@hotmail.fr',`att8`='3663',`att10`='[IDMYUSER]',`attdatmod`='202507052230',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3664') AND (id_type = '149') LIMIT 1 UID:--223013-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202507052230' ) UID:--223013-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-',`att2`='3663',`att90`='Nettoyage et imperméabilisation de toiture',`attf100`='20250705',`att8`='1840',`att6`='[IDMYUSER]',`att9`='3664',`att3`='§toiture§',`attdatmod`='202507052230',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '1073') AND (id_type = '148') LIMIT 1 UID:--223013-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Joie',`att2`='3663',`att90`='Nettoyage et imperméabilisation de toiture',`attf100`='20250705',`att8`='1840',`att6`='[IDMYUSER]',`att9`='3664',`att3`='§toiture§',`attdatmod`='202507052230',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '1073') AND (id_type = '148') LIMIT 1 UID:--223013-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Joie',`att2`='3663',`att90`='Nettoyage et imperméabilisation de toiture',`attf100`='20250705',`att8`='1840',`att6`='[IDMYUSER]',`att9`='3664',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202507052230',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '1073') AND (id_type = '148') LIMIT 1 UID:--223013-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Joie',`att2`='3663',`att90`='Nettoyage et imperméabilisation de toiture',`attf100`='20250705',`att8`='1840',`att6`='0',`att9`='3664',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202507052230',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '1073') AND (id_type = '148') LIMIT 1 UID:--223013-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250705','','1','','Exteco','contact@exteco.fr','','','Exteco - Nouvelle opportunité - OPP-Joie','\r\n\r\n
| \r\n\r\n \r\n\r\n \r\n \r\n
| \r\n