UID:1611--075540-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','165','410','1','202411120755' ) UID:1611--075540-- UPDATE `vent_att` SET `att1`='138',`attf100`='20241112',`attf101`='1',`att11`='1611',`attf105`='20241112',`att43`='Remise TTC',`attdatmod`='202411120755',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '141') AND (id_type = '165') LIMIT 1 UID:1611--075540-- UPDATE `vent_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '165') AND (id_vent = '141') LIMIT 1 UID:1611--075540-- UPDATE `vent_att` SET `att1`='138',`attf100`='20241112',`attf101`='1',`att11`='1611',`attf105`='20241112',`att43`='Remise TTC',`att2`='279',`attdatmod`='202411120755',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '141') AND (id_type = '165') LIMIT 1 UID:1611--075540-- UPDATE `vent_att` SET `att1`='138',`attf100`='20241112',`attf101`='1',`att11`='1611',`attf105`='20241212',`att43`='Remise TTC',`att2`='279',`attdatmod`='202411120755',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '141') AND (id_type = '165') LIMIT 1 UID:1611--075540-- UPDATE `vent_att` SET `att1`='138',`attf100`='20241112',`attf101`='1',`att11`='1611',`attf105`='20241212',`att43`='Remise TTC',`att2`='279',`att13`='yt4kk-00g72i4mqp',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/yt4kk-00g72i4mqp',`attdatmod`='202411120755',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '141') AND (id_type = '165') LIMIT 1 UID:1611--075540-- UPDATE `vent_att` SET `att1`='138',`attf100`='20241112',`attf101`='1',`att11`='1611',`attf105`='20241212',`att43`='Remise TTC',`att2`='279',`att13`='yt4kk-00g72i4mqp',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/yt4kk-00g72i4mqp',`att4`='DEV--7',`attdatmod`='202411120755',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '141') AND (id_type = '165') LIMIT 1 UID:1611--075540-- UPDATE `vent_att` SET `att1`='138',`attf100`='20241112',`attf101`='1',`att11`='1611',`attf105`='20241212',`att43`='Remise TTC',`att2`='279',`att13`='yt4kk-00g72i4mqp',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/yt4kk-00g72i4mqp',`att4`='DEV--7',`att18`='

Rainea Rainéa Saône et Bresse


42 Rue Tourneloup
71000 MÂCON



setbresse@rainea.fr


www.rainea.fr
',`att19`=' 54 rue des fourches 39100 DOLE',`att20`='NOSEIM\r\n \n \n 62 RUE DES FOURCHES 39100 DOLE',`att22`='

Rainea Rainéa Saône et Bresse


SASU au captial de € - SIREN 934700352 - RCS : Mâcon\n
TVA : FR42934700352
IBAN : - BIC : ',`att31`='62 RUE DES FOURCHES',`att33`='39100',`att34`='DOLE',`att35`='France',`att38`='54 rue des fourches',`att40`='39100',`att41`='DOLE',`att42`='France',`attdatmod`='202411120755',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '141') AND (id_type = '165') LIMIT 1 UID:1611--075548-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','141','202411120755','202411120755' ) UID:1611--075548-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411120755',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '141') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '267') LIMIT 1 UID:1611--075548-- UPDATE `vent_att` SET `att15`='virement',`att45`='30% à la commande, 30% à la livraison du matériel et solde fin de chantier.',`att26`='',`attdatmod`='202411120755',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '141') AND (id_type = '165') LIMIT 1 UID:1611--075548-- UPDATE `vent_att` SET `att15`='virement',`att45`='30% à la commande, 30% à la livraison du matériel et solde fin de chantier.',`att26`='',`att7`='0',`att8`='0',`att21`='0',`att9`='0',`att27`='0',`att29`='0',`att28`='0',`att30`='0',`attdatmod`='202411120755',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '141') AND (id_type = '165') LIMIT 1 UID:1611--075605-- UPDATE `vent_lig` SET `lig10`='5983',`ligdatmod`='202411120756',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '141') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '267') LIMIT 1 UID:1611--075605-- UPDATE `vent_lig` SET `lig10`='5983',`lig6`='579.00',`lig13`='0.00',`lig16`='0',`lig17`='5790',`lig18`='579',`lig19`='3790.00',`lig2`='5790.00',`lig5`='10',`lig4`='5790.00',`lig7`='6369.00',`lig9`='',`lig14`='0',`lig15`='6369.00',`lig90`='<p><b>Fourniture et mise en service d\'une filière compacte EasyCompact 4EH sortie HAUTE comprenant : </b></p><p><b><br></b></p><p>- Une fosse toutes eaux de 2m3</p><p>- Un filtre compact 4EH composé de laine de roche</p><p>- Un poste de relevage intégré</p><p><br></p><p>Les Prestations :</p><p>- Assistance à la réalisation des démarches administratives.</p><p>- Vérification de la position du préfiltre de la fosse.</p><p>- Mise en place et réglage de l\'auget basculant du filtre.</p><p>- Vérification du bon fonctionnement de la filière.</p><p>- Installation et mise en service de la pompe de relevage.</p><p><br></p><p><i>Les Garanties : </i></p><p><i>- Cuve :25 ans</i></p><p><i>- Médiat filtrant : 10 ans</i></p><p><br></p><p>Agrément Ministériel 2023-010-ext01</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p>',`ligdatmod`='202411120756',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '141') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '267') LIMIT 1 UID:1611--075605-- UPDATE `vent_att` SET `att7`='5790',`att8`='579',`att21`='6369',`att9`='6369',`att27`='0',`att29`='0',`att28`='5790',`att30`='579',`attdatmod`='202411120756',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '141') AND (id_type = '165') LIMIT 1 UID:1611--075611-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','141','202411120756','202411120756' ) UID:1611--075611-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411120756',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '141') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '268') LIMIT 1 UID:1611--075611-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411120756',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '141') AND (id_type = '165') LIMIT 1 UID:1611--075621-- UPDATE `vent_lig` SET `lig10`='5945',`ligdatmod`='202411120756',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '141') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '268') LIMIT 1 UID:1611--075621-- UPDATE `vent_lig` SET `lig10`='5945',`lig6`='285.00',`lig13`='0.00',`lig16`='0',`lig17`='2850',`lig18`='285',`lig19`='0.00',`lig2`='2850.00',`lig5`='10',`lig4`='2850.00',`lig7`='3135.00',`lig9`='',`lig14`='0',`lig15`='3135.00',`lig90`='<p><b><span style="font-size: 14px;">Pose d\'une microstation EASYONE comprenant :</span></b></p><p><b><br></b></p><p><b>\r\n</b></p><p>- L\'apport et le retrait de matériels.</p><p>\r\n</p><p>- Les prises de niveaux au laser et l\'implantation des ouvrages.\r\n</p><p>- Le terrassement en terrain non rocheux.\r\n</p><p>- La pose de tuyaux PVC Ø100 et accessoires PVC (dont Tés de visite).\r\n</p><p>- Le raccordement des sorties maison à la microstation.\r\n</p><p>- Le raccordement de la microstation vers l\'exutoire.\r\n</p><p>- Le raccordement au coffret extérieur si nécessaire.\r\n</p><p>- La mise en service du dispositif.\r\n</p><p>- Le transport et l\'évacuation des déblais.\r\n</p><p>- Les matériaux de calage (graviers déclassés).\r\n</p><p>- La réception de chantier avec le SPANC contacté par nos soins.</p><p><br></p><p>\r\n</p><p>NB. : travaux à prévoir par le client\r\n</p><p>- L\'installation d\'une alimentation électrique 230V 16A (disjoncteur dédié) avec fourreau en attente à l\'extérieur.</p><p>\r\n</p>',`ligdatmod`='202411120756',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '141') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '268') LIMIT 1 UID:1611--075622-- UPDATE `vent_att` SET `att7`='8640',`att8`='864',`att21`='9504',`att9`='9504',`att27`='0',`att29`='0',`att28`='8640',`att30`='864',`attdatmod`='202411120756',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '141') AND (id_type = '165') LIMIT 1 UID:1611--075626-- UPDATE `vent_lig` SET `lig10`='',`ligdatmod`='202411120756',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '141') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '268') LIMIT 1 UID:1611--075626-- UPDATE `vent_lig` SET `lig10`='',`lig6`='0.00',`lig17`='0',`lig18`='0',`lig2`='0.00',`lig5`='0',`lig4`='0.00',`lig7`='0.00',`lig15`='0.00',`lig90`='',`ligdatmod`='202411120756',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '141') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '268') LIMIT 1 UID:1611--075627-- UPDATE `vent_att` SET `att7`='5790',`att8`='579',`att21`='6369',`att9`='6369',`att27`='0',`att29`='0',`att28`='5790',`att30`='579',`attdatmod`='202411120756',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '141') AND (id_type = '165') LIMIT 1 UID:1611--075644-- UPDATE `vent_lig` SET `lig10`='5945',`ligdatmod`='202411120756',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '141') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '268') LIMIT 1 UID:1611--075644-- UPDATE `vent_lig` SET `lig10`='5945',`lig6`='285.00',`lig17`='2850',`lig18`='285',`lig2`='2850.00',`lig5`='10',`lig4`='2850.00',`lig7`='3135.00',`lig15`='3135.00',`lig90`='<p><b><span style="font-size: 14px;">Pose d\'une microstation EASYONE comprenant :</span></b></p><p><b><br></b></p><p><b>\r\n</b></p><p>- L\'apport et le retrait de matériels.</p><p>\r\n</p><p>- Les prises de niveaux au laser et l\'implantation des ouvrages.\r\n</p><p>- Le terrassement en terrain non rocheux.\r\n</p><p>- La pose de tuyaux PVC Ø100 et accessoires PVC (dont Tés de visite).\r\n</p><p>- Le raccordement des sorties maison à la microstation.\r\n</p><p>- Le raccordement de la microstation vers l\'exutoire.\r\n</p><p>- Le raccordement au coffret extérieur si nécessaire.\r\n</p><p>- La mise en service du dispositif.\r\n</p><p>- Le transport et l\'évacuation des déblais.\r\n</p><p>- Les matériaux de calage (graviers déclassés).\r\n</p><p>- La réception de chantier avec le SPANC contacté par nos soins.</p><p><br></p><p>\r\n</p><p>NB. : travaux à prévoir par le client\r\n</p><p>- L\'installation d\'une alimentation électrique 230V 16A (disjoncteur dédié) avec fourreau en attente à l\'extérieur.</p><p>\r\n</p>',`ligdatmod`='202411120756',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '141') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '268') LIMIT 1 UID:1611--075644-- UPDATE `vent_att` SET `att7`='8640',`att8`='864',`att21`='9504',`att9`='9504',`att27`='0',`att29`='0',`att28`='8640',`att30`='864',`attdatmod`='202411120756',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '141') AND (id_type = '165') LIMIT 1 UID:1611--075654-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','141','202411120756','202411120756' ) UID:1611--075654-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411120756',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '141') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '269') LIMIT 1 UID:1611--075655-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411120756',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '141') AND (id_type = '165') LIMIT 1 UID:1611--075704-- UPDATE `vent_lig` SET `lig10`='6009',`ligdatmod`='202411120757',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '141') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '269') LIMIT 1 UID:1611--075704-- UPDATE `vent_lig` SET `lig10`='6009',`lig6`='528.00',`lig13`='0.00',`lig16`='0',`lig17`='5280',`lig18`='528',`lig19`='3180.00',`lig2`='5280.00',`lig5`='10',`lig4`='5280.00',`lig7`='5808.00',`lig9`='',`lig14`='0',`lig15`='5808.00',`lig90`='<p><b>Fourniture et mise en service d\'une Microstation GRAF Easy One® 5EH avec armoire de pilotage.</b></p><p>(Compresseur, Automate, Rampe de distribution)</p><p><br></p><p>- GRAF Marque Allemande - Fabrication française </p><p>- Agrément ministériel n° 2015-008.</p><p>- Les microstations Easy One sont conformes à la « NORME NF-EN 12566-3 + A1 » et à « l\'arrêté du 7 Septembre 2009 ».</p><p><br></p><p>Les Prestations :</p><p><br></p><p>- Assistance à la réalisation des démarches administratives. </p><p>- Mise en place de l\'armoire de pilotage et paramétrage de l\'automate.</p><p>- Vérification du bon fonctionnement de la station.            </p><p><br></p><p>Les Garanties :</p><p><br></p><p><i>- cuverie : 30 ans.</i></p><p><i>- système épuratoire : 3 ans.</i></p><p><i>- armoire de pilotage : 3 ans</i></p>',`ligdatmod`='202411120757',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '141') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '269') LIMIT 1 UID:1611--075705-- UPDATE `vent_att` SET `att7`='13920',`att8`='1392',`att21`='15312',`att9`='15312',`att27`='0',`att29`='0',`att28`='13920',`att30`='1392',`attdatmod`='202411120757',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '141') AND (id_type = '165') LIMIT 1 UID:1611--075714-- UPDATE `vent_lig` SET `lig10`='',`ligdatmod`='202411120757',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '141') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '269') LIMIT 1 UID:1611--075714-- UPDATE `vent_lig` SET `lig10`='',`lig6`='0.00',`lig17`='0',`lig18`='0',`lig19`='0.00',`lig2`='0.00',`lig5`='0',`lig4`='0.00',`lig7`='0.00',`lig15`='0.00',`lig90`='',`ligdatmod`='202411120757',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '141') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '269') LIMIT 1 UID:1611--075715-- UPDATE `vent_att` SET `att7`='8640',`att8`='864',`att21`='9504',`att9`='9504',`att27`='0',`att29`='0',`att28`='8640',`att30`='864',`attdatmod`='202411120757',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '141') AND (id_type = '165') LIMIT 1 UID:1611--075800-- UPDATE `vent_lig` SET `lig10`='5982',`ligdatmod`='202411120758',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '141') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '269') LIMIT 1 UID:1611--075800-- UPDATE `vent_lig` SET `lig10`='5982',`lig6`='615.00',`lig17`='6150',`lig18`='615',`lig19`='4150.00',`lig2`='6150.00',`lig5`='10',`lig4`='6150.00',`lig7`='6765.00',`lig15`='6765.00',`lig90`='<p><b>Fourniture et mise en service d\'une filière compacte EasyCompact 5EH sortie HAUTE comprenant : </b></p><p><b><br></b></p><p>- Une fosse toutes eaux de 3m3</p><p>- Un filtre compact 5EH composé de laine de roche</p><p>- Un poste de relevage intégré</p><p><br></p><p>Les Prestations :</p><p>- Assistance à la réalisation des démarches administratives.</p><p>- Vérification de la position du préfiltre de la fosse.</p><p>- Mise en place et réglage de l\'auget basculant du filtre.</p><p>- Vérification du bon fonctionnement de la filière.</p><p>- Installation et mise en service de la pompe de relevage.</p><p><br></p><p><i>Les Garanties : </i></p><p><i>- Cuve :25 ans</i></p><p><i>- Médiat filtrant : 10 ans</i></p><p><br></p><p>Agrément Ministériel 2023-010-ext01</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p><p>\r\n</p>',`ligdatmod`='202411120758',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '141') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '269') LIMIT 1 UID:1611--075800-- UPDATE `vent_att` SET `att7`='14790',`att8`='1479',`att21`='16269',`att9`='16269',`att27`='0',`att29`='0',`att28`='14790',`att30`='1479',`attdatmod`='202411120758',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '141') AND (id_type = '165') LIMIT 1 UID:1611--075815-- UPDATE `vent_lig` SET `lig3`='2',`ligdatmod`='202411120758',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '141') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '268') LIMIT 1 UID:1611--075815-- UPDATE `vent_lig` SET `lig3`='2',`lig6`='570.00',`lig17`='5700',`lig18`='570',`lig4`='5700.00',`lig7`='6270.00',`lig15`='6270.00',`ligdatmod`='202411120758',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '141') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '268') LIMIT 1 UID:1611--075815-- UPDATE `vent_att` SET `att7`='17640',`att8`='1764',`att21`='19404',`att9`='19404',`att27`='0',`att29`='0',`att28`='17640',`att30`='1764',`attdatmod`='202411120758',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '141') AND (id_type = '165') LIMIT 1 UID:1611--080756-- UPDATE `vent_lig` SET `lig5`='20',`ligdatmod`='202411120807',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '141') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '267') LIMIT 1 UID:1611--080756-- UPDATE `vent_lig` SET `lig5`='20',`lig6`='1158.00',`lig18`='1158',`lig7`='6948.00',`lig15`='6948.00',`ligdatmod`='202411120807',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '141') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '267') LIMIT 1 UID:1611--080756-- UPDATE `vent_att` SET `att8`='2343',`att21`='19983',`att9`='19983',`att27`='0',`att29`='0',`att30`='2343',`attdatmod`='202411120807',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '141') AND (id_type = '165') LIMIT 1 UID:1611--080800-- UPDATE `vent_lig` SET `lig5`='20',`ligdatmod`='202411120808',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '141') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '268') LIMIT 1 UID:1611--080800-- UPDATE `vent_lig` SET `lig5`='20',`lig6`='1140.00',`lig18`='1140',`lig7`='6840.00',`lig15`='6840.00',`ligdatmod`='202411120808',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '141') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '268') LIMIT 1 UID:1611--080801-- UPDATE `vent_att` SET `att8`='2913',`att21`='20553',`att9`='20553',`att27`='0',`att29`='0',`att30`='2913',`attdatmod`='202411120808',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '141') AND (id_type = '165') LIMIT 1 UID:1611--080803-- UPDATE `vent_lig` SET `lig5`='20',`ligdatmod`='202411120808',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '141') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '269') LIMIT 1 UID:1611--080803-- UPDATE `vent_lig` SET `lig5`='20',`lig6`='1230.00',`lig18`='1230',`lig7`='7380.00',`lig15`='7380.00',`ligdatmod`='202411120808',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '141') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '269') LIMIT 1 UID:1611--080803-- UPDATE `vent_att` SET `att8`='3528',`att21`='21168',`att9`='21168',`att27`='0',`att29`='0',`att30`='3528',`attdatmod`='202411120808',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '141') AND (id_type = '165') LIMIT 1 UID:1611--080823-- UPDATE `vent_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '165') AND (id_vent = '141') LIMIT 1 UID:1611--080823-- UPDATE `tier_lig` SET `lig2`='7',`ligdatmod`='202411120808',`ligusermod`='1611' WHERE 1=1 AND ( id_tier = '260') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '147') LIMIT 1 UID:1611--080823-- UPDATE `vent_att` SET `att24`='

Rainéa Saône et Bresse

42 Rue Tourneloup

71000 MÂCON

0744306670

setbresse@rainea.fr

www.rainea.fr

',`attdatmod`='202411120808',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '141') AND (id_type = '165') LIMIT 1 UID:1611--081119-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20241112','1611','1','setbresse@rainea.fr','Rainea','sasunoseim@gmail.com','sasunoseim@gmail.com','setbresse@rainea.fr','Nouvelle proposition de RAINEA : Devis N° DEV--7','\r\n\r\nNouveau Devis RAINEA\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 \r\n \"Rainea_logo\"\r\n \r\n

\r\n\r\n

\r\n Proposition pour votre installation (Devis N° DEV--7)\r\n

\r\n\r\n

\r\n Bonjour SASU LEMKAK,

\r\n Comme convenu, vous trouverez en pièce jointe le devis correspondant à votre projet. Nous avons pris soin de bien détailler chaque élément afin de vous offrir une vue d\'ensemble claire et précise.

\r\n N\'hésitez pas à me contacter si vous avez la moindre question ou besoin de clarification sur certains points.

\r\n\r\n Afin de valider cette proposition nous vous invitons à cliquer sur le bouton \"Afficher votre devis\".

\r\n Nous vous remercions de votre confiance et restons à votre disposition pour toute information complémentaire.

\r\n Dans l\'attente de votre retour, nous vous souhaitons une excellente journée.

\r\n Cordialement,
\r\n

\r\n\r\n

\r\n Votre équipe RAINEA - Rainéa Saône et Bresse\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 Afficher votre devis\r\n \r\n
\r\n
\r\n
\r\n \"Bannière\"\r\n
\r\n
\r\n \r\n\r\n
\r\n
\r\n','/mnt/big/prod/toosmart_rainea/data/tmp/Devis_DEV--7.pdf§Devis_DEV--7.pdf','0','v2017b' ) UID:1611--081119-- UPDATE `email` SET `type`='',`bcc`='' WHERE 1=1 AND (id_email = '164') LIMIT 1 UID:1611--081119-- UPDATE `vent_att` SET `attf104`='20241112',`id_work`='411',`attdatmod`='202411120811',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '141') AND (id_type = '165') LIMIT 1 UID:1611--081119-- UPDATE `vent_att` SET `attf104`='20241112',`id_work`='411',`attf106`='20241112',`attdatmod`='202411120811',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '141') AND (id_type = '165') LIMIT 1 UID:1611--094608-- UPDATE `vent_att` SET `att3`='',`attdatmod`='202411120946',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '135') AND (id_type = '165') LIMIT 1 UID:1--102450--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:1--102457--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:1--102533-- UPDATE `tier_att` SET `att16`='1000',`att18`='FR76 1080 7000 6592 5214 8465 608',`att19`='CCBPFRPPDJN',`attdatmod`='202411121025',`attusermod`='1',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '260') AND (id_type = '152') LIMIT 1 UID:1--102533--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:1611--105338-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','165','410','1','202411121053' ) UID:1611--105338-- UPDATE `vent_att` SET `att1`='132',`attf100`='20241112',`attf101`='1',`att11`='1611',`attf105`='20241112',`att43`='Remise TTC',`attdatmod`='202411121053',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '142') AND (id_type = '165') LIMIT 1 UID:1611--105338-- UPDATE `vent_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '165') AND (id_vent = '142') LIMIT 1 UID:1611--105338-- UPDATE `vent_att` SET `att1`='132',`attf100`='20241112',`attf101`='1',`att11`='1611',`attf105`='20241112',`att43`='Remise TTC',`att2`='275',`attdatmod`='202411121053',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '142') AND (id_type = '165') LIMIT 1 UID:1611--105338-- UPDATE `vent_att` SET `att1`='132',`attf100`='20241112',`attf101`='1',`att11`='1611',`attf105`='20241212',`att43`='Remise TTC',`att2`='275',`attdatmod`='202411121053',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '142') AND (id_type = '165') LIMIT 1 UID:1611--105338-- UPDATE `vent_att` SET `att1`='132',`attf100`='20241112',`attf101`='1',`att11`='1611',`attf105`='20241212',`att43`='Remise TTC',`att2`='275',`att13`='x44kk03o292h5ypl',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/x44kk03o292h5ypl',`attdatmod`='202411121053',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '142') AND (id_type = '165') LIMIT 1 UID:1611--105338-- UPDATE `vent_att` SET `att1`='132',`attf100`='20241112',`attf101`='1',`att11`='1611',`attf105`='20241212',`att43`='Remise TTC',`att2`='275',`att13`='x44kk03o292h5ypl',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/x44kk03o292h5ypl',`att4`='DEV--8',`attdatmod`='202411121053',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '142') AND (id_type = '165') LIMIT 1 UID:1611--105338-- UPDATE `vent_att` SET `att1`='132',`attf100`='20241112',`attf101`='1',`att11`='1611',`attf105`='20241212',`att43`='Remise TTC',`att2`='275',`att13`='x44kk03o292h5ypl',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/x44kk03o292h5ypl',`att4`='DEV--8',`att18`='

Rainea Rainéa Saône et Bresse


42 Rue Tourneloup
71000 MÂCON



setbresse@rainea.fr


www.rainea.fr
',`att19`=' 435 Villemaison 71130 UXEAU',`att20`=' 435 Villemaison 71130 UXEAU',`att22`='

Rainea Rainéa Saône et Bresse


SASU au captial de 1000€ - SIREN 934700352 - RCS : Mâcon\n
TVA : FR42934700352
IBAN : FR76 1080 7000 6592 5214 8465 608 - BIC : CCBPFRPPDJN',`att31`='435 Villemaison',`att33`='71130',`att34`='UXEAU',`att35`='France',`att38`='435 Villemaison',`att40`='71130',`att41`='UXEAU',`att42`='France',`attdatmod`='202411121053',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '142') AND (id_type = '165') LIMIT 1 UID:1611--105402-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','142','202411121054','202411121054' ) UID:1611--105402-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411121054',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '142') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '270') LIMIT 1 UID:1611--105402-- UPDATE `vent_att` SET `att15`='virement',`att45`='30% à la commande, solde fin de chantier.',`att26`='',`attdatmod`='202411121054',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '142') AND (id_type = '165') LIMIT 1 UID:1611--105403-- UPDATE `vent_att` SET `att15`='virement',`att45`='30% à la commande, solde fin de chantier.',`att26`='',`att7`='0',`att8`='0',`att21`='0',`att9`='0',`att27`='0',`att29`='0',`att28`='0',`att30`='0',`attdatmod`='202411121054',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '142') AND (id_type = '165') LIMIT 1 UID:1611--105405-- UPDATE `vent_lig` SET `lig10`='5959',`ligdatmod`='202411121054',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '142') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '270') LIMIT 1 UID:1611--105405-- UPDATE `vent_lig` SET `lig10`='5959',`lig6`='646.00',`lig13`='0.00',`lig16`='0',`lig17`='6460',`lig18`='646',`lig19`='4454.00',`lig2`='6460.00',`lig5`='10',`lig4`='6460.00',`lig7`='7106.00',`lig9`='',`lig14`='0',`lig15`='7106.00',`lig90`='<p><b>Fourniture et mise en service d\'une filière EPARCO COMPACT PE LIGNE 6EH sortie BASSE comprenant :</b></p><p><br></p><p>- Une fosse toutes eaux de 3,6m3 équipée d\'un préfiltre PF17 permettant de piéger les matières et de protéger le filtre EPARCO.</p><p>- Un filtre compact 6EH composé d\'écorces de pin maritime Français.</p><p><br></p><p><u>Les Prestations :</u></p><p><u><br></u></p><p>- Assistance à la réalisation des démarches administratives. </p><p>- Vérification de la position du préfiltre de la fosse.</p><p>- Mise en place et réglage de l\'auget basculant du filtre.</p><p>- Vérification du bon fonctionnement de la filière.</p><p><br></p><p>- Garantie 10 ans.</p><p><br></p><p>- Fabrication Française disposant d\'un agrément Ministériel n° 2023-008-ext01 et conforme à la Norme NF-EN 12566-3+A1 et à l\'arrêté du 7 septembre 2009.</p>',`ligdatmod`='202411121054',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '142') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '270') LIMIT 1 UID:1611--105405-- UPDATE `vent_att` SET `att7`='6460',`att8`='646',`att21`='7106',`att9`='7106',`att27`='0',`att29`='0',`att28`='6460',`att30`='646',`attdatmod`='202411121054',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '142') AND (id_type = '165') LIMIT 1 UID:1611--105430-- UPDATE `vent_lig` SET `lig2`='7060.00',`ligdatmod`='202411121054',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '142') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '270') LIMIT 1 UID:1611--105430-- UPDATE `vent_lig` SET `lig2`='7060.00',`lig6`='706.00',`lig17`='7060',`lig18`='706',`lig4`='7060.00',`lig7`='7766.00',`lig15`='7766.00',`ligdatmod`='202411121054',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '142') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '270') LIMIT 1 UID:1611--105431-- UPDATE `vent_att` SET `att7`='7060',`att8`='706',`att21`='7766',`att9`='7766',`att27`='0',`att29`='0',`att28`='7060',`att30`='706',`attdatmod`='202411121054',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '142') AND (id_type = '165') LIMIT 1 UID:1611--105446-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','142','202411121054','202411121054' ) UID:1611--105446-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411121054',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '142') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '271') LIMIT 1 UID:1611--105446-- UPDATE `vent_att` SET `att91`='<p>Ajout de 600 € sur l\'EPARCO pour les tuyaux supplémentaires</p>',`attdatmod`='202411121054',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '142') AND (id_type = '165') LIMIT 1 UID:1611--105447-- UPDATE `vent_att` SET `att91`='<p>Ajout de 600 € sur l\'EPARCO pour les tuyaux supplémentaires</p>',`att27`='0',`att29`='0',`attdatmod`='202411121054',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '142') AND (id_type = '165') LIMIT 1 UID:1611--105456-- UPDATE `vent_lig` SET `lig10`='5925',`ligdatmod`='202411121054',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '142') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '271') LIMIT 1 UID:1611--105456-- UPDATE `vent_lig` SET `lig10`='5925',`lig6`='345.00',`lig13`='0.00',`lig16`='0',`lig17`='3450',`lig18`='345',`lig19`='0.00',`lig2`='3450.00',`lig5`='10',`lig4`='3450.00',`lig7`='3795.00',`lig9`='',`lig14`='0',`lig15`='3795.00',`lig90`='<p><b><span style="font-size: 14px;">Pose d\'un filtre compact Eparco comprenant :</span></b></p><p><br></p><p>- L\'apport et les replis de matériels.</p><p>- Les prises de niveaux au laser et l\'implantation des ouvrages.</p><p>- Le terrassement en terrain non rocheux.</p><p>- La pose de tuyaux PVC Ø100 et accessoires PVC (dont Tés de visite).</p><p>- Le raccordement des sorties maison au système EPARCO®.</p><p>- Le raccordement de la filière vers l\'exutoire.</p><p>- L\'implantation du système  EPARCO®</p><p>- Le raccordement à la ventilation secondaire.</p><p>- Le piquage en sortie de système EPARCO® vers l\'exutoire.</p><p>- Le transport et l\'évacuation des déblais.</p><p>- Les matériaux de calage (graviers déclassés).</p><p>- La réception de chantier avec le SPANC contacté par nos soins.</p><p><br></p><p>Travaux à prévoir par le client :</p><p>- L\'installation d\'une ventilation secondaire en toiture jusqu\'au pied du mur de l\'habitation.</p><p>- L\'installation d\'une alimentation électrique 230V 16A (disjoncteur dédié) avec fourreau en attente à l\'extérieur" si relevage.</p>',`ligdatmod`='202411121054',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '142') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '271') LIMIT 1 UID:1611--105457-- UPDATE `vent_att` SET `att7`='10510',`att8`='1051',`att21`='11561',`att9`='11561',`att27`='0',`att29`='0',`att28`='10510',`att30`='1051',`attdatmod`='202411121054',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '142') AND (id_type = '165') LIMIT 1 UID:1611--105533-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','142','202411121055','202411121055' ) UID:1611--105533-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411121055',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '142') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '272') LIMIT 1 UID:1611--105534-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411121055',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '142') AND (id_type = '165') LIMIT 1 UID:1611--105536-- UPDATE `vent_lig` SET `lig10`='5780',`ligdatmod`='202411121055',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '142') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '272') LIMIT 1 UID:1611--105536-- UPDATE `vent_lig` SET `lig10`='5780',`lig6`='52.00',`lig13`='0.00',`lig16`='0',`lig17`='520',`lig18`='52',`lig19`='0.00',`lig2`='520.00',`lig5`='10',`lig4`='520.00',`lig7`='572.00',`lig9`='',`lig14`='0',`lig15`='572.00',`lig90`='<p><b>Fourniture d\'un pack d\'infiltration de la marque Graf comprenant:</b></p><p><br></p><p>- Six tunnels d\'épandage de 300l</p><p><br></p><p>- Un lot de deux parois entrée/sortie</p><p><br></p><p>Produit fabriqué en France</p><p><br></p><p>Garantie 5 ans</p><p><br></p><p>Matière 100% recyclée et recyclable</p><p><br></p><p><br></p><p>Tarif tunnel: 60€/p</p><p>Parois entrée sortie: 29€/le lot de 2</p>',`ligdatmod`='202411121055',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '142') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '272') LIMIT 1 UID:1611--105536-- UPDATE `vent_att` SET `att7`='11030',`att8`='1103',`att21`='12133',`att9`='12133',`att27`='0',`att29`='0',`att28`='11030',`att30`='1103',`attdatmod`='202411121055',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '142') AND (id_type = '165') LIMIT 1 UID:1611--105554-- UPDATE `vent_lig` SET `lig90`='

Pose d\'un filtre compact Eparco comprenant :


- L\'apport et les replis de matériels.

- Les prises de niveaux au laser et l\'implantation des ouvrages.

- Le terrassement en terrain non rocheux.

- La pose de tuyaux PVC Ø100 et accessoires PVC (dont Tés de visite).

- Le raccordement des sorties maison au système EPARCO®.

- Le raccordement de la filière vers l\'exutoire.

- L\'implantation du système  EPARCO®

- Le raccordement à la ventilation secondaire.

- Le piquage en sortie de système EPARCO® vers l\'exutoire.

- Le transport et l\'évacuation des déblais.

- Les matériaux de calage (graviers déclassés).

- La réception de chantier avec le SPANC contacté par nos soins.


Travaux à prévoir par le client :

- L\'installation d\'une ventilation secondaire en toiture jusqu\'au pied du mur de l\'habitation.

',`ligdatmod`='202411121055',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '142') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '271') LIMIT 1 UID:1611--105554-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411121055',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '142') AND (id_type = '165') LIMIT 1 UID:1611--105640-- UPDATE `vent_lig` SET `lig90`='

Fourniture d\'un pack d\'infiltration de la marque Graf comprenant:


- Trois tunnels d\'épandage de 300l


- Un lot de deux parois entrée/sortie


Produit fabriqué en France


Garantie 5 ans


Matière 100% recyclée et recyclable

',`ligdatmod`='202411121056',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '142') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '272') LIMIT 1 UID:1611--105640-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411121056',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '142') AND (id_type = '165') LIMIT 1 UID:1611--105710-- UPDATE `vent_lig` SET `lig90`='

Pose d\'un filtre compact Eparco comprenant :


- L\'apport et les replis de matériels.

- Les prises de niveaux au laser et l\'implantation des ouvrages.

- Le terrassement en terrain non rocheux.

- La pose de tuyaux PVC Ø100 et accessoires PVC (dont Tés de visite).

- Le raccordement des sorties maison au système EPARCO®.

- Le raccordement de la filière vers l\'exutoire.

- L\'implantation du système  EPARCO®

- Le raccordement à la ventilation secondaire.

- Le piquage en sortie de système EPARCO® vers le tunnel d\'infiltration

- Le transport et l\'évacuation des déblais.

- Les matériaux de calage (graviers déclassés).

- La réception de chantier avec le SPANC contacté par nos soins.


Travaux à prévoir par le client :

- L\'installation d\'une ventilation secondaire en toiture jusqu\'au pied du mur de l\'habitation.

',`ligdatmod`='202411121057',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '142') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '271') LIMIT 1 UID:1611--105710-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411121057',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '142') AND (id_type = '165') LIMIT 1 UID:1611--105736-- UPDATE `vent_lig` SET `lig2`='3950.00',`ligdatmod`='202411121057',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '142') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '271') LIMIT 1 UID:1611--105736-- UPDATE `vent_lig` SET `lig2`='3950.00',`lig6`='395.00',`lig17`='3950',`lig18`='395',`lig4`='3950.00',`lig7`='4345.00',`lig15`='4345.00',`ligdatmod`='202411121057',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '142') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '271') LIMIT 1 UID:1611--105737-- UPDATE `vent_att` SET `att7`='11530',`att8`='1153',`att21`='12683',`att9`='12683',`att27`='0',`att29`='0',`att28`='11530',`att30`='1153',`attdatmod`='202411121057',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '142') AND (id_type = '165') LIMIT 1 UID:1611--105759-- UPDATE `vent_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '165') AND (id_vent = '142') LIMIT 1 UID:1611--105759-- UPDATE `vent_att` SET `att91`='<p>Ajout de 600 € sur l\'EPARCO pour les tuyaux supplémentaires</p><p>Ajout de 500 € sur la pose pour les frais du terrassier</p>',`attdatmod`='202411121057',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '142') AND (id_type = '165') LIMIT 1 UID:1611--105759-- UPDATE `tier_lig` SET `lig2`='8',`ligdatmod`='202411121057',`ligusermod`='1611' WHERE 1=1 AND ( id_tier = '260') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '147') LIMIT 1 UID:1611--105759-- UPDATE `vent_att` SET `att91`='<p>Ajout de 600 € sur l\'EPARCO pour les tuyaux supplémentaires</p><p>Ajout de 500 € sur la pose pour les frais du terrassier</p>',`att24`='

Rainéa Saône et Bresse

42 Rue Tourneloup

71000 MÂCON

0744306670

setbresse@rainea.fr

www.rainea.fr

',`attdatmod`='202411121057',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '142') AND (id_type = '165') LIMIT 1 UID:1611--105935-- UPDATE `vent_att` SET `id_work`='420' WHERE 1=1 AND ( id_vent = '135') AND ( id_type = '165') LIMIT 1 UID:1611--105935-- INSERT INTO `vent_sta` (`id_vent`,`id_work_fr`,`id_work_to`,`datee`,`timee`,`id_user` ) VALUES ('135','411','420','20241112','105935','1611' ) UID:1611--105935-- UPDATE `vent_att` SET `id_work`='420',`attf106`='20241112',`attdatmod`='202411121059',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '135') AND (id_type = '165') LIMIT 1 UID:1611--113628-- UPDATE `vent_lig` SET `lig2`='7385.00',`ligdatmod`='202411121136',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '142') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '270') LIMIT 1 UID:1611--113628-- UPDATE `vent_lig` SET `lig2`='7385.00',`lig6`='738.50',`lig17`='7385',`lig18`='738.5',`lig4`='7385.00',`lig7`='8123.50',`lig15`='8123.50',`ligdatmod`='202411121136',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '142') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '270') LIMIT 1 UID:1611--113629-- UPDATE `vent_att` SET `att7`='11855',`att8`='1185.5',`att21`='13040.5',`att9`='13040.5',`att27`='0',`att29`='0',`att28`='11855',`att30`='1185.5',`attdatmod`='202411121136',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '142') AND (id_type = '165') LIMIT 1 UID:1611--113651-- UPDATE `vent_att` SET `att91`='<p>Ajout de 600 € sur l\'EPARCO pour les tuyaux supplémentaires</p><p>Ajout de 500 € sur la pose pour les frais du terrassier</p><p>Ajout de 325 € pour le bac à graisse</p>',`attdatmod`='202411121136',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '142') AND (id_type = '165') LIMIT 1 UID:1607--113705-- UPDATE `vent_lig` SET `lig10`='6156',`ligdatmod`='202411121137',`ligusermod`='1607' WHERE 1=1 AND ( id_vent = '108') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '209') LIMIT 1 UID:1607--113705-- UPDATE `vent_lig` SET `lig10`='6156',`lig6`='162.80',`lig13`='0.00',`lig16`='0',`lig17`='1628',`lig18`='162.8',`lig19`='0.00',`lig2`='1628.00',`lig5`='10',`lig4`='1628.00',`lig7`='1790.80',`lig9`='',`lig14`='0',`lig15`='1790.80',`lig90`='<p>Fourniture d\'un poste RELEVAGE HYDROREL Eaux Chargées D670 H2090 1P08</p>',`ligdatmod`='202411121137',`ligusermod`='1607' WHERE 1=1 AND ( id_vent = '108') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '209') LIMIT 1 UID:1607--113706-- UPDATE `vent_att` SET `att7`='10508',`att8`='1050.8',`att21`='11558.8',`att9`='11558.8',`att27`='0',`att29`='0',`att28`='10508',`att30`='1050.8',`attdatmod`='202411121137',`attusermod`='1607',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '108') AND (id_type = '165') LIMIT 1 UID:1611--113752-- UPDATE `vent_lig` SET `lig90`='

Fourniture et mise en service d\'une filière EPARCO COMPACT PE LIGNE 6EH sortie BASSE comprenant :


- Une fosse toutes eaux de 3,6m3 équipée d\'un préfiltre PF17 permettant de piéger les matières et de protéger le filtre EPARCO.

- Un filtre compact 6EH composé d\'écorces de pin maritime Français.


Fourniture et mise en service d\'un bac à graisse d\'une contenance de 200 litres

\r\n


Les Prestations :


- Assistance à la réalisation des démarches administratives. 

- Vérification de la position du préfiltre de la fosse.

- Mise en place et réglage de l\'auget basculant du filtre.

- Vérification du bon fonctionnement de la filière.


- Garantie 10 ans.


- Fabrication Française disposant d\'un agrément Ministériel n° 2023-008-ext01 et conforme à la Norme NF-EN 12566-3+A1 et à l\'arrêté du 7 septembre 2009.

',`ligdatmod`='202411121137',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '142') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '270') LIMIT 1 UID:1611--113752-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411121137',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '142') AND (id_type = '165') LIMIT 1 UID:1611--113804-- UPDATE `vent_att` SET `att94`='<p>Sous réserve de la validation de la filière d\'assainissement par le SPANC.</p><p>\r\n</p>',`attdatmod`='202411121138',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '142') AND (id_type = '165') LIMIT 1 UID:1611--113904-- UPDATE `vent_lig` SET `lig90`='

Fourniture et mise en service d\'une filière EPARCO COMPACT PE LIGNE 6EH sortie BASSE comprenant :


- Une fosse toutes eaux de 3,6m3 équipée d\'un préfiltre PF17 permettant de piéger les matières et de protéger le filtre EPARCO.

- Un filtre compact 6EH composé d\'écorces de pin maritime Français.


Fourniture et mise en service d\'un bac à graisse d\'une contenance de 200 litres.

\r\n


Les Prestations :


- Assistance à la réalisation des démarches administratives. 

- Vérification de la position du préfiltre de la fosse.

- Mise en place et réglage de l\'auget basculant du filtre.

- Vérification du bon fonctionnement de la filière.


- Garantie 10 ans.


- Fabrication Française disposant d\'un agrément Ministériel n° 2023-008-ext01 et conforme à la Norme NF-EN 12566-3+A1 et à l\'arrêté du 7 septembre 2009.

',`ligdatmod`='202411121139',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '142') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '270') LIMIT 1 UID:1611--113904-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411121139',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '142') AND (id_type = '165') LIMIT 1 UID:1--143508-- INSERT INTO `param_group_user` (`id_base`,`id_user`,`id_group`,`type` ) VALUES ('1','1600','59','1' ) UID:1--143621--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:1--143651--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:1--143700--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:1--143704--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:1--143707--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:1--143710--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:1--143756--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:1--143810--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:1--143816--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