UID:--072451--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:--072452--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--073531--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:--073531--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--074056--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:--074057--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1617--081614--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:1617--081614--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--103920-- UPDATE  `vent_att`  SET `id_work`='417',`att4`='1',`attdatmod`='202509191039',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '4630')  AND (id_type = '148')  LIMIT 1 
UID:--103920-- UPDATE  `vent_att`  SET `id_work`='412',`attf107`='202509191039',`attdatmod`='202509191039',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '4632')  AND (id_type = '165')  LIMIT 1 
UID:--103920-- UPDATE  `tier_att`  SET `id_work`='205',`attdatmod`='202509191039',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '16865')  AND (id_type = '80')  LIMIT 1 
UID:--103920-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202509191039' )
UID:--103920-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='RECUPERATION EAUX DE PLUIE',`att90`='h4f5bizrcq5z0lkj',`attf100`='20250919',`att5`='16865',`att8`='1608',`att9`='5960',`att10`='596',`att11`='6556',`att13`='virement',`att14`='4632',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Rainéa Seine &amp; Marne sud</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>45 avenue AnnaLindh<br>\n                    77240 VERT SAINT DENIS</',`att16`='3 rue des petits bois 77310 PRINGY',`att18`='0',`att29`='5960',`att24`='6556',`att25`='3 rue des petits bois',`att26`='',`att27`='77310',`att28`='PRINGY',`attdatmod`='202509191039',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '4637')  AND (id_type = '168')  LIMIT 1 
UID:--103920-- UPDATE  `vent_att`  SET `newobj`='new'  WHERE 1=1  AND (id_type = '168')  AND (id_vent = '4637')  LIMIT 1 
UID:--103920-- UPDATE  `tier_lig`  SET `lig2`='2',`ligdatmod`='202509191039',`ligusermod`='1586'  WHERE 1=1  AND ( id_tier = '178')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '97')  LIMIT 1 
UID:--103920-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CMD-SEM-2',`att3`='',`att2`='RECUPERATION EAUX DE PLUIE',`att90`='h4f5bizrcq5z0lkj',`attf100`='20250919',`att5`='16865',`att8`='1608',`att9`='5960',`att10`='596',`att11`='6556',`att13`='virement',`att14`='4632',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Rainéa Seine &amp; Marne sud</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>45 avenue AnnaLindh<br>\n                    77240 VERT SAINT DENIS</',`att16`='3 rue des petits bois 77310 PRINGY',`att18`='0',`att29`='5960',`att24`='6556',`att25`='3 rue des petits bois',`att26`='',`att27`='77310',`att28`='PRINGY',`attdatmod`='202509191039',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '4637')  AND (id_type = '168')  LIMIT 1 
UID:--103920-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','4637','202509191039','202509191039' )
UID:--103920-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='4960',`lig9`='4960',`lig91`='<b>CUVE CLASSIQUE EPARCO EDP REUTILISATION EXT 05m3</b><br /><p><b>Fourniture et mise en service d\'une cuve de récupération d\'eau de pluie EPARCO 5m3 pour réutilisation extérieure comprenant :</b></p><p><br></p><p>- Une cuve PE 5m3.</p><p>- Un couvercle passage piéton.</p><p>- Un filtre autonettoyant et sa grille de filtration.</p><p>- Une protection anti moustique.</p><p>- Une arrivée d\'eau tranquille.</p><p>- Un kit pompe.</p><p> </p><p>- Cuve garantie 10 ans</p><p>- Eléments électromécaniques garantis 2 ans</p><p><br></p><p><br></p><p><b><br></b></p><p><b><br></b></p><p><b><br></b></p>',`lig3`='1',`lig2`='2960.00',`lig5`='10',`lig4`='2960.00',`lig8`='3256.00',`lig10`='euro',`lig6`='3256.00',`lig90`='&lt;p&gt;&lt;b&gt;Fourniture et mise en service d\'une cuve de récupération d\'eau de pluie EPARCO 5m3 pour réutilisation extérieure comprenant :&lt;/b&gt;&lt;/p&gt;&lt;p&gt;&lt;br&gt;&lt;/p&gt;&lt;p&gt;- Une cuve PE 5m3.&lt;/p&gt;&lt;p&gt;- Un couvercle passage piéton.&lt;/p&gt;&lt;p&gt;- Un filtre autonettoyant et sa grille de filtration.&lt;/p&gt;&lt;p&gt;- Une protection anti moustique.&lt;/p&gt;&lt;p&gt;- Une arrivée d\'eau tranquille.&lt;/p&gt;&lt;p&gt;- Un kit pompe.&lt;/p&gt;&lt;p&gt; &lt;/p&gt;&lt;p&gt;- Cuve garantie 10 ans&lt;/p&gt;&lt;p&gt;- Eléments électromécaniques garantis 2 ans&lt;/p&gt;&lt;p&gt;&lt;br&gt;&lt;/p&gt;&lt;p&gt;&lt;br&gt;&lt;/p&gt;&lt;p&gt;&lt;b&gt;&lt;br&gt;&lt;/b&gt;&lt;/p&gt;&lt;p&gt;&lt;b&gt;&lt;br&gt;&lt;/b&gt;&lt;/p&gt;&lt;p&gt;&lt;b&gt;&lt;br&gt;&lt;/b&gt;&lt;/p&gt;',`ligdatmod`='202509191039',`ligusermod`='1586'  WHERE 1=1  AND ( id_vent = '4637')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '9517')  LIMIT 1 
UID:--103920-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','4637','202509191039','202509191039' )
UID:--103920-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='5778',`lig9`='5778',`lig91`='<b>FORFAIT POSE RECUP DE PLUIE</b><br /><p><span style=\"font-size: 14px;\"><b>Mise en place d\'une cuve de récupération des eaux de pluie, prestation comprenant :</b></span></p><p><span style=\"font-size: 14px;\"><b><br></b></span>\r\n</p><p>- Raccordement des évacuations des eaux pluviales à la cuve avec tuyau PVC 100\r\n</p><p>- Fourniture des pièces diverses en PVC\r\n</p><p>- Installation de la cuve et remblai avec graviers déclassés\r\n</p><p>- Raccordement de la sortie trop-plein de la cuve vers exutoire</p><p>- Mise en service\r\n</p><p>- Alimentation électrique à fournir par le client pour le raccordement de la pompe\r\n</p><p>- Évacuation des terres excédentaires comprise dans la prestation</p><p>\r\n</p>',`lig3`='1',`lig2`='2480.00',`lig5`='10',`lig4`='2480.00',`lig8`='2728.00',`lig10`='euro',`lig6`='2728.00',`lig90`='&lt;p&gt;&lt;span style=&quot;font-size: 14px;&quot;&gt;&lt;b&gt;Mise en place d\'une cuve de récupération des eaux de pluie, prestation comprenant :&lt;/b&gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style=&quot;font-size: 14px;&quot;&gt;&lt;b&gt;&lt;br&gt;&lt;/b&gt;&lt;/span&gt;\r\n&lt;/p&gt;&lt;p&gt;- Raccordement des évacuations des eaux pluviales à la cuve avec tuyau PVC 100\r\n&lt;/p&gt;&lt;p&gt;- Fourniture des pièces diverses en PVC\r\n&lt;/p&gt;&lt;p&gt;- Installation de la cuve et remblai avec graviers déclassés\r\n&lt;/p&gt;&lt;p&gt;- Raccordement de la sortie trop-plein de la cuve vers exutoire&lt;/p&gt;&lt;p&gt;- Mise en service\r\n&lt;/p&gt;&lt;p&gt;- Alimentation électrique à fournir par le client pour le raccordement de la pompe\r\n&lt;/p&gt;&lt;p&gt;- Évacuation des terres excédentaires comprise dans la prestation&lt;/p&gt;&lt;p&gt;\r\n&lt;/p&gt;',`ligdatmod`='202509191039',`ligusermod`='1586'  WHERE 1=1  AND ( id_vent = '4637')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '9518')  LIMIT 1 
UID:--103920-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','4637','202509191039','202509191039' )
UID:--103920-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='12535',`lig9`='12535',`lig91`='<b>POSE DIVERS</b><br /><p>grutage minipelle et déblais-remblais en big-bag, dessouchage d\'un conifère abattu par vos soins</p>',`lig3`='1',`lig2`='520.00',`lig5`='10',`lig4`='520.00',`lig8`='572.00',`lig10`='euro',`lig6`='572.00',`lig90`='<p>grutage minipelle et déblais-remblais en big-bag, dessouchage d\'un conifère abattu par vos soins</p>',`ligdatmod`='202509191039',`ligusermod`='1586'  WHERE 1=1  AND ( id_vent = '4637')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '9519')  LIMIT 1 
UID:--103920--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:--103920-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('32','1','2','Devis_DEV-SEM-26_18_09_2025_19h_20m_signe.pdf','20250919','515','devis_signe','168','4637','-2','-1','' )
UID:--103920-- UPDATE  `file`  SET `size`='476853'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '2612')  LIMIT 1 
UID:--103920-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250919','1586','1','tete_de_reseau@toosmart.fr','Rainea','dominique.leblanc5@wanadoo.fr','','','Merci pour votre commande : Devis N°DEV-SEM-26','','/mnt/big/prod/toosmart_rainea/soft/v2017b/../../data/doc/-1/2612-32-515-1§Devis_DEV-SEM-26_18_09_2025_19h_20m_signe.pdf','0','v2017b' )
UID:--103920-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '1011')  LIMIT 1 
UID:--103920-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250919','1586','1','tete_de_reseau@toosmart.fr','Rainea','smarnesud@rainea.fr','','','Devis signé - N° DEV-SEM-26','','','0','v2017b' )
UID:--103920-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '1012')  LIMIT 1 
UID:--110958--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:--110958--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--111116--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:--111116--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--112245--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:--112245--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--115335--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:--115335--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--143416--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:--143416--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--154614--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:--154614--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--161337--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:--161337--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--162019--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:--162019--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--162213--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:--162213--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1619--164551--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:1619--164551--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--165504--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:--165504--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--170832--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:--170832--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1619--172603--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:1619--172603--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1618--175443--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:1618--175443--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1608--181445--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:1608--181445--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--184722--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:--184722--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1609--184817--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:1609--184817--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1609--185506--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:1609--185506--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre