UID:1611--141339-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','205','1','202411111413' )
UID:1611--141339-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1611',`att18`='France',`attf102`='20241111',`attf103`='1',`attf104`='1',`attf105`='20241111',`attdatmod`='202411111413',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '272') AND (id_type = '80') LIMIT 1
UID:1611--141339-- UPDATE `tier_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '80') AND (id_tier = '272') LIMIT 1
UID:1611--141339-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1611',`att18`='France',`attf102`='20241111',`attf103`='1',`attf104`='1',`attf105`='20241111',`att22`='CLI--1',`attdatmod`='202411111413',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '272') AND (id_type = '80') LIMIT 1
UID:1611--141339-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1611',`att18`='France',`attf102`='20241111',`attf103`='1',`attf104`='1',`attf105`='20241111',`att22`='CLI--1',`att16`='THIBERT',`attdatmod`='202411111413',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '272') AND (id_type = '80') LIMIT 1
UID:1611--141425-- UPDATE `tier_att` SET `att3`='Elodie',`att90`='',`att1`='LOUIS-CLEMENCET',`att10`='madame',`att12`='elodie.clemencet@gmail.com',`att14`='',`att15`='',`att7`='',`att17`='',`att6`='06 77 48 40 14',`att5`='',`att11`='prospection_perso',`attdatmod`='202411111414',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '272') AND (id_type = '80') LIMIT 1
UID:1611--141425-- UPDATE `tier_att` SET `att3`='Elodie',`att90`='',`att1`='LOUIS-CLEMENCET',`att10`='madame',`att12`='elodie.clemencet@gmail.com',`att14`='',`att15`='',`att7`='',`att17`='',`att6`='06 77 48 40 14',`att5`='',`att11`='prospection_perso',`att19`='44.918078',`att20`='4.895543',`attdatmod`='202411111414',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '272') AND (id_type = '80') LIMIT 1
UID:1611--141449-- UPDATE `tier_att` SET `att14`='740 route du Moulin de Jonc',`att7`='71260',`att17`='MONTBELLET',`attdatmod`='202411111414',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '272') AND (id_type = '80') LIMIT 1
UID:1611--141449-- UPDATE `tier_att` SET `att14`='740 route du Moulin de Jonc',`att7`='71260',`att17`='MONTBELLET',`att19`='46.482546',`att20`='4.87959',`attdatmod`='202411111414',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '272') AND (id_type = '80') LIMIT 1
UID:1611--141449-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','272','202411111414','202411111414' )
UID:1611--141449-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='740 route du Moulin de Jonc',`lig3`='',`lig4`='71260',`lig5`='MONTBELLET',`lig6`='France',`ligdatmod`='202411111414',`ligusermod`='1611' WHERE 1=1 AND ( id_tier = '272') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '155') LIMIT 1
UID:1611--141449-- UPDATE `tier_att` SET `att14`='740 route du Moulin de Jonc',`att7`='71260',`att17`='MONTBELLET',`att19`='46.482546',`att20`='4.87959',`attf100`='1',`attdatmod`='202411111414',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '272') AND (id_type = '80') LIMIT 1
UID:1611--141627-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202411111416' )
UID:1611--141627-- UPDATE `vent_att` SET `att1`='OPP-',`att2`='',`attf100`='20241111',`att6`='1611',`attdatmod`='202411111416',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '127') AND (id_type = '148') LIMIT 1
UID:1611--141627-- UPDATE `vent_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '148') AND (id_vent = '127') LIMIT 1
UID:1611--141647-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','205','1','202411111416' )
UID:1611--141647-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1611',`att18`='France',`attf102`='20241111',`attf103`='1',`attf104`='1',`attf105`='20241111',`attdatmod`='202411111416',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '273') AND (id_type = '80') LIMIT 1
UID:1611--141647-- UPDATE `tier_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '80') AND (id_tier = '273') LIMIT 1
UID:1611--141648-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1611',`att18`='France',`attf102`='20241111',`attf103`='1',`attf104`='1',`attf105`='20241111',`att22`='CLI--1',`attdatmod`='202411111416',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '273') AND (id_type = '80') LIMIT 1
UID:1611--141648-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1611',`att18`='France',`attf102`='20241111',`attf103`='1',`attf104`='1',`attf105`='20241111',`att22`='CLI--1',`att16`='THIBERT',`attdatmod`='202411111416',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '273') AND (id_type = '80') LIMIT 1
UID:1611--141728-- UPDATE `tier_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '80') AND (id_tier = '273') LIMIT 1
UID:1611--141728-- UPDATE `tier_att` SET `att3`='Elodie',`att90`='',`att1`='LOUIS-CLEMENCET',`att10`='madame',`att12`='elodie.clemencet@gmail.com',`att14`='740 route du Moulin de Jonc',`att15`='',`att7`='71260',`att17`='MONTBELLET',`att6`='06 77 48 40 14',`att5`='',`att11`='prospection_perso',`attdatmod`='202411111417',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '273') AND (id_type = '80') LIMIT 1
UID:1611--141728-- UPDATE `tier_att` SET `att3`='Elodie',`att90`='',`att1`='LOUIS-CLEMENCET',`att10`='madame',`att12`='elodie.clemencet@gmail.com',`att14`='740 route du Moulin de Jonc',`att15`='',`att7`='71260',`att17`='MONTBELLET',`att6`='06 77 48 40 14',`att5`='',`att11`='prospection_perso',`att19`='46.482546',`att20`='4.87959',`attdatmod`='202411111417',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '273') AND (id_type = '80') LIMIT 1
UID:1611--141728-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','273','202411111417','202411111417' )
UID:1611--141728-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='740 route du Moulin de Jonc',`lig3`='',`lig4`='71260',`lig5`='MONTBELLET',`lig6`='France',`ligdatmod`='202411111417',`ligusermod`='1611' WHERE 1=1 AND ( id_tier = '273') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '156') LIMIT 1
UID:1611--141728-- UPDATE `tier_att` SET `att3`='Elodie',`att90`='',`att1`='LOUIS-CLEMENCET',`att10`='madame',`att12`='elodie.clemencet@gmail.com',`att14`='740 route du Moulin de Jonc',`att15`='',`att7`='71260',`att17`='MONTBELLET',`att6`='06 77 48 40 14',`att5`='',`att11`='prospection_perso',`att19`='46.482546',`att20`='4.87959',`attf100`='1',`attdatmod`='202411111417',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '273') AND (id_type = '80') LIMIT 1
UID:1611--141728-- UPDATE `tier_lig` SET `lig2`='1',`ligdatmod`='202411111417',`ligusermod`='1611' WHERE 1=1 AND ( id_tier = '260') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '146') LIMIT 1
UID:1611--141728-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202411111417' )
UID:1611--141728-- UPDATE `tier_att` SET `att2`='LOUIS-CLEMENCET',`att3`='Elodie',`att4`='',`att5`='06 77 48 40 14',`att6`='elodie.clemencet@gmail.com',`att7`='madame',`att8`='273',`att10`='1611',`attdatmod`='202411111417',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '274') AND (id_type = '149') LIMIT 1
UID:1611--141728-- UPDATE `tier_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '149') AND (id_tier = '274') LIMIT 1
UID:1611--141742-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202411111417' )
UID:1611--141742-- UPDATE `vent_att` SET `att1`='OPP-',`att2`='',`attf100`='20241111',`att6`='1611',`attdatmod`='202411111417',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '128') AND (id_type = '148') LIMIT 1
UID:1611--141742-- UPDATE `vent_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '148') AND (id_vent = '128') LIMIT 1
UID:1611--141746-- UPDATE `vent_att` SET `att2`='273',`att8`='',`att9`='',`att3`='',`attdatmod`='202411111417',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '128') AND (id_type = '148') LIMIT 1
UID:1611--141746-- UPDATE `vent_att` SET `att2`='273',`att8`='',`att9`='',`att3`='',`att1`='OPP-LOUIS-CLEMENCET',`attdatmod`='202411111417',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '128') AND (id_type = '148') LIMIT 1
UID:1611--141746-- UPDATE `vent_att` SET `att2`='273',`att8`='',`att9`='',`att3`='',`att1`='OPP-LOUIS-CLEMENCET',`att5`='',`att10`='particulier',`attdatmod`='202411111417',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '128') AND (id_type = '148') LIMIT 1
UID:1611--141755-- UPDATE `vent_att` SET `att8`='156',`att9`='274',`att3`='assainissement',`attdatmod`='202411111417',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '128') AND (id_type = '148') LIMIT 1
UID:1611--141809-- UPDATE `vent_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '148') AND (id_vent = '128') LIMIT 1
UID:1611--141831-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','165','410','1','202411111418' )
UID:1611--141831-- UPDATE `vent_att` SET `att1`='128',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241111',`att43`='Remise TTC',`attdatmod`='202411111418',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '129') AND (id_type = '165') LIMIT 1
UID:1611--141831-- UPDATE `vent_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '165') AND (id_vent = '129') LIMIT 1
UID:1611--141831-- UPDATE `vent_att` SET `att1`='128',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241111',`att43`='Remise TTC',`att2`='273',`attdatmod`='202411111418',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '129') AND (id_type = '165') LIMIT 1
UID:1611--141831-- UPDATE `vent_att` SET `att1`='128',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241211',`att43`='Remise TTC',`att2`='273',`attdatmod`='202411111418',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '129') AND (id_type = '165') LIMIT 1
UID:1611--141831-- UPDATE `vent_att` SET `att1`='128',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241211',`att43`='Remise TTC',`att2`='273',`att13`='xcpry6w-7alfgp9l',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/xcpry6w-7alfgp9l',`attdatmod`='202411111418',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '129') AND (id_type = '165') LIMIT 1
UID:1611--141831-- UPDATE `vent_att` SET `att1`='128',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241211',`att43`='Remise TTC',`att2`='273',`att13`='xcpry6w-7alfgp9l',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/xcpry6w-7alfgp9l',`att4`='DEV--1',`attdatmod`='202411111418',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '129') AND (id_type = '165') LIMIT 1
UID:1611--141831-- UPDATE `vent_att` SET `att1`='128',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241211',`att43`='Remise TTC',`att2`='273',`att13`='xcpry6w-7alfgp9l',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/xcpry6w-7alfgp9l',`att4`='DEV--1',`att18`='Rainea Rainéa Saône et Bresse
42 Rue Tourneloup
71000 MÂCON
setbresse@rainea.fr
www.rainea.fr',`att19`=' 740 route du Moulin de Jonc 71260 MONTBELLET',`att20`=' 740 route du Moulin de Jonc 71260 MONTBELLET',`att22`=' Rainea Rainéa Saône et Bresse
SASU au captial de € - SIREN 934700352 - RCS : Mâcon\n
TVA : FR42934700352
IBAN : - BIC : ',`att31`='740 route du Moulin de Jonc',`att33`='71260',`att34`='MONTBELLET',`att35`='France',`att38`='740 route du Moulin de Jonc',`att40`='71260',`att41`='MONTBELLET',`att42`='France',`attdatmod`='202411111418',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '129') AND (id_type = '165') LIMIT 1
UID:1611--141838-- UPDATE `vent_att` SET `att15`='',`att45`='',`att26`='',`attdatmod`='202411111418',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '129') AND (id_type = '165') LIMIT 1
UID:1611--141901-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','129','202411111419','202411111419' )
UID:1611--141901-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111419',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '129') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '231') LIMIT 1
UID:1611--141901-- UPDATE `vent_att` SET `att15`='virement',`att45`='30% à la commande, solde fin de chantier.',`attdatmod`='202411111419',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '129') AND (id_type = '165') LIMIT 1
UID:1611--141902-- UPDATE `vent_att` SET `att15`='virement',`att45`='30% à la commande, solde fin de chantier.',`att7`='0',`att8`='0',`att21`='0',`att9`='0',`att27`='0',`att29`='0',`att28`='0',`att30`='0',`attdatmod`='202411111419',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '129') AND (id_type = '165') LIMIT 1
UID:1611--142015-- UPDATE `vent_lig` SET `lig10`='5995',`ligdatmod`='202411111420',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '129') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '231') LIMIT 1
UID:1611--142016-- UPDATE `vent_lig` SET `lig10`='5995',`lig6`='770.00',`lig13`='0.00',`lig16`='0',`lig17`='7700',`lig18`='770',`lig19`='5700.00',`lig2`='7700.00',`lig5`='10',`lig4`='7700.00',`lig7`='8470.00',`lig9`='',`lig14`='0',`lig15`='8470.00',`lig90`='<p><b>Fourniture et mise en service d\'une filière compacte ECOFLO PE LIGNE 8EH sortie BASSE comprenant :</b></p><p><br></p><p>- Une fosse toutes eaux de 4m3 équipée d\'un préfiltre PF17 permettant de piéger les matières et de protéger le filtre ECOFLO.</p><p>- Un filtre compact 8EH composé de fragments de coco</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.<br></p><p><br></p><p>- Fabrication Française disposant d\'un agrément Ministériel n° 2016-003-ext11 et conforme à la Norme NF-EN 12566-3+A1 et à l\'arrêté du 7 septembre 2009.</p>',`ligdatmod`='202411111420',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '129') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '231') LIMIT 1
UID:1611--142016-- UPDATE `vent_att` SET `att7`='7700',`att8`='770',`att21`='8470',`att9`='8470',`att27`='0',`att29`='0',`att28`='7700',`att30`='770',`attdatmod`='202411111420',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '129') AND (id_type = '165') LIMIT 1
UID:1611--142020-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','129','202411111420','202411111420' )
UID:1611--142020-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111420',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '129') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '232') LIMIT 1
UID:1611--142020-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411111420',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '129') AND (id_type = '165') LIMIT 1
UID:1611--142050-- UPDATE `vent_lig` SET `actif`='0' WHERE 1=1 AND (id_vent = '129') AND (id_type = '165') AND (id_tlig = '162') AND (id_lig = '232')
UID:1611--142050-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411111420',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '129') AND (id_type = '165') LIMIT 1
UID:1611--142057-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','129','202411111420','202411111420' )
UID:1611--142057-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111420',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '129') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '233') LIMIT 1
UID:1611--142058-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411111420',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '129') AND (id_type = '165') LIMIT 1
UID:1611--142128-- UPDATE `vent_lig` SET `lig10`='5926',`ligdatmod`='202411111421',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '129') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '233') LIMIT 1
UID:1611--142128-- UPDATE `vent_lig` SET `lig10`='5926',`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 Ecoflo 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 ECOFLO®.</p><p>- Le raccordement de la filière vers l\'exutoire.</p><p>- L\'implantation du système ECOFLO®.</p><p>- Le raccordement à la ventilation secondaire.</p><p>- Le piquage en sortie de système ECOFLO® 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`='202411111421',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '129') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '233') LIMIT 1
UID:1611--142129-- UPDATE `vent_att` SET `att7`='11150',`att8`='1115',`att21`='12265',`att9`='12265',`att27`='0',`att29`='0',`att28`='11150',`att30`='1115',`attdatmod`='202411111421',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '129') AND (id_type = '165') LIMIT 1
UID:1611--142134-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','129','202411111421','202411111421' )
UID:1611--142134-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111421',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '129') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '234') LIMIT 1
UID:1611--142134-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411111421',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '129') AND (id_type = '165') LIMIT 1
UID:1611--142200-- UPDATE `vent_lig` SET `lig10`='5973',`ligdatmod`='202411111422',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '129') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '234') LIMIT 1
UID:1611--142200-- UPDATE `vent_lig` SET `lig10`='5973',`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>Pose d\'un filtre compact Ecoflo comprenant :</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 ECOFLO®.</p><p>- Le raccordement de la filière vers l\'exutoire.</p><p>- L\'implantation du système ECOFLO®.</p><p>- Le raccordement à la ventilation secondaire.</p><p>- Le piquage en sortie de système ECOFLO® 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><u>Travaux à prévoir par le client :</u></p><p><br></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`='202411111422',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '129') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '234') LIMIT 1
UID:1611--142200-- UPDATE `vent_att` SET `att7`='14600',`att8`='1460',`att21`='16060',`att9`='16060',`att27`='0',`att29`='0',`att28`='14600',`att30`='1460',`attdatmod`='202411111422',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '129') AND (id_type = '165') LIMIT 1
UID:1611--142226-- UPDATE `vent_lig` SET `actif`='0' WHERE 1=1 AND (id_vent = '129') AND (id_type = '165') AND (id_tlig = '162') AND (id_lig = '234')
UID:1611--142226-- UPDATE `vent_att` SET `att7`='11150',`att8`='1115',`att21`='12265',`att9`='12265',`att27`='0',`att29`='0',`att28`='11150',`att30`='1115',`attdatmod`='202411111422',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '129') AND (id_type = '165') LIMIT 1
UID:1611--142331-- UPDATE `vent_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '165') AND (id_vent = '129') LIMIT 1
UID:1611--142331-- UPDATE `tier_lig` SET `lig2`='1',`ligdatmod`='202411111423',`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--142331-- UPDATE `vent_att` SET `att24`='Rainéa Saône et Bresse
42 Rue Tourneloup
71000 MÂCON
0744306670
setbresse@rainea.fr
www.rainea.fr
Rainea Rainéa Saône et Bresse
42 Rue Tourneloup
71000 MÂCON
setbresse@rainea.fr
www.rainea.fr',`att19`=' 740 route du Moulin de Jonc 71260 MONTBELLET',`att20`=' 740 route du Moulin de Jonc 71260 MONTBELLET',`att22`=' Rainea Rainéa Saône et Bresse
SASU au captial de € - SIREN 934700352 - RCS : Mâcon\n
TVA : FR42934700352
IBAN : - BIC : ',`att31`='740 route du Moulin de Jonc',`att33`='71260',`att34`='MONTBELLET',`att35`='France',`att38`='740 route du Moulin de Jonc',`att40`='71260',`att41`='MONTBELLET',`att42`='France',`attdatmod`='202411111536',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '131') AND (id_type = '165') LIMIT 1
UID:1611--153629-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','131','202411111536','202411111536' )
UID:1611--153629-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111536',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '131') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '238') LIMIT 1
UID:1611--153629-- UPDATE `vent_att` SET `att15`='virement',`att45`='30% à la commande, solde fin de chantier.',`att26`='',`attdatmod`='202411111536',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '131') AND (id_type = '165') LIMIT 1
UID:1611--153629-- 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`='202411111536',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '131') AND (id_type = '165') LIMIT 1
UID:1611--153655-- UPDATE `vent_lig` SET `lig10`='5911',`ligdatmod`='202411111536',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '131') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '238') LIMIT 1
UID:1611--153655-- UPDATE `vent_lig` SET `lig10`='5911',`lig6`='994.00',`lig13`='0.00',`lig16`='0',`lig17`='9940',`lig18`='994',`lig19`='0.00',`lig2`='9940.00',`lig5`='10',`lig4`='9940.00',`lig7`='10934.00',`lig9`='',`lig14`='0',`lig15`='10934.00',`lig90`='<p><b>Fourniture d\'un filtre ENVIROSEPTIC drainé 14EH comprenant:</b></p><p><u><i>(NB: filtre à associer à une fosse toutes eaux 7m3 non fournie)</i></u></p><p><br></p><p>- livraison du matériel.</p><p>- Les Conduites Advanced Enviroseptic.</p><p>- Regard de répartition.</p><p>- Pack étanchéité.</p><p>- Clarinette, raccords pour la répartition et la ventilation.</p><p><br></p><p>- Mise en service, réglage des égalisateurs.</p><p><br></p><p>- Garantie 20 ans.</p><p><br></p><p>- Filière disposant d\'un agrément Ministériel n° 2012-011-mod03 et conforme à la Norme NF-EN 12566-3+A1 et à l\'arrêté du 7 septembre 2009.</p><p><br></p><p>Le Système Enviroseptic est une technologie passive qui facilite la prolifération de bactéries permettant le traitement des eaux usées.</p><p>Il comporte deux composantes principales indissociables : les rangées de conduites Advanced Enviroseptic et une couche de sable filtrant.</p>',`ligdatmod`='202411111536',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '131') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '238') LIMIT 1
UID:1611--153655-- UPDATE `vent_att` SET `att7`='9940',`att8`='994',`att21`='10934',`att9`='10934',`att27`='0',`att29`='0',`att28`='9940',`att30`='994',`attdatmod`='202411111536',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '131') AND (id_type = '165') LIMIT 1
UID:1611--153700-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','131','202411111537','202411111537' )
UID:1611--153700-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111537',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '131') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '239') LIMIT 1
UID:1611--153701-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411111537',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '131') AND (id_type = '165') LIMIT 1
UID:1611--153804-- UPDATE `vent_lig` SET `lig10`='5929',`ligdatmod`='202411111538',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '131') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '239') LIMIT 1
UID:1611--153804-- UPDATE `vent_lig` SET `lig10`='5929',`lig6`='70.00',`lig13`='0.00',`lig16`='0',`lig17`='700',`lig18`='70',`lig19`='0.00',`lig2`='700.00',`lig5`='10',`lig4`='700.00',`lig7`='770.00',`lig9`='',`lig14`='0',`lig15`='770.00',`lig90`='<p><b>Fosse toutes eaux renforcée SOTRALENTZ Epurbloc PE HD 3000L pour le traitement des eaux usées avec préfiltre</b></p><p><b><br></b></p><p>Conforme à l\'arrêté technique du 7 septembre 2009 modifié par l\'arrêté du 7 mars 2012, à la norme NF DTU 64.1, à la norme NF-EN 12566-1+A1</p><p><br></p><p>Garantie 10 ans</p>',`ligdatmod`='202411111538',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '131') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '239') LIMIT 1
UID:1611--153804-- UPDATE `vent_att` SET `att7`='10640',`att8`='1064',`att21`='11704',`att9`='11704',`att27`='0',`att29`='0',`att28`='10640',`att30`='1064',`attdatmod`='202411111538',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '131') AND (id_type = '165') LIMIT 1
UID:1611--153825-- UPDATE `vent_lig` SET `actif`='0' WHERE 1=1 AND (id_vent = '131') AND (id_type = '165') AND (id_tlig = '162') AND (id_lig = '238')
UID:1611--153825-- UPDATE `vent_att` SET `att7`='700',`att8`='70',`att21`='770',`att9`='770',`att27`='0',`att29`='0',`att28`='700',`att30`='70',`attdatmod`='202411111538',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '131') AND (id_type = '165') LIMIT 1
UID:1611--153828-- UPDATE `vent_lig` SET `actif`='0' WHERE 1=1 AND (id_vent = '131') AND (id_type = '165') AND (id_tlig = '162') AND (id_lig = '239')
UID:1611--153828-- UPDATE `vent_att` SET `att7`='0',`att8`='0',`att21`='0',`att9`='0',`att27`='0',`att29`='0',`att28`='0',`att30`='0',`attdatmod`='202411111538',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '131') AND (id_type = '165') LIMIT 1
UID:1611--153830-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','131','202411111538','202411111538' )
UID:1611--153830-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111538',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '131') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '240') LIMIT 1
UID:1611--153831-- UPDATE `vent_att` SET `att7`='0',`att8`='0',`att21`='0',`att9`='0',`att27`='0',`att29`='0',`att28`='0',`att30`='0',`attdatmod`='202411111538',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '131') AND (id_type = '165') LIMIT 1
UID:1611--153857-- UPDATE `vent_lig` SET `lig10`='5911',`ligdatmod`='202411111538',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '131') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '240') LIMIT 1
UID:1611--153857-- UPDATE `vent_lig` SET `lig10`='5911',`lig6`='994.00',`lig13`='0.00',`lig16`='0',`lig17`='9940',`lig18`='994',`lig19`='0.00',`lig2`='9940.00',`lig5`='10',`lig4`='9940.00',`lig7`='10934.00',`lig9`='',`lig14`='0',`lig15`='10934.00',`lig90`='<p><b>Fourniture d\'un filtre ENVIROSEPTIC drainé 14EH comprenant:</b></p><p><u><i>(NB: filtre à associer à une fosse toutes eaux 7m3 non fournie)</i></u></p><p><br></p><p>- livraison du matériel.</p><p>- Les Conduites Advanced Enviroseptic.</p><p>- Regard de répartition.</p><p>- Pack étanchéité.</p><p>- Clarinette, raccords pour la répartition et la ventilation.</p><p><br></p><p>- Mise en service, réglage des égalisateurs.</p><p><br></p><p>- Garantie 20 ans.</p><p><br></p><p>- Filière disposant d\'un agrément Ministériel n° 2012-011-mod03 et conforme à la Norme NF-EN 12566-3+A1 et à l\'arrêté du 7 septembre 2009.</p><p><br></p><p>Le Système Enviroseptic est une technologie passive qui facilite la prolifération de bactéries permettant le traitement des eaux usées.</p><p>Il comporte deux composantes principales indissociables : les rangées de conduites Advanced Enviroseptic et une couche de sable filtrant.</p>',`ligdatmod`='202411111538',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '131') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '240') LIMIT 1
UID:1611--153857-- UPDATE `vent_att` SET `att7`='9940',`att8`='994',`att21`='10934',`att9`='10934',`att27`='0',`att29`='0',`att28`='9940',`att30`='994',`attdatmod`='202411111538',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '131') AND (id_type = '165') LIMIT 1
UID:1611--153902-- UPDATE `vent_lig` SET `actif`='0' WHERE 1=1 AND (id_vent = '131') AND (id_type = '165') AND (id_tlig = '162') AND (id_lig = '240')
UID:1611--153902-- UPDATE `vent_att` SET `att7`='0',`att8`='0',`att21`='0',`att9`='0',`att27`='0',`att29`='0',`att28`='0',`att30`='0',`attdatmod`='202411111539',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '131') AND (id_type = '165') LIMIT 1
UID:1611--153903-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','131','202411111539','202411111539' )
UID:1611--153903-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111539',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '131') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '241') LIMIT 1
UID:1611--153904-- UPDATE `vent_att` SET `att7`='0',`att8`='0',`att21`='0',`att9`='0',`att27`='0',`att29`='0',`att28`='0',`att30`='0',`attdatmod`='202411111539',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '131') AND (id_type = '165') LIMIT 1
UID:1611--154448-- UPDATE `vent_lig` SET `lig10`='5988',`ligdatmod`='202411111544',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '131') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '241') LIMIT 1
UID:1611--154448-- UPDATE `vent_lig` SET `lig10`='5988',`lig6`='1100.00',`lig13`='0.00',`lig16`='0',`lig17`='11000',`lig18`='1100',`lig19`='9046.00',`lig2`='11000.00',`lig5`='10',`lig4`='11000.00',`lig7`='12100.00',`lig9`='',`lig14`='0',`lig15`='12100.00',`lig90`='<p><b>Fourniture d\'une filière compacte ECOFLO PE LIGNE 14EH sortie HAUTE comprenant :</b></p><p><br></p><p>- Une fosse toutes eaux de 8m3 équipée d\'un préfiltre PF17 permettant de piéger les matières et de protéger le filtre ECOFLO.</p><p>- Un filtre compact 14EH composé de fragments de coco.</p><p>- Un poste de relevage intégré équipé d\'une alarme sonore et visuelle.</p><p><br></p><p><u>Les Prestations :\r\n</u></p><p>\r\n</p><p><br></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>- Pose alarme pompe et test fonctionnement. </p><p><br></p><p>- Garantie 10 ans (hors matériel électrique).</p><p><br></p><p>- Fabrication Française disposant d\'un agrément Ministériel n° 2016-003-ext11 et conforme à la Norme NF-EN 12566-3+A1 et à l\'arrêté du 7 septembre 2009.</p>',`ligdatmod`='202411111544',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '131') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '241') LIMIT 1
UID:1611--154449-- UPDATE `vent_att` SET `att7`='11000',`att8`='1100',`att21`='12100',`att9`='12100',`att27`='0',`att29`='0',`att28`='11000',`att30`='1100',`attdatmod`='202411111544',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '131') AND (id_type = '165') LIMIT 1
UID:1611--154454-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','131','202411111544','202411111544' )
UID:1611--154454-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111544',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '131') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '242') LIMIT 1
UID:1611--154455-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411111544',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '131') AND (id_type = '165') LIMIT 1
UID:1611--154505-- UPDATE `vent_lig` SET `lig10`='5989',`ligdatmod`='202411111545',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '131') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '242') LIMIT 1
UID:1611--154505-- UPDATE `vent_lig` SET `lig10`='5989',`lig6`='1058.00',`lig13`='0.00',`lig16`='0',`lig17`='10580',`lig18`='1058',`lig19`='8584.00',`lig2`='10580.00',`lig5`='10',`lig4`='10580.00',`lig7`='11638.00',`lig9`='',`lig14`='0',`lig15`='11638.00',`lig90`='<p><b>Fourniture et mise en service d\'une filière compacte ECOFLO PE LIGNE 14EH sortie BASSE comprenant :</b></p><p><br></p><p>- Une fosse toutes eaux de 8m3 équipée d\'un préfiltre PF17 permettant de piéger les matières et de protéger le filtre ECOFLO.</p><p>- Un filtre compact 14EH composé de fragments de coco.</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.<br></p><p><br></p><p>- Fabrication Française disposant d\'un agrément Ministériel n° 2016-003-ext11 et conforme à la Norme NF-EN 12566-3+A1 et à l\'arrêté du 7 septembre 2009.</p><p><br></p>',`ligdatmod`='202411111545',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '131') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '242') LIMIT 1
UID:1611--154505-- UPDATE `vent_att` SET `att7`='21580',`att8`='2158',`att21`='23738',`att9`='23738',`att27`='0',`att29`='0',`att28`='21580',`att30`='2158',`attdatmod`='202411111545',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '131') AND (id_type = '165') LIMIT 1
UID:1611--154513-- UPDATE `vent_lig` SET `actif`='0' WHERE 1=1 AND (id_vent = '131') AND (id_type = '165') AND (id_tlig = '162') AND (id_lig = '242')
UID:1611--154514-- UPDATE `vent_att` SET `att7`='11000',`att8`='1100',`att21`='12100',`att9`='12100',`att27`='0',`att29`='0',`att28`='11000',`att30`='1100',`attdatmod`='202411111545',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '131') AND (id_type = '165') LIMIT 1
UID:1611--154527-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','131','202411111545','202411111545' )
UID:1611--154527-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111545',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '131') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '243') LIMIT 1
UID:1611--154528-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411111545',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '131') AND (id_type = '165') LIMIT 1
UID:1611--154817-- UPDATE `vent_lig` SET `lig10`='5926',`ligdatmod`='202411111548',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '131') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '243') LIMIT 1
UID:1611--154817-- UPDATE `vent_lig` SET `lig10`='5926',`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 Ecoflo 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 ECOFLO®.</p><p>- Le raccordement de la filière vers l\'exutoire.</p><p>- L\'implantation du système ECOFLO®.</p><p>- Le raccordement à la ventilation secondaire.</p><p>- Le piquage en sortie de système ECOFLO® 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`='202411111548',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '131') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '243') LIMIT 1
UID:1611--154817-- UPDATE `vent_att` SET `att7`='14450',`att8`='1445',`att21`='15895',`att9`='15895',`att27`='0',`att29`='0',`att28`='14450',`att30`='1445',`attdatmod`='202411111548',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '131') AND (id_type = '165') LIMIT 1
UID:1611--154821-- UPDATE `vent_lig` SET `lig5`='',`ligdatmod`='202411111548',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '131') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '241') LIMIT 1
UID:1611--154821-- UPDATE `vent_lig` SET `lig5`='0',`lig6`='0.00',`lig18`='0',`lig7`='11000.00',`lig15`='11000.00',`ligdatmod`='202411111548',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '131') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '241') LIMIT 1
UID:1611--154821-- UPDATE `vent_att` SET `att8`='345',`att21`='14795',`att9`='14795',`att27`='0',`att29`='0',`att30`='345',`attdatmod`='202411111548',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '131') AND (id_type = '165') LIMIT 1
UID:1611--154824-- UPDATE `vent_lig` SET `lig5`='20',`ligdatmod`='202411111548',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '131') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '241') LIMIT 1
UID:1611--154824-- UPDATE `vent_lig` SET `lig5`='20',`lig6`='2200.00',`lig18`='2200',`lig7`='13200.00',`lig15`='13200.00',`ligdatmod`='202411111548',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '131') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '241') LIMIT 1
UID:1611--154824-- UPDATE `vent_att` SET `att8`='2545',`att21`='16995',`att9`='16995',`att27`='0',`att29`='0',`att30`='2545',`attdatmod`='202411111548',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '131') AND (id_type = '165') LIMIT 1
UID:1611--154827-- UPDATE `vent_lig` SET `lig5`='20',`ligdatmod`='202411111548',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '131') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '243') LIMIT 1
UID:1611--154827-- UPDATE `vent_lig` SET `lig5`='20',`lig6`='690.00',`lig18`='690',`lig7`='4140.00',`lig15`='4140.00',`ligdatmod`='202411111548',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '131') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '243') LIMIT 1
UID:1611--154827-- UPDATE `vent_att` SET `att8`='2890',`att21`='17340',`att9`='17340',`att27`='0',`att29`='0',`att30`='2890',`attdatmod`='202411111548',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '131') AND (id_type = '165') LIMIT 1
UID:1611--154849-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','131','202411111548','202411111548' )
UID:1611--154849-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111548',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '131') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '244') LIMIT 1
UID:1611--154850-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411111548',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '131') AND (id_type = '165') LIMIT 1
UID:1611--154917-- UPDATE `vent_lig` SET `actif`='0' WHERE 1=1 AND (id_vent = '131') AND (id_type = '165') AND (id_tlig = '162') AND (id_lig = '244')
UID:1611--154917-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411111549',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '131') AND (id_type = '165') LIMIT 1
UID:1611--155642-- UPDATE `vent_att` SET `att94`='<p>Ce devis ne comprend pas le(s) bac(s) à graisse susceptible(s) d\'être requis par le SPANC.</p><p>Sous réserve de la validation de la filière d\'assainissement de la part du SPANC.</p>',`attdatmod`='202411111556',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '131') AND (id_type = '165') LIMIT 1
UID:1611--155642-- UPDATE `vent_lig` SET `lig2`='4950.00',`ligdatmod`='202411111556',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '131') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '243') LIMIT 1
UID:1611--155642-- UPDATE `vent_lig` SET `lig2`='4950.00',`lig6`='990.00',`lig17`='4950',`lig18`='990',`lig4`='4950.00',`lig7`='5940.00',`lig15`='5940.00',`ligdatmod`='202411111556',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '131') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '243') LIMIT 1
UID:1611--155642-- UPDATE `vent_att` SET `att94`='<p>Ce devis ne comprend pas le(s) bac(s) à graisse susceptible(s) d\'être requis par le SPANC.</p><p>Sous réserve de la validation de la filière d\'assainissement de la part du SPANC.</p>',`att7`='15950',`att8`='3190',`att21`='19140',`att9`='19140',`att27`='0',`att29`='0',`att28`='15950',`att30`='3190',`attdatmod`='202411111556',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '131') AND (id_type = '165') LIMIT 1
UID:1611--155915-- UPDATE `vent_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '165') AND (id_vent = '131') LIMIT 1
UID:1611--155915-- UPDATE `vent_att` SET `att94`='<p>Ouvrage concerné : 7 logements locatifs.</p><p>Ce devis ne comprend pas le(s) bac(s) à graisse susceptible(s) d\'être requis par le SPANC.</p><p>Sous réserve de la validation de la filière d\'assainissement de la part du SPANC.</p>',`attdatmod`='202411111559',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '131') AND (id_type = '165') LIMIT 1
UID:1611--155915-- UPDATE `tier_lig` SET `lig2`='2',`ligdatmod`='202411111559',`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--155915-- UPDATE `vent_att` SET `att94`='<p>Ouvrage concerné : 7 logements locatifs.</p><p>Ce devis ne comprend pas le(s) bac(s) à graisse susceptible(s) d\'être requis par le SPANC.</p><p>Sous réserve de la validation de la filière d\'assainissement de la part du SPANC.</p>',`att24`='Rainéa Saône et Bresse
42 Rue Tourneloup
71000 MÂCON
0744306670
setbresse@rainea.fr
www.rainea.fr
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 € - SIREN 934700352 - RCS : Mâcon\n
TVA : FR42934700352
IBAN : - BIC : ',`att31`='435 Villemaison',`att33`='71130',`att34`='UXEAU',`att35`='France',`att38`='435 Villemaison',`att40`='71130',`att41`='UXEAU',`att42`='France',`attdatmod`='202411111627',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '133') AND (id_type = '165') LIMIT 1
UID:1611--162751-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','133','202411111627','202411111627' )
UID:1611--162751-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111627',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '133') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '245') LIMIT 1
UID:1611--162751-- UPDATE `vent_att` SET `att15`='virement',`att45`='30% à la commande, solde fin de chantier.',`att26`='',`attdatmod`='202411111627',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '133') AND (id_type = '165') LIMIT 1
UID:1611--162752-- 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`='202411111627',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '133') AND (id_type = '165') LIMIT 1
UID:1611--163037-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','165','410','1','202411111630' )
UID:1611--163037-- UPDATE `vent_att` SET `att1`='132',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241111',`att43`='Remise TTC',`attdatmod`='202411111630',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '134') AND (id_type = '165') LIMIT 1
UID:1611--163037-- UPDATE `vent_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '165') AND (id_vent = '134') LIMIT 1
UID:1611--163037-- UPDATE `vent_att` SET `att1`='132',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241111',`att43`='Remise TTC',`att2`='275',`attdatmod`='202411111630',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '134') AND (id_type = '165') LIMIT 1
UID:1611--163037-- UPDATE `vent_att` SET `att1`='132',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241211',`att43`='Remise TTC',`att2`='275',`attdatmod`='202411111630',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '134') AND (id_type = '165') LIMIT 1
UID:1611--163037-- UPDATE `vent_att` SET `att1`='132',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241211',`att43`='Remise TTC',`att2`='275',`att13`='hq7s6akpqdy8ug6p',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/hq7s6akpqdy8ug6p',`attdatmod`='202411111630',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '134') AND (id_type = '165') LIMIT 1
UID:1611--163037-- UPDATE `vent_att` SET `att1`='132',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241211',`att43`='Remise TTC',`att2`='275',`att13`='hq7s6akpqdy8ug6p',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/hq7s6akpqdy8ug6p',`att4`='DEV--3',`attdatmod`='202411111630',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '134') AND (id_type = '165') LIMIT 1
UID:1611--163037-- UPDATE `vent_att` SET `att1`='132',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241211',`att43`='Remise TTC',`att2`='275',`att13`='hq7s6akpqdy8ug6p',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/hq7s6akpqdy8ug6p',`att4`='DEV--3',`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 € - SIREN 934700352 - RCS : Mâcon\n
TVA : FR42934700352
IBAN : - BIC : ',`att31`='435 Villemaison',`att33`='71130',`att34`='UXEAU',`att35`='France',`att38`='435 Villemaison',`att40`='71130',`att41`='UXEAU',`att42`='France',`attdatmod`='202411111630',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '134') AND (id_type = '165') LIMIT 1
UID:1611--163046-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','134','202411111630','202411111630' )
UID:1611--163046-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111630',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '134') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '246') LIMIT 1
UID:1611--163046-- UPDATE `vent_att` SET `att15`='virement',`att45`='30% à la commande, solde fin de chantier.',`att26`='',`attdatmod`='202411111630',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '134') AND (id_type = '165') LIMIT 1
UID:1611--163046-- 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`='202411111630',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '134') AND (id_type = '165') LIMIT 1
UID:1611--163129-- UPDATE `vent_lig` SET `lig10`='5959',`ligdatmod`='202411111631',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '134') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '246') LIMIT 1
UID:1611--163129-- 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`='202411111631',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '134') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '246') LIMIT 1
UID:1611--163130-- UPDATE `vent_att` SET `att7`='6460',`att8`='646',`att21`='7106',`att9`='7106',`att27`='0',`att29`='0',`att28`='6460',`att30`='646',`attdatmod`='202411111631',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '134') AND (id_type = '165') LIMIT 1
UID:1611--163137-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','134','202411111631','202411111631' )
UID:1611--163137-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111631',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '134') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '247') LIMIT 1
UID:1611--163138-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411111631',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '134') AND (id_type = '165') LIMIT 1
UID:1611--163147-- UPDATE `vent_lig` SET `lig10`='5925',`ligdatmod`='202411111631',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '134') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '247') LIMIT 1
UID:1611--163147-- 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`='202411111631',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '134') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '247') LIMIT 1
UID:1611--163147-- UPDATE `vent_att` SET `att7`='9910',`att8`='991',`att21`='10901',`att9`='10901',`att27`='0',`att29`='0',`att28`='9910',`att30`='991',`attdatmod`='202411111631',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '134') AND (id_type = '165') LIMIT 1
UID:1611--163245-- UPDATE `vent_lig` SET `lig2`='7060.00',`ligdatmod`='202411111632',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '134') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '246') LIMIT 1
UID:1611--163245-- UPDATE `vent_lig` SET `lig2`='7060.00',`lig6`='706.00',`lig17`='7060',`lig18`='706',`lig4`='7060.00',`lig7`='7766.00',`lig15`='7766.00',`ligdatmod`='202411111632',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '134') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '246') LIMIT 1
UID:1611--163245-- UPDATE `vent_att` SET `att7`='10510',`att8`='1051',`att21`='11561',`att9`='11561',`att27`='0',`att29`='0',`att28`='10510',`att30`='1051',`attdatmod`='202411111632',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '134') AND (id_type = '165') LIMIT 1
UID:1611--163331-- UPDATE `vent_lig` SET `lig2`='3950.00',`ligdatmod`='202411111633',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '134') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '247') LIMIT 1
UID:1611--163331-- UPDATE `vent_lig` SET `lig2`='3950.00',`lig6`='395.00',`lig17`='3950',`lig18`='395',`lig4`='3950.00',`lig7`='4345.00',`lig15`='4345.00',`ligdatmod`='202411111633',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '134') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '247') LIMIT 1
UID:1611--163332-- UPDATE `vent_att` SET `att7`='11010',`att8`='1101',`att21`='12111',`att9`='12111',`att27`='0',`att29`='0',`att28`='11010',`att30`='1101',`attdatmod`='202411111633',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '134') AND (id_type = '165') LIMIT 1
UID:1611--163502-- UPDATE `vent_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '165') AND (id_vent = '134') LIMIT 1
UID:1611--163502-- UPDATE `vent_att` SET `att94`='<p>Ce devis ne comprend pas le bac à graisse de 500 litres requis par le SPANC (cet article sera chiffré ultérieurement).</p><p>Sous réserve de la validation de la filière d\'assainissement par le SPANC.</p><p>\r\n</p>',`attdatmod`='202411111635',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '134') AND (id_type = '165') LIMIT 1
UID:1611--163502-- UPDATE `tier_lig` SET `lig2`='3',`ligdatmod`='202411111635',`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--163502-- UPDATE `vent_att` SET `att94`='<p>Ce devis ne comprend pas le bac à graisse de 500 litres requis par le SPANC (cet article sera chiffré ultérieurement).</p><p>Sous réserve de la validation de la filière d\'assainissement par le SPANC.</p><p>\r\n</p>',`att24`='Rainéa Saône et Bresse
42 Rue Tourneloup
71000 MÂCON
0744306670
setbresse@rainea.fr
www.rainea.fr
\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\"](\"https://rainea.toosmart.app/data/TOOSMART_RAINEA/logo_1.png\") \r\n \r\n \r\n\r\n \r\n Proposition pour votre installation (Devis N° DEV--3)\r\n \r\n\r\n \r\n Bonjour monsieur TEMMERMAN,
\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 ![\"Bannière\"](\"https://object-storage.toosmart.app/signaturerainea/raineasaoneetbresse.png\") \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_rainea/data/tmp/Devis_DEV--3.pdf§Devis_DEV--3.pdf','0','v2017b' )
UID:1611--163729-- UPDATE `email` SET `type`='',`bcc`='' WHERE 1=1 AND (id_email = '160') LIMIT 1
UID:1611--163729-- UPDATE `vent_att` SET `attf104`='20241111',`id_work`='411',`attdatmod`='202411111637',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '134') AND (id_type = '165') LIMIT 1
UID:1611--163729-- UPDATE `vent_att` SET `attf104`='20241111',`id_work`='411',`attf106`='20241111',`attdatmod`='202411111637',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '134') AND (id_type = '165') LIMIT 1
UID:1611--164015-- UPDATE `vent_att` SET `att3`='',`attdatmod`='202411111640',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '134') AND (id_type = '165') LIMIT 1
UID:1611--164531-- UPDATE `vent_att` SET `id_work`='420' WHERE 1=1 AND ( id_vent = '134') AND ( id_type = '165') LIMIT 1
UID:1611--164531-- INSERT INTO `vent_sta` (`id_vent`,`id_work_fr`,`id_work_to`,`datee`,`timee`,`id_user` ) VALUES ('134','411','420','20241111','164531','1611' )
UID:1611--164531-- UPDATE `vent_att` SET `id_work`='418',`attdatmod`='202411111645',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '132') AND (id_type = '148') LIMIT 1
UID:1611--164545-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','165','410','1','202411111645' )
UID:1611--164545-- UPDATE `vent_att` SET `att1`='132',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241111',`att43`='Remise TTC',`attdatmod`='202411111645',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '135') AND (id_type = '165') LIMIT 1
UID:1611--164545-- UPDATE `vent_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '165') AND (id_vent = '135') LIMIT 1
UID:1611--164545-- UPDATE `vent_att` SET `att1`='132',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241111',`att43`='Remise TTC',`att2`='275',`attdatmod`='202411111645',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '135') AND (id_type = '165') LIMIT 1
UID:1611--164545-- UPDATE `vent_att` SET `att1`='132',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241211',`att43`='Remise TTC',`att2`='275',`attdatmod`='202411111645',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '135') AND (id_type = '165') LIMIT 1
UID:1611--164545-- UPDATE `vent_att` SET `att1`='132',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241211',`att43`='Remise TTC',`att2`='275',`att13`='ycodrcy4xcdi6f57',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/ycodrcy4xcdi6f57',`attdatmod`='202411111645',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '135') AND (id_type = '165') LIMIT 1
UID:1611--164545-- UPDATE `vent_att` SET `att1`='132',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241211',`att43`='Remise TTC',`att2`='275',`att13`='ycodrcy4xcdi6f57',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/ycodrcy4xcdi6f57',`att4`='DEV--4',`attdatmod`='202411111645',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '135') AND (id_type = '165') LIMIT 1
UID:1611--164545-- UPDATE `vent_att` SET `att1`='132',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241211',`att43`='Remise TTC',`att2`='275',`att13`='ycodrcy4xcdi6f57',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/ycodrcy4xcdi6f57',`att4`='DEV--4',`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 € - SIREN 934700352 - RCS : Mâcon\n
TVA : FR42934700352
IBAN : - BIC : ',`att31`='435 Villemaison',`att33`='71130',`att34`='UXEAU',`att35`='France',`att38`='435 Villemaison',`att40`='71130',`att41`='UXEAU',`att42`='France',`attdatmod`='202411111645',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '135') AND (id_type = '165') LIMIT 1
UID:1611--164552-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','135','202411111645','202411111645' )
UID:1611--164552-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111645',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '135') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '248') LIMIT 1
UID:1611--164552-- UPDATE `vent_att` SET `att15`='virement',`att45`='30% à la commande, solde fin de chantier.',`att26`='',`attdatmod`='202411111645',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '135') AND (id_type = '165') LIMIT 1
UID:1611--164553-- 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`='202411111645',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '135') AND (id_type = '165') LIMIT 1
UID:1611--164603-- UPDATE `vent_lig` SET `lig10`='5959',`ligdatmod`='202411111646',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '135') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '248') LIMIT 1
UID:1611--164603-- 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`='202411111646',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '135') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '248') LIMIT 1
UID:1611--164603-- UPDATE `vent_att` SET `att7`='6460',`att8`='646',`att21`='7106',`att9`='7106',`att27`='0',`att29`='0',`att28`='6460',`att30`='646',`attdatmod`='202411111646',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '135') AND (id_type = '165') LIMIT 1
UID:1611--164609-- UPDATE `vent_lig` SET `lig2`='7060.00',`ligdatmod`='202411111646',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '135') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '248') LIMIT 1
UID:1611--164609-- UPDATE `vent_lig` SET `lig2`='7060.00',`lig6`='706.00',`lig17`='7060',`lig18`='706',`lig4`='7060.00',`lig7`='7766.00',`lig15`='7766.00',`ligdatmod`='202411111646',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '135') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '248') LIMIT 1
UID:1611--164609-- UPDATE `vent_att` SET `att7`='7060',`att8`='706',`att21`='7766',`att9`='7766',`att27`='0',`att29`='0',`att28`='7060',`att30`='706',`attdatmod`='202411111646',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '135') AND (id_type = '165') LIMIT 1
UID:1611--164619-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','135','202411111646','202411111646' )
UID:1611--164619-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111646',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '135') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '249') LIMIT 1
UID:1611--164619-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411111646',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '135') AND (id_type = '165') LIMIT 1
UID:1611--164622-- UPDATE `vent_lig` SET `lig10`='5925',`ligdatmod`='202411111646',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '135') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '249') LIMIT 1
UID:1611--164622-- 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`='202411111646',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '135') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '249') LIMIT 1
UID:1611--164623-- UPDATE `vent_att` SET `att7`='10510',`att8`='1051',`att21`='11561',`att9`='11561',`att27`='0',`att29`='0',`att28`='10510',`att30`='1051',`attdatmod`='202411111646',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '135') AND (id_type = '165') LIMIT 1
UID:1611--164630-- UPDATE `vent_lig` SET `lig2`='3950.00',`ligdatmod`='202411111646',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '135') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '249') LIMIT 1
UID:1611--164630-- UPDATE `vent_lig` SET `lig2`='3950.00',`lig6`='395.00',`lig17`='3950',`lig18`='395',`lig4`='3950.00',`lig7`='4345.00',`lig15`='4345.00',`ligdatmod`='202411111646',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '135') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '249') LIMIT 1
UID:1611--164631-- UPDATE `vent_att` SET `att7`='11010',`att8`='1101',`att21`='12111',`att9`='12111',`att27`='0',`att29`='0',`att28`='11010',`att30`='1101',`attdatmod`='202411111646',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '135') AND (id_type = '165') LIMIT 1
UID:1611--164631-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','135','202411111646','202411111646' )
UID:1611--164631-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111646',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '135') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '250') LIMIT 1
UID:1611--164631-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411111646',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '135') AND (id_type = '165') LIMIT 1
UID:1611--164639-- UPDATE `vent_lig` SET `lig10`='5784',`ligdatmod`='202411111646',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '135') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '250') LIMIT 1
UID:1611--164639-- UPDATE `vent_lig` SET `lig10`='5784',`lig6`='0.00',`lig13`='0.00',`lig16`='0',`lig17`='0',`lig18`='0',`lig19`='0.00',`lig2`='0.00',`lig5`='10',`lig4`='0.00',`lig7`='0.00',`lig9`='',`lig14`='0',`lig15`='0.00',`lig90`='<p><b>Réalisation d\'un lit d\'épandage <font color="#000000" style="background-color: rgb(255, 255, 0);">(EH à renseigner)</font> :</b></p><p><br></p><p>- Fourniture d\'une fosse toutes eaux PE dimensionnée conformément à l\'étude de filière.</p><p>- Fournitures des pièces diverses PVC.</p><p>- Mise en place de la fosse toutes eaux avec graviers déclassés,</p><p>- Raccordement des sorties maison à la FTE en tuyau PVC 100.</p><p>- Raccordement de la FTE vers regard de répartition.</p><p>- Création d\'une zone d\'épandage de M² avec épandrains CR4, conformément à l\'étude de filière.<br></p><p>- Mise en place de la ventilation secondaire en pied de mur (prévoir la remontée de la ventilation en toiture à la charge du client).</p><p>- La mise à disposition d\'une prise de courant reste à la disposition du client pour le branchement du poste de relevage.</p><p><br></p><p>- Réception de chantier avec le SPANC contacté par nos soins.</p>',`ligdatmod`='202411111646',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '135') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '250') LIMIT 1
UID:1611--164640-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411111646',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '135') AND (id_type = '165') LIMIT 1
UID:1611--164645-- UPDATE `vent_lig` SET `lig10`='',`ligdatmod`='202411111646',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '135') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '250') LIMIT 1
UID:1611--164645-- UPDATE `vent_lig` SET `lig10`='',`lig5`='0',`lig90`='',`ligdatmod`='202411111646',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '135') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '250') LIMIT 1
UID:1611--164645-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411111646',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '135') AND (id_type = '165') LIMIT 1
UID:1611--164652-- UPDATE `vent_lig` SET `lig10`='5788',`ligdatmod`='202411111646',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '135') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '250') LIMIT 1
UID:1611--164652-- UPDATE `vent_lig` SET `lig10`='5788',`lig5`='10',`lig90`='<p><b>Réalisation d\'un épandage <font color="#000000" style="background-color: rgb(255, 255, 0);">(EH à renseigner)</font> :</b></p><p><b><br></b></p><p>- Fourniture d\'une fosse toutes eaux PE dimensionnée conformément à l\'étude de filière.</p><p>- Fournitures des pièces diverses PVC.</p><p>- Mise en place de la fosse toutes eaux avec graviers déclassés.</p><p>- Raccordement des sorties maison à la FTE en tuyau PVC 100.</p><p>- Raccordement de la FTE vers regard de répartition.</p><p>- Création d\'une zone d\'épandage conformément aux recommandations du bureau d\'études.</p><p>- Mise en place de la ventilation secondaire en pied de mur (prévoir la remontée de la ventilation en toiture à la charge du client).</p><p><br></p><p>- Réception de chantier avec le SPANC contacté par nos soins.</p><p><br></p><p>- La prestation comprend le remblaiement de l\'ancien système et l\'évacuation des</p><p>terres excédentaires.</p>',`ligdatmod`='202411111646',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '135') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '250') LIMIT 1
UID:1611--164652-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411111646',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '135') AND (id_type = '165') LIMIT 1
UID:1611--164656-- UPDATE `vent_lig` SET `lig10`='',`ligdatmod`='202411111646',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '135') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '250') LIMIT 1
UID:1611--164656-- UPDATE `vent_lig` SET `lig10`='',`lig5`='0',`lig90`='',`ligdatmod`='202411111646',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '135') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '250') LIMIT 1
UID:1611--164657-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411111646',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '135') AND (id_type = '165') LIMIT 1
UID:1611--164838-- UPDATE `vent_lig` SET `lig10`='5780',`ligdatmod`='202411111648',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '135') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '250') LIMIT 1
UID:1611--164838-- UPDATE `vent_lig` SET `lig10`='5780',`lig6`='52.00',`lig17`='520',`lig18`='52',`lig2`='520.00',`lig5`='10',`lig4`='520.00',`lig7`='572.00',`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`='202411111648',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '135') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '250') LIMIT 1
UID:1611--164839-- UPDATE `vent_att` SET `att7`='11530',`att8`='1153',`att21`='12683',`att9`='12683',`att27`='0',`att29`='0',`att28`='11530',`att30`='1153',`attdatmod`='202411111648',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '135') AND (id_type = '165') LIMIT 1
UID:1611--164917-- UPDATE `vent_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '165') AND (id_vent = '135') LIMIT 1
UID:1611--164917-- UPDATE `tier_lig` SET `lig2`='4',`ligdatmod`='202411111649',`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--164917-- UPDATE `vent_att` SET `att24`='Rainéa Saône et Bresse
42 Rue Tourneloup
71000 MÂCON
0744306670
setbresse@rainea.fr
www.rainea.fr
\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 Proposition pour votre installation (Devis N° DEV--4)\r\n \r\n\r\n \r\n Bonjour monsieur TEMMERMAN,
\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 \r\n\r\n \r\n \r\n\r\n | \r\n
\r\n
\r\n','/mnt/big/prod/toosmart_rainea/data/tmp/Devis_DEV--4.pdf§Devis_DEV--4.pdf','0','v2017b' )
UID:1611--165636-- UPDATE `email` SET `type`='',`bcc`='' WHERE 1=1 AND (id_email = '161') LIMIT 1
UID:1611--165636-- UPDATE `vent_att` SET `attf104`='20241111',`id_work`='411',`attdatmod`='202411111656',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '135') AND (id_type = '165') LIMIT 1
UID:1611--165636-- UPDATE `vent_att` SET `attf104`='20241111',`id_work`='411',`attf106`='20241111',`attdatmod`='202411111656',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '135') AND (id_type = '165') LIMIT 1
UID:1611--175741-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','205','1','202411111757' )
UID:1611--175741-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1611',`att18`='France',`attf102`='20241111',`attf103`='1',`attf104`='1',`attf105`='20241111',`attdatmod`='202411111757',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '277') AND (id_type = '80') LIMIT 1
UID:1611--175741-- UPDATE `tier_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '80') AND (id_tier = '277') LIMIT 1
UID:1611--175741-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1611',`att18`='France',`attf102`='20241111',`attf103`='1',`attf104`='1',`attf105`='20241111',`att22`='CLI--3',`attdatmod`='202411111757',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '277') AND (id_type = '80') LIMIT 1
UID:1611--175741-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1611',`att18`='France',`attf102`='20241111',`attf103`='1',`attf104`='1',`attf105`='20241111',`att22`='CLI--3',`att16`='THIBERT',`attdatmod`='202411111757',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '277') AND (id_type = '80') LIMIT 1
UID:1611--175816-- UPDATE `tier_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '80') AND (id_tier = '277') LIMIT 1
UID:1611--175816-- UPDATE `tier_att` SET `att3`='F.',`att90`='',`att1`='TUTOT',`att10`='monsieur',`att12`='ftutot@gmail.com',`att14`='4733 route de Louhans',`att15`='',`att7`='71470',`att17`='ROMENAY',`att6`='06 23 54 36 32',`att5`='',`att11`='adwords',`attdatmod`='202411111758',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '277') AND (id_type = '80') LIMIT 1
UID:1611--175816-- UPDATE `tier_att` SET `att3`='F.',`att90`='',`att1`='TUTOT',`att10`='monsieur',`att12`='ftutot@gmail.com',`att14`='4733 route de Louhans',`att15`='',`att7`='71470',`att17`='ROMENAY',`att6`='06 23 54 36 32',`att5`='',`att11`='adwords',`att19`='46.511762',`att20`='5.094247',`attdatmod`='202411111758',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '277') AND (id_type = '80') LIMIT 1
UID:1611--175816-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','277','202411111758','202411111758' )
UID:1611--175816-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='4733 route de Louhans',`lig3`='',`lig4`='71470',`lig5`='ROMENAY',`lig6`='France',`ligdatmod`='202411111758',`ligusermod`='1611' WHERE 1=1 AND ( id_tier = '277') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '158') LIMIT 1
UID:1611--175816-- UPDATE `tier_att` SET `att3`='F.',`att90`='',`att1`='TUTOT',`att10`='monsieur',`att12`='ftutot@gmail.com',`att14`='4733 route de Louhans',`att15`='',`att7`='71470',`att17`='ROMENAY',`att6`='06 23 54 36 32',`att5`='',`att11`='adwords',`att19`='46.511762',`att20`='5.094247',`attf100`='1',`attdatmod`='202411111758',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '277') AND (id_type = '80') LIMIT 1
UID:1611--175816-- UPDATE `tier_lig` SET `lig2`='3',`ligdatmod`='202411111758',`ligusermod`='1611' WHERE 1=1 AND ( id_tier = '260') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '146') LIMIT 1
UID:1611--175816-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202411111758' )
UID:1611--175816-- UPDATE `tier_att` SET `att2`='TUTOT',`att3`='F.',`att4`='',`att5`='06 23 54 36 32',`att6`='ftutot@gmail.com',`att7`='monsieur',`att8`='277',`att10`='1611',`attdatmod`='202411111758',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '278') AND (id_type = '149') LIMIT 1
UID:1611--175816-- UPDATE `tier_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '149') AND (id_tier = '278') LIMIT 1
UID:1611--175824-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202411111758' )
UID:1611--175824-- UPDATE `vent_att` SET `att1`='OPP-',`att2`='277',`attf100`='20241111',`att6`='1611',`attdatmod`='202411111758',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '136') AND (id_type = '148') LIMIT 1
UID:1611--175824-- UPDATE `vent_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '148') AND (id_vent = '136') LIMIT 1
UID:1611--175824-- UPDATE `vent_att` SET `att1`='OPP-TUTOT',`att2`='277',`attf100`='20241111',`att6`='1611',`attdatmod`='202411111758',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '136') AND (id_type = '148') LIMIT 1
UID:1611--175824-- UPDATE `vent_att` SET `att1`='OPP-TUTOT',`att2`='277',`attf100`='20241111',`att6`='1611',`att5`='',`att10`='particulier',`attdatmod`='202411111758',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '136') AND (id_type = '148') LIMIT 1
UID:1611--175911-- UPDATE `vent_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '148') AND (id_vent = '136') LIMIT 1
UID:1611--175911-- UPDATE `vent_att` SET `att8`='',`att9`='',`att3`='assainissement',`attdatmod`='202411111759',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '136') AND (id_type = '148') LIMIT 1
UID:1611--175913-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','165','410','1','202411111759' )
UID:1611--175913-- UPDATE `vent_att` SET `att1`='136',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241111',`att43`='Remise TTC',`attdatmod`='202411111759',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--175913-- UPDATE `vent_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '165') AND (id_vent = '137') LIMIT 1
UID:1611--175913-- UPDATE `vent_att` SET `att1`='136',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241111',`att43`='Remise TTC',`att2`='277',`attdatmod`='202411111759',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--175913-- UPDATE `vent_att` SET `att1`='136',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241211',`att43`='Remise TTC',`att2`='277',`attdatmod`='202411111759',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--175913-- UPDATE `vent_att` SET `att1`='136',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241211',`att43`='Remise TTC',`att2`='277',`att13`='ignhatvz94r3oisc',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/ignhatvz94r3oisc',`attdatmod`='202411111759',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--175913-- UPDATE `vent_att` SET `att1`='136',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241211',`att43`='Remise TTC',`att2`='277',`att13`='ignhatvz94r3oisc',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/ignhatvz94r3oisc',`att4`='DEV--5',`attdatmod`='202411111759',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--175913-- UPDATE `vent_att` SET `att1`='136',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241211',`att43`='Remise TTC',`att2`='277',`att13`='ignhatvz94r3oisc',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/ignhatvz94r3oisc',`att4`='DEV--5',`att18`='Rainea Rainéa Saône et Bresse
42 Rue Tourneloup
71000 MÂCON
setbresse@rainea.fr
www.rainea.fr',`att19`=' 4733 route de Louhans 71470 ROMENAY',`att20`=' 4733 route de Louhans 71470 ROMENAY',`att22`=' Rainea Rainéa Saône et Bresse
SASU au captial de € - SIREN 934700352 - RCS : Mâcon\n
TVA : FR42934700352
IBAN : - BIC : ',`att31`='4733 route de Louhans',`att33`='71470',`att34`='ROMENAY',`att35`='France',`att38`='4733 route de Louhans',`att40`='71470',`att41`='ROMENAY',`att42`='France',`attdatmod`='202411111759',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--175921-- UPDATE `vent_att` SET `att15`='',`att45`='',`att26`='',`attdatmod`='202411111759',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--175928-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','137','202411111759','202411111759' )
UID:1611--175928-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111759',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '137') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '252') LIMIT 1
UID:1611--175928-- UPDATE `vent_att` SET `att15`='virement',`att45`='30% à la commande, solde fin de chantier.',`attdatmod`='202411111759',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--175928-- UPDATE `vent_att` SET `att15`='virement',`att45`='30% à la commande, solde fin de chantier.',`att7`='0',`att8`='0',`att21`='0',`att9`='0',`att27`='0',`att29`='0',`att28`='0',`att30`='0',`attdatmod`='202411111759',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--180053-- UPDATE `vent_lig` SET `lig10`='6009',`ligdatmod`='202411111800',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '137') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '252') LIMIT 1
UID:1611--180053-- 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`='202411111800',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '137') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '252') LIMIT 1
UID:1611--180053-- UPDATE `vent_att` SET `att7`='5280',`att8`='528',`att21`='5808',`att9`='5808',`att27`='0',`att29`='0',`att28`='5280',`att30`='528',`attdatmod`='202411111800',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--180109-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','137','202411111801','202411111801' )
UID:1611--180109-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111801',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '137') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '253') LIMIT 1
UID:1611--180109-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411111801',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--180134-- UPDATE `vent_lig` SET `lig10`='5982',`ligdatmod`='202411111801',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '137') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '253') LIMIT 1
UID:1611--180134-- UPDATE `vent_lig` SET `lig10`='5982',`lig6`='615.00',`lig13`='0.00',`lig16`='0',`lig17`='6150',`lig18`='615',`lig19`='4150.00',`lig2`='6150.00',`lig5`='10',`lig4`='6150.00',`lig7`='6765.00',`lig9`='',`lig14`='0',`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`='202411111801',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '137') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '253') LIMIT 1
UID:1611--180134-- UPDATE `vent_att` SET `att7`='11430',`att8`='1143',`att21`='12573',`att9`='12573',`att27`='0',`att29`='0',`att28`='11430',`att30`='1143',`attdatmod`='202411111801',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--180139-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','137','202411111801','202411111801' )
UID:1611--180139-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111801',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '137') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '254') LIMIT 1
UID:1611--180140-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411111801',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--180208-- UPDATE `vent_lig` SET `lig10`='5976',`ligdatmod`='202411111802',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '137') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '254') LIMIT 1
UID:1611--180208-- UPDATE `vent_lig` SET `lig10`='5976',`lig6`='622.00',`lig13`='0.00',`lig16`='0',`lig17`='6220',`lig18`='622',`lig19`='4220.00',`lig2`='6220.00',`lig5`='10',`lig4`='6220.00',`lig7`='6842.00',`lig9`='',`lig14`='0',`lig15`='6842.00',`lig90`='<p><b>Fourniture d\'une filière compacte ECOFLO PE PACK 5EH sortie HAUTE comprenant :</b></p><p><br></p><p>- Une fosse toutes eaux de 3m3 équipée d\'un préfiltre PF17 permettant de piéger les matières et de protéger le filtre ECOFLO.</p><p>- Un filtre compact 5EH composé de fragments de coco.<br></p><p>- Un poste de relevage intégré équipé d\'une alarme sonore et visuelle.<br></p><p><br></p><p><br></p><p><u>Les Prestations :\r\n</u></p><p>\r\n</p><p><br></p><p>- Assistance à la réalisation des démarches administratives. </p><p>- Vérification de la position du préfiltre de la fosse.<br></p><p>- Mise en place et réglage de l\'auget basculant du filtre.<br></p><p>- Vérification du bon fonctionnement de la filière.<br></p><p>- Installation et mise en service de la pompe de relevage.<br></p><p>- Pose alarme pompe et test fonctionnement. </p><p><br></p><p>- Garantie 10 ans (hors matériel électrique).<br></p><p><br></p><p>- Fabrication Française disposant d\'un agrément Ministériel n° 2016-003-ext12 et conforme à la Norme NF-EN 12566-3+A1 et à l\'arrêté du 7 septembre 2009.</p>',`ligdatmod`='202411111802',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '137') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '254') LIMIT 1
UID:1611--180208-- UPDATE `vent_att` SET `att7`='17650',`att8`='1765',`att21`='19415',`att9`='19415',`att27`='0',`att29`='0',`att28`='17650',`att30`='1765',`attdatmod`='202411111802',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--180213-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','137','202411111802','202411111802' )
UID:1611--180213-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111802',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '137') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '255') LIMIT 1
UID:1611--180213-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411111802',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--180228-- UPDATE `vent_lig` SET `lig10`='5998',`ligdatmod`='202411111802',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '137') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '255') LIMIT 1
UID:1611--180228-- UPDATE `vent_lig` SET `lig10`='5998',`lig6`='620.00',`lig13`='0.00',`lig16`='0',`lig17`='6200',`lig18`='620',`lig19`='4200.00',`lig2`='6200.00',`lig5`='10',`lig4`='6200.00',`lig7`='6820.00',`lig9`='',`lig14`='0',`lig15`='6820.00',`lig90`='<p><b>Fourniture et mise en service d\'une filière compacte ECOFLO PE LIGNE 5EH sortie HAUTE comprenant :</b></p><p><br></p><p>- Une fosse toutes eaux de 3m3 équipée d\'un préfiltre PF17 permettant de piéger les matières et de protéger le filtre ECOFLO.</p><p>- Un filtre compact 5EH composé de fragments de coco.</p><p>- Un poste de relevage intégré équipé d\'une alarme sonore et visuelle.</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>- Installation et mise en service de la pompe de relevage.</p><p>- Pose alarme pompe et test fonctionnement.</p><p><br></p><p>- Garantie 10 ans (hors matériel électrique).</p><p>- Fabrication Française disposant d\'un agrément Ministériel n° 2016-003-ext11 et conforme à la Norme NF-EN 12566-3+A1 et à l\'arrêté du 7 septembre 2009.</p>',`ligdatmod`='202411111802',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '137') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '255') LIMIT 1
UID:1611--180229-- UPDATE `vent_att` SET `att7`='23850',`att8`='2385',`att21`='26235',`att9`='26235',`att27`='0',`att29`='0',`att28`='23850',`att30`='2385',`attdatmod`='202411111802',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--180243-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','137','202411111802','202411111802' )
UID:1611--180243-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111802',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '137') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '256') LIMIT 1
UID:1611--180244-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411111802',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--180340-- UPDATE `vent_lig` SET `lig10`='5957',`ligdatmod`='202411111803',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '137') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '256') LIMIT 1
UID:1611--180340-- UPDATE `vent_lig` SET `lig10`='5957',`lig6`='645.00',`lig13`='0.00',`lig16`='0',`lig17`='6450',`lig18`='645',`lig19`='4449.00',`lig2`='6450.00',`lig5`='10',`lig4`='6450.00',`lig7`='7095.00',`lig9`='',`lig14`='0',`lig15`='7095.00',`lig90`='<p><b>Fourniture et mise en service d\'une filière EPARCO COMPACT PE PACK 5EH sortie HAUTE comprenant :</b></p><p><br></p><p>- Une fosse toutes eaux de 3m3 é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 5EH composé d\'écorces de pin maritime Français.</p><p>- Un poste de relevage intégré équipé d\'une alarme sonore et visuelle.</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>- Installation et mise en service de la pompe de relevage.</p><p>- Pose alarme pompe et test fonctionnement.</p><p><br></p><p>- Garantie 10 ans (hors matériel électrique).</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><p><b><br></b></p>',`ligdatmod`='202411111803',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '137') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '256') LIMIT 1
UID:1611--180341-- UPDATE `vent_att` SET `att7`='30300',`att8`='3030',`att21`='33330',`att9`='33330',`att27`='0',`att29`='0',`att28`='30300',`att30`='3030',`attdatmod`='202411111803',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--180346-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','137','202411111803','202411111803' )
UID:1611--180346-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111803',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '137') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '257') LIMIT 1
UID:1611--180346-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411111803',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--180452-- UPDATE `vent_lig` SET `actif`='0' WHERE 1=1 AND (id_vent = '137') AND (id_type = '165') AND (id_tlig = '162') AND (id_lig = '252')
UID:1611--180453-- UPDATE `vent_att` SET `att7`='25020',`att8`='2502',`att21`='27522',`att9`='27522',`att27`='0',`att29`='0',`att28`='25020',`att30`='2502',`attdatmod`='202411111804',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--180502-- UPDATE `vent_lig` SET `actif`='0' WHERE 1=1 AND (id_vent = '137') AND (id_type = '165') AND (id_tlig = '162') AND (id_lig = '253')
UID:1611--180502-- UPDATE `vent_att` SET `att7`='18870',`att8`='1887',`att21`='20757',`att9`='20757',`att27`='0',`att29`='0',`att28`='18870',`att30`='1887',`attdatmod`='202411111805',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--180540-- UPDATE `vent_lig` SET `actif`='0' WHERE 1=1 AND (id_vent = '137') AND (id_type = '165') AND (id_tlig = '162') AND (id_lig = '254')
UID:1611--180541-- UPDATE `vent_att` SET `att7`='12650',`att8`='1265',`att21`='13915',`att9`='13915',`att27`='0',`att29`='0',`att28`='12650',`att30`='1265',`attdatmod`='202411111805',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--180550-- UPDATE `vent_lig` SET `actif`='0' WHERE 1=1 AND (id_vent = '137') AND (id_type = '165') AND (id_tlig = '162') AND (id_lig = '256')
UID:1611--180551-- UPDATE `vent_att` SET `att7`='6200',`att8`='620',`att21`='6820',`att9`='6820',`att27`='0',`att29`='0',`att28`='6200',`att30`='620',`attdatmod`='202411111805',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--180605-- UPDATE `vent_lig` SET `lig10`='5961',`ligdatmod`='202411111806',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '137') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '257') LIMIT 1
UID:1611--180605-- UPDATE `vent_lig` SET `lig10`='5961',`lig6`='631.00',`lig13`='0.00',`lig16`='0',`lig17`='6310',`lig18`='631',`lig19`='4310.00',`lig2`='6310.00',`lig5`='10',`lig4`='6310.00',`lig7`='6941.00',`lig9`='',`lig14`='0',`lig15`='6941.00',`lig90`='<p><b>Fourniture et mise en service d\'une filière EPARCO COMPACT PE LIGNE 5EH sortie HAUTE comprenant :</b></p><p><br></p><p>- Une fosse toutes eaux de 3m3 é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 5EH composé d\'écorces de pin maritime Français.</p><p>- Un poste de relevage intégré équipé d\'une alarme sonore et visuelle.</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>- Installation et mise en service de la pompe de relevage.</p><p>- Pose alarme pompe et test fonctionnement.</p><p><br></p><p>- Garantie 10 ans (hors matériel électrique).</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><p><b><br></b></p>',`ligdatmod`='202411111806',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '137') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '257') LIMIT 1
UID:1611--180606-- UPDATE `vent_att` SET `att7`='12510',`att8`='1251',`att21`='13761',`att9`='13761',`att27`='0',`att29`='0',`att28`='12510',`att30`='1251',`attdatmod`='202411111806',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--180618-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','137','202411111806','202411111806' )
UID:1611--180618-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111806',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '137') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '258') LIMIT 1
UID:1611--180618-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411111806',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--180626-- UPDATE `vent_lig` SET `lig10`='5953',`ligdatmod`='202411111806',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '137') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '258') LIMIT 1
UID:1611--180626-- UPDATE `vent_lig` SET `lig10`='5953',`lig6`='686.00',`lig13`='0.00',`lig16`='0',`lig17`='6860',`lig18`='686',`lig19`='4859.00',`lig2`='6860.00',`lig5`='10',`lig4`='6860.00',`lig7`='7546.00',`lig9`='',`lig14`='0',`lig15`='7546.00',`lig90`='<p><b>Fourniture et mise en service d\'une filière EPARCO COMPACT BETON LIGNE 5EH sortie HAUTE comprenant :</b></p><p><br></p><p>- Livraison et mise en fouille.</p><p>- Une fosse toutes eaux de 3m3 é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 5EH composé d\'écorces de pin maritime Français.</p><p>- Un poste de relevage intégré équipé d\'une alarme sonore et visuelle.</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>- Installation et mise en service de la pompe de relevage.</p><p>- Pose alarme pompe et test fonctionnement.</p><p><br></p><p>- Garantie 10 ans (hors matériel électrique).</p><p><br></p><p>- Fabrication Française disposant d\'un agrément Ministériel n° 2023-008-mod01-ext01 et conforme à la Norme NF-EN 12566-3+A1 et à l\'arrêté du 7 septembre 2009.</p><p><b><br></b></p>',`ligdatmod`='202411111806',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '137') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '258') LIMIT 1
UID:1611--180626-- UPDATE `vent_att` SET `att7`='19370',`att8`='1937',`att21`='21307',`att9`='21307',`att27`='0',`att29`='0',`att28`='19370',`att30`='1937',`attdatmod`='202411111806',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--180631-- UPDATE `vent_lig` SET `actif`='0' WHERE 1=1 AND (id_vent = '137') AND (id_type = '165') AND (id_tlig = '162') AND (id_lig = '258')
UID:1611--180632-- UPDATE `vent_att` SET `att7`='12510',`att8`='1251',`att21`='13761',`att9`='13761',`att27`='0',`att29`='0',`att28`='12510',`att30`='1251',`attdatmod`='202411111806',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--180642-- UPDATE `vent_lig` SET `actif`='0' WHERE 1=1 AND (id_vent = '137') AND (id_type = '165') AND (id_tlig = '162') AND (id_lig = '257')
UID:1611--180643-- UPDATE `vent_att` SET `att7`='6200',`att8`='620',`att21`='6820',`att9`='6820',`att27`='0',`att29`='0',`att28`='6200',`att30`='620',`attdatmod`='202411111806',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--180715-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','137','202411111807','202411111807' )
UID:1611--180715-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111807',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '137') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '259') LIMIT 1
UID:1611--180715-- UPDATE `vent_att` SET `att94`='<p>Une demande d\'autorisation de rejet des eaux épurées dans le fossé devra être présentée à la Mairie de votre commune.\r\n</p><p>Sous réserve de la validation de la filière d\'assainissement par le SPANC.</p>',`attdatmod`='202411111807',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--180715-- UPDATE `vent_att` SET `att94`='<p>Une demande d\'autorisation de rejet des eaux épurées dans le fossé devra être présentée à la Mairie de votre commune.\r\n</p><p>Sous réserve de la validation de la filière d\'assainissement par le SPANC.</p>',`att27`='0',`att29`='0',`attdatmod`='202411111807',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--180722-- UPDATE `vent_lig` SET `lig10`='5926',`ligdatmod`='202411111807',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '137') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '259') LIMIT 1
UID:1611--180722-- UPDATE `vent_lig` SET `lig10`='5926',`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 Ecoflo 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 ECOFLO®.</p><p>- Le raccordement de la filière vers l\'exutoire.</p><p>- L\'implantation du système ECOFLO®.</p><p>- Le raccordement à la ventilation secondaire.</p><p>- Le piquage en sortie de système ECOFLO® 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`='202411111807',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '137') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '259') LIMIT 1
UID:1611--180723-- UPDATE `vent_att` SET `att7`='9650',`att8`='965',`att21`='10615',`att9`='10615',`att27`='0',`att29`='0',`att28`='9650',`att30`='965',`attdatmod`='202411111807',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--180819-- UPDATE `vent_att` SET `att91`='<p>Ajout de 800 € pour les tuyaux PVC en plus</p>',`attdatmod`='202411111808',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--180819-- UPDATE `vent_lig` SET `lig2`='6800.00',`ligdatmod`='202411111808',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '137') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '255') LIMIT 1
UID:1611--180819-- UPDATE `vent_lig` SET `lig2`='6800.00',`lig6`='680.00',`lig17`='6800',`lig18`='680',`lig4`='6800.00',`lig7`='7480.00',`lig15`='7480.00',`ligdatmod`='202411111808',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '137') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '255') LIMIT 1
UID:1611--180819-- UPDATE `vent_att` SET `att91`='<p>Ajout de 800 € pour les tuyaux PVC en plus</p>',`att7`='10250',`att8`='1025',`att21`='11275',`att9`='11275',`att27`='0',`att29`='0',`att28`='10250',`att30`='1025',`attdatmod`='202411111808',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--180840-- UPDATE `vent_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '165') AND (id_vent = '137') LIMIT 1
UID:1611--180840-- UPDATE `tier_lig` SET `lig2`='5',`ligdatmod`='202411111808',`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--180840-- UPDATE `vent_att` SET `att24`='Rainéa Saône et Bresse
42 Rue Tourneloup
71000 MÂCON
0744306670
setbresse@rainea.fr
www.rainea.fr
\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 Proposition pour votre installation (Devis N° DEV--5)\r\n \r\n\r\n \r\n Bonjour monsieur TUTOT,
\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 \r\n\r\n \r\n \r\n\r\n | \r\n
\r\n
\r\n','/mnt/big/prod/toosmart_rainea/data/tmp/Devis_DEV--5.pdf§Devis_DEV--5.pdf','0','v2017b' )
UID:1611--181356-- UPDATE `email` SET `type`='',`bcc`='' WHERE 1=1 AND (id_email = '162') LIMIT 1
UID:1611--181356-- UPDATE `vent_att` SET `attf104`='20241111',`id_work`='411',`attdatmod`='202411111813',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--181356-- UPDATE `vent_att` SET `attf104`='20241111',`id_work`='411',`attf106`='20241111',`attdatmod`='202411111813',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '137') AND (id_type = '165') LIMIT 1
UID:1611--183325-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','205','1','202411111833' )
UID:1611--183325-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1611',`att18`='France',`attf102`='20241111',`attf103`='1',`attf104`='1',`attf105`='20241111',`attdatmod`='202411111833',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '279') AND (id_type = '80') LIMIT 1
UID:1611--183325-- UPDATE `tier_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '80') AND (id_tier = '279') LIMIT 1
UID:1611--183325-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1611',`att18`='France',`attf102`='20241111',`attf103`='1',`attf104`='1',`attf105`='20241111',`att22`='CLI--4',`attdatmod`='202411111833',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '279') AND (id_type = '80') LIMIT 1
UID:1611--183325-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1611',`att18`='France',`attf102`='20241111',`attf103`='1',`attf104`='1',`attf105`='20241111',`att22`='CLI--4',`att16`='THIBERT',`attdatmod`='202411111833',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '279') AND (id_type = '80') LIMIT 1
UID:1611--183327-- UPDATE `tier_att` SET `att3`='',`att90`='',`att1`='',`att8`='professionnel',`att10`='',`att12`='',`att14`='',`att15`='',`att7`='',`att17`='',`att6`='',`att5`='',`att11`='',`attdatmod`='202411111833',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '279') AND (id_type = '80') LIMIT 1
UID:1611--183327-- UPDATE `tier_att` SET `att3`='',`att90`='',`att1`='',`att8`='professionnel',`att10`='',`att12`='',`att14`='',`att15`='',`att7`='',`att17`='',`att6`='',`att5`='',`att11`='',`att19`='44.918078',`att20`='4.895543',`attdatmod`='202411111833',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '279') AND (id_type = '80') LIMIT 1
UID:1611--183503-- UPDATE `tier_att` SET `att3`='Samir',`att1`='LEMKAK',`att9`='NOSEIM',`att10`='SASU',`att12`='sasunoseim@gmail.com',`att14`='62 RUE DES FOURCHES',`att7`='39100',`att17`='DOLE',`att6`='06 99 06 38 67',`att11`='adwords',`att4`='FR63831217849',`attdatmod`='202411111835',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '279') AND (id_type = '80') LIMIT 1
UID:1611--183503-- UPDATE `tier_att` SET `att3`='Samir',`att1`='LEMKAK',`att9`='NOSEIM',`att10`='SASU',`att12`='sasunoseim@gmail.com',`att14`='62 RUE DES FOURCHES',`att7`='39100',`att17`='DOLE',`att6`='06 99 06 38 67',`att11`='adwords',`att4`='FR63831217849',`att19`='47.081852',`att20`='5.503498',`attdatmod`='202411111835',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '279') AND (id_type = '80') LIMIT 1
UID:1611--183503-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','279','202411111835','202411111835' )
UID:1611--183503-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='62 RUE DES FOURCHES',`lig3`='',`lig4`='39100',`lig5`='DOLE',`lig6`='France',`ligdatmod`='202411111835',`ligusermod`='1611' WHERE 1=1 AND ( id_tier = '279') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '159') LIMIT 1
UID:1611--183503-- UPDATE `tier_att` SET `att3`='Samir',`att1`='LEMKAK',`att9`='NOSEIM',`att10`='SASU',`att12`='sasunoseim@gmail.com',`att14`='62 RUE DES FOURCHES',`att7`='39100',`att17`='DOLE',`att6`='06 99 06 38 67',`att11`='adwords',`att4`='FR63831217849',`att19`='47.081852',`att20`='5.503498',`attf100`='1',`attdatmod`='202411111835',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '279') AND (id_type = '80') LIMIT 1
UID:1611--183506-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','279','202411111835','202411111835' )
UID:1611--183506-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`ligdatmod`='202411111835',`ligusermod`='1611' WHERE 1=1 AND ( id_tier = '279') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '160') LIMIT 1
UID:1611--183523-- UPDATE `tier_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '80') AND (id_tier = '279') LIMIT 1
UID:1611--183523-- UPDATE `tier_lig` SET `lig7`='DOLE',`lig2`='54 rue des fourches',`lig3`='',`lig4`='39100',`lig5`='DOLE',`lig6`='France',`ligdatmod`='202411111835',`ligusermod`='1611' WHERE 1=1 AND ( id_tier = '279') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '160') LIMIT 1
UID:1611--183523-- UPDATE `tier_lig` SET `lig2`='4',`ligdatmod`='202411111835',`ligusermod`='1611' WHERE 1=1 AND ( id_tier = '260') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '146') LIMIT 1
UID:1611--183523-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202411111835' )
UID:1611--183523-- UPDATE `tier_att` SET `att2`='LEMKAK',`att3`='Samir',`att4`='',`att5`='06 99 06 38 67',`att6`='sasunoseim@gmail.com',`att7`='SASU',`att8`='279',`att10`='1611',`attdatmod`='202411111835',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '280') AND (id_type = '149') LIMIT 1
UID:1611--183523-- UPDATE `tier_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '149') AND (id_tier = '280') LIMIT 1
UID:1611--183541-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202411111835' )
UID:1611--183541-- UPDATE `vent_att` SET `att1`='OPP-',`att2`='279',`attf100`='20241111',`att6`='1611',`attdatmod`='202411111835',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '138') AND (id_type = '148') LIMIT 1
UID:1611--183541-- UPDATE `vent_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '148') AND (id_vent = '138') LIMIT 1
UID:1611--183541-- UPDATE `vent_att` SET `att1`='OPP-LEMKAK',`att2`='279',`attf100`='20241111',`att6`='1611',`attdatmod`='202411111835',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '138') AND (id_type = '148') LIMIT 1
UID:1611--183541-- UPDATE `vent_att` SET `att1`='OPP-LEMKAK',`att2`='279',`attf100`='20241111',`att6`='1611',`att5`='NOSEIM',`att10`='professionnel',`attdatmod`='202411111835',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '138') AND (id_type = '148') LIMIT 1
UID:1611--183605-- UPDATE `vent_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '148') AND (id_vent = '138') LIMIT 1
UID:1611--183605-- UPDATE `vent_att` SET `att1`='OPP-NOSEIM',`att8`='',`att9`='',`att3`='assainissement',`attdatmod`='202411111836',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '138') AND (id_type = '148') LIMIT 1
UID:1611--183608-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','165','410','1','202411111836' )
UID:1611--183608-- UPDATE `vent_att` SET `att1`='138',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241111',`att43`='Remise TTC',`attdatmod`='202411111836',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '139') AND (id_type = '165') LIMIT 1
UID:1611--183608-- UPDATE `vent_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '165') AND (id_vent = '139') LIMIT 1
UID:1611--183608-- UPDATE `vent_att` SET `att1`='138',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241111',`att43`='Remise TTC',`att2`='279',`attdatmod`='202411111836',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '139') AND (id_type = '165') LIMIT 1
UID:1611--183608-- UPDATE `vent_att` SET `att1`='138',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241211',`att43`='Remise TTC',`att2`='279',`attdatmod`='202411111836',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '139') AND (id_type = '165') LIMIT 1
UID:1611--183608-- UPDATE `vent_att` SET `att1`='138',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241211',`att43`='Remise TTC',`att2`='279',`att13`='ldomo8e907cc7ypo',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/ldomo8e907cc7ypo',`attdatmod`='202411111836',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '139') AND (id_type = '165') LIMIT 1
UID:1611--183608-- UPDATE `vent_att` SET `att1`='138',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241211',`att43`='Remise TTC',`att2`='279',`att13`='ldomo8e907cc7ypo',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/ldomo8e907cc7ypo',`att4`='DEV--6',`attdatmod`='202411111836',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '139') AND (id_type = '165') LIMIT 1
UID:1611--183608-- UPDATE `vent_att` SET `att1`='138',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241211',`att43`='Remise TTC',`att2`='279',`att13`='ldomo8e907cc7ypo',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/ldomo8e907cc7ypo',`att4`='DEV--6',`att18`='Rainea Rainéa Saône et Bresse
42 Rue Tourneloup
71000 MÂCON
setbresse@rainea.fr
www.rainea.fr',`att19`=' 62 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`='62 RUE DES FOURCHES',`att40`='39100',`att41`='DOLE',`att42`='France',`attdatmod`='202411111836',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '139') AND (id_type = '165') LIMIT 1
UID:1611--183630-- UPDATE `vent_att` SET `att8`='160',`att9`='280',`attdatmod`='202411111836',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '138') AND (id_type = '148') LIMIT 1
UID:1611--183636-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','165','410','1','202411111836' )
UID:1611--183636-- UPDATE `vent_att` SET `att1`='138',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241111',`att43`='Remise TTC',`attdatmod`='202411111836',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--183636-- UPDATE `vent_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '165') AND (id_vent = '140') LIMIT 1
UID:1611--183636-- UPDATE `vent_att` SET `att1`='138',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241111',`att43`='Remise TTC',`att2`='279',`attdatmod`='202411111836',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--183636-- UPDATE `vent_att` SET `att1`='138',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241211',`att43`='Remise TTC',`att2`='279',`attdatmod`='202411111836',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--183636-- UPDATE `vent_att` SET `att1`='138',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241211',`att43`='Remise TTC',`att2`='279',`att13`='hl302zz6g5bkimhl',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/hl302zz6g5bkimhl',`attdatmod`='202411111836',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--183636-- UPDATE `vent_att` SET `att1`='138',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241211',`att43`='Remise TTC',`att2`='279',`att13`='hl302zz6g5bkimhl',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/hl302zz6g5bkimhl',`att4`='DEV--6',`attdatmod`='202411111836',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--183636-- UPDATE `vent_att` SET `att1`='138',`attf100`='20241111',`attf101`='1',`att11`='1611',`attf105`='20241211',`att43`='Remise TTC',`att2`='279',`att13`='hl302zz6g5bkimhl',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/hl302zz6g5bkimhl',`att4`='DEV--6',`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`='202411111836',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--183736-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','140','202411111837','202411111837' )
UID:1611--183736-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111837',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '260') LIMIT 1
UID:1611--183736-- UPDATE `vent_att` SET `att15`='virement',`att45`='30% à la commande, 30% à la livraison du matériel et solde fin de chantier.',`att26`='',`attdatmod`='202411111837',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--183736-- 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`='202411111837',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--183821-- UPDATE `vent_lig` SET `lig10`='5983',`ligdatmod`='202411111838',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '260') LIMIT 1
UID:1611--183821-- 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`='202411111838',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '260') LIMIT 1
UID:1611--183821-- UPDATE `vent_att` SET `att7`='5790',`att8`='579',`att21`='6369',`att9`='6369',`att27`='0',`att29`='0',`att28`='5790',`att30`='579',`attdatmod`='202411111838',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--183831-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','140','202411111838','202411111838' )
UID:1611--183831-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111838',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '261') LIMIT 1
UID:1611--183831-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411111838',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--183838-- UPDATE `vent_lig` SET `lig10`='5982',`ligdatmod`='202411111838',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '261') LIMIT 1
UID:1611--183838-- UPDATE `vent_lig` SET `lig10`='5982',`lig6`='615.00',`lig13`='0.00',`lig16`='0',`lig17`='6150',`lig18`='615',`lig19`='4150.00',`lig2`='6150.00',`lig5`='10',`lig4`='6150.00',`lig7`='6765.00',`lig9`='',`lig14`='0',`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`='202411111838',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '261') LIMIT 1
UID:1611--183838-- UPDATE `vent_att` SET `att7`='11940',`att8`='1194',`att21`='13134',`att9`='13134',`att27`='0',`att29`='0',`att28`='11940',`att30`='1194',`attdatmod`='202411111838',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--183900-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','140','202411111839','202411111839' )
UID:1611--183900-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111839',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '262') LIMIT 1
UID:1611--183900-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411111839',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--183905-- UPDATE `vent_lig` SET `lig5`='20',`ligdatmod`='202411111839',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '260') LIMIT 1
UID:1611--183905-- UPDATE `vent_lig` SET `lig5`='20',`lig6`='1158.00',`lig18`='1158',`lig7`='6948.00',`lig15`='6948.00',`ligdatmod`='202411111839',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '260') LIMIT 1
UID:1611--183905-- UPDATE `vent_att` SET `att8`='1773',`att21`='13713',`att9`='13713',`att27`='0',`att29`='0',`att30`='1773',`attdatmod`='202411111839',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--183907-- UPDATE `vent_lig` SET `lig5`='20',`ligdatmod`='202411111839',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '261') LIMIT 1
UID:1611--183907-- UPDATE `vent_lig` SET `lig5`='20',`lig6`='1230.00',`lig18`='1230',`lig7`='7380.00',`lig15`='7380.00',`ligdatmod`='202411111839',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '261') LIMIT 1
UID:1611--183908-- UPDATE `vent_att` SET `att8`='2388',`att21`='14328',`att9`='14328',`att27`='0',`att29`='0',`att30`='2388',`attdatmod`='202411111839',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--183958-- UPDATE `vent_lig` SET `lig10`='5957',`ligdatmod`='202411111839',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '262') LIMIT 1
UID:1611--183958-- UPDATE `vent_lig` SET `lig10`='5957',`lig6`='645.00',`lig13`='0.00',`lig16`='0',`lig17`='6450',`lig18`='645',`lig19`='4449.00',`lig2`='6450.00',`lig5`='10',`lig4`='6450.00',`lig7`='7095.00',`lig9`='',`lig14`='0',`lig15`='7095.00',`lig90`='<p><b>Fourniture et mise en service d\'une filière EPARCO COMPACT PE PACK 5EH sortie HAUTE comprenant :</b></p><p><br></p><p>- Une fosse toutes eaux de 3m3 é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 5EH composé d\'écorces de pin maritime Français.</p><p>- Un poste de relevage intégré équipé d\'une alarme sonore et visuelle.</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>- Installation et mise en service de la pompe de relevage.</p><p>- Pose alarme pompe et test fonctionnement.</p><p><br></p><p>- Garantie 10 ans (hors matériel électrique).</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><p><b><br></b></p>',`ligdatmod`='202411111839',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '262') LIMIT 1
UID:1611--183959-- UPDATE `vent_att` SET `att7`='18390',`att8`='3033',`att21`='21423',`att9`='21423',`att27`='0',`att29`='0',`att28`='18390',`att30`='3033',`attdatmod`='202411111839',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--184017-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','140','202411111840','202411111840' )
UID:1611--184017-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111840',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '263') LIMIT 1
UID:1611--184018-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411111840',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--184039-- UPDATE `vent_lig` SET `lig10`='5961',`ligdatmod`='202411111840',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '263') LIMIT 1
UID:1611--184039-- UPDATE `vent_lig` SET `lig10`='5961',`lig6`='631.00',`lig13`='0.00',`lig16`='0',`lig17`='6310',`lig18`='631',`lig19`='4310.00',`lig2`='6310.00',`lig5`='10',`lig4`='6310.00',`lig7`='6941.00',`lig9`='',`lig14`='0',`lig15`='6941.00',`lig90`='<p><b>Fourniture et mise en service d\'une filière EPARCO COMPACT PE LIGNE 5EH sortie HAUTE comprenant :</b></p><p><br></p><p>- Une fosse toutes eaux de 3m3 é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 5EH composé d\'écorces de pin maritime Français.</p><p>- Un poste de relevage intégré équipé d\'une alarme sonore et visuelle.</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>- Installation et mise en service de la pompe de relevage.</p><p>- Pose alarme pompe et test fonctionnement.</p><p><br></p><p>- Garantie 10 ans (hors matériel électrique).</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><p><b><br></b></p>',`ligdatmod`='202411111840',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '263') LIMIT 1
UID:1611--184039-- UPDATE `vent_att` SET `att7`='24700',`att8`='3664',`att21`='28364',`att9`='28364',`att27`='0',`att29`='0',`att28`='24700',`att30`='3664',`attdatmod`='202411111840',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--184047-- UPDATE `vent_lig` SET `actif`='0' WHERE 1=1 AND (id_vent = '140') AND (id_type = '165') AND (id_tlig = '162') AND (id_lig = '263')
UID:1611--184048-- UPDATE `vent_att` SET `att7`='18390',`att8`='3033',`att21`='21423',`att9`='21423',`att27`='0',`att29`='0',`att28`='18390',`att30`='3033',`attdatmod`='202411111840',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--184053-- UPDATE `vent_lig` SET `actif`='0' WHERE 1=1 AND (id_vent = '140') AND (id_type = '165') AND (id_tlig = '162') AND (id_lig = '260')
UID:1611--184053-- UPDATE `vent_att` SET `att7`='12600',`att8`='1875',`att21`='14475',`att9`='14475',`att27`='0',`att29`='0',`att28`='12600',`att30`='1875',`attdatmod`='202411111840',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--184100-- UPDATE `vent_lig` SET `lig3`='2',`ligdatmod`='202411111841',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '261') LIMIT 1
UID:1611--184100-- UPDATE `vent_lig` SET `lig3`='2',`lig6`='2460.00',`lig17`='12300',`lig18`='2460',`lig4`='12300.00',`lig7`='14760.00',`lig15`='14760.00',`ligdatmod`='202411111841',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '261') LIMIT 1
UID:1611--184100-- UPDATE `vent_att` SET `att7`='18750',`att8`='3105',`att21`='21855',`att9`='21855',`att27`='0',`att29`='0',`att28`='18750',`att30`='3105',`attdatmod`='202411111841',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--184109-- UPDATE `vent_lig` SET `actif`='0' WHERE 1=1 AND (id_vent = '140') AND (id_type = '165') AND (id_tlig = '162') AND (id_lig = '262')
UID:1611--184109-- UPDATE `vent_att` SET `att7`='12300',`att8`='2460',`att21`='14760',`att9`='14760',`att27`='0',`att29`='0',`att28`='12300',`att30`='2460',`attdatmod`='202411111841',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--184111-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','140','202411111841','202411111841' )
UID:1611--184111-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111841',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '264') LIMIT 1
UID:1611--184112-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411111841',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--184115-- UPDATE `vent_lig` SET `lig10`='',`ligdatmod`='202411111841',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '261') LIMIT 1
UID:1611--184115-- 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`='202411111841',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '261') LIMIT 1
UID:1611--184115-- UPDATE `vent_att` SET `att7`='0',`att8`='0',`att21`='0',`att9`='0',`att27`='0',`att29`='0',`att28`='0',`att30`='0',`attdatmod`='202411111841',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--184121-- UPDATE `vent_lig` SET `actif`='0' WHERE 1=1 AND (id_vent = '140') AND (id_type = '165') AND (id_tlig = '162') AND (id_lig = '261')
UID:1611--184122-- UPDATE `vent_att` SET `att7`='0',`att8`='0',`att21`='0',`att9`='0',`att27`='0',`att29`='0',`att28`='0',`att30`='0',`attdatmod`='202411111841',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--184125-- UPDATE `vent_lig` SET `actif`='0' WHERE 1=1 AND (id_vent = '140') AND (id_type = '165') AND (id_tlig = '162') AND (id_lig = '264')
UID:1611--184125-- UPDATE `vent_att` SET `att7`='0',`att8`='0',`att21`='0',`att9`='0',`att27`='0',`att29`='0',`att28`='0',`att30`='0',`attdatmod`='202411111841',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--184127-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','140','202411111841','202411111841' )
UID:1611--184127-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111841',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '265') LIMIT 1
UID:1611--184127-- UPDATE `vent_att` SET `att7`='0',`att8`='0',`att21`='0',`att9`='0',`att27`='0',`att29`='0',`att28`='0',`att30`='0',`attdatmod`='202411111841',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--184208-- UPDATE `vent_lig` SET `lig10`='5957',`ligdatmod`='202411111842',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '265') LIMIT 1
UID:1611--184208-- UPDATE `vent_lig` SET `lig10`='5957',`lig6`='645.00',`lig13`='0.00',`lig16`='0',`lig17`='6450',`lig18`='645',`lig19`='4449.00',`lig2`='6450.00',`lig5`='10',`lig4`='6450.00',`lig7`='7095.00',`lig9`='',`lig14`='0',`lig15`='7095.00',`lig90`='<p><b>Fourniture et mise en service d\'une filière EPARCO COMPACT PE PACK 5EH sortie HAUTE comprenant :</b></p><p><br></p><p>- Une fosse toutes eaux de 3m3 é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 5EH composé d\'écorces de pin maritime Français.</p><p>- Un poste de relevage intégré équipé d\'une alarme sonore et visuelle.</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>- Installation et mise en service de la pompe de relevage.</p><p>- Pose alarme pompe et test fonctionnement.</p><p><br></p><p>- Garantie 10 ans (hors matériel électrique).</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><p><b><br></b></p>',`ligdatmod`='202411111842',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '265') LIMIT 1
UID:1611--184208-- UPDATE `vent_att` SET `att7`='6450',`att8`='645',`att21`='7095',`att9`='7095',`att27`='0',`att29`='0',`att28`='6450',`att30`='645',`attdatmod`='202411111842',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--184211-- UPDATE `vent_lig` SET `lig3`='2',`ligdatmod`='202411111842',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '265') LIMIT 1
UID:1611--184211-- UPDATE `vent_lig` SET `lig3`='2',`lig6`='1290.00',`lig17`='12900',`lig18`='1290',`lig4`='12900.00',`lig7`='14190.00',`lig15`='14190.00',`ligdatmod`='202411111842',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '265') LIMIT 1
UID:1611--184211-- UPDATE `vent_att` SET `att7`='12900',`att8`='1290',`att21`='14190',`att9`='14190',`att27`='0',`att29`='0',`att28`='12900',`att30`='1290',`attdatmod`='202411111842',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--184214-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','140','202411111842','202411111842' )
UID:1611--184214-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411111842',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '266') LIMIT 1
UID:1611--184215-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411111842',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--184224-- UPDATE `vent_lig` SET `lig10`='5925',`ligdatmod`='202411111842',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '266') LIMIT 1
UID:1611--184224-- 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`='202411111842',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '266') LIMIT 1
UID:1611--184224-- UPDATE `vent_att` SET `att7`='16350',`att8`='1635',`att21`='17985',`att9`='17985',`att27`='0',`att29`='0',`att28`='16350',`att30`='1635',`attdatmod`='202411111842',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--184228-- UPDATE `vent_lig` SET `lig3`='2',`ligdatmod`='202411111842',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '266') LIMIT 1
UID:1611--184228-- UPDATE `vent_lig` SET `lig3`='2',`lig6`='690.00',`lig17`='6900',`lig18`='690',`lig4`='6900.00',`lig7`='7590.00',`lig15`='7590.00',`ligdatmod`='202411111842',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '266') LIMIT 1
UID:1611--184229-- UPDATE `vent_att` SET `att7`='19800',`att8`='1980',`att21`='21780',`att9`='21780',`att27`='0',`att29`='0',`att28`='19800',`att30`='1980',`attdatmod`='202411111842',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--184231-- UPDATE `vent_lig` SET `lig5`='20',`ligdatmod`='202411111842',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '265') LIMIT 1
UID:1611--184231-- UPDATE `vent_lig` SET `lig5`='20',`lig6`='2580.00',`lig18`='2580',`lig7`='15480.00',`lig15`='15480.00',`ligdatmod`='202411111842',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '265') LIMIT 1
UID:1611--184231-- UPDATE `vent_att` SET `att8`='3270',`att21`='23070',`att9`='23070',`att27`='0',`att29`='0',`att30`='3270',`attdatmod`='202411111842',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--184235-- UPDATE `vent_lig` SET `lig5`='20',`ligdatmod`='202411111842',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '266') LIMIT 1
UID:1611--184235-- UPDATE `vent_lig` SET `lig5`='20',`lig6`='1380.00',`lig18`='1380',`lig7`='8280.00',`lig15`='8280.00',`ligdatmod`='202411111842',`ligusermod`='1611' WHERE 1=1 AND ( id_vent = '140') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '266') LIMIT 1
UID:1611--184235-- UPDATE `vent_att` SET `att8`='3960',`att21`='23760',`att9`='23760',`att27`='0',`att29`='0',`att30`='3960',`attdatmod`='202411111842',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--184448-- UPDATE `vent_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '165') AND (id_vent = '140') LIMIT 1
UID:1611--184448-- UPDATE `vent_att` SET `att94`='<p>Sous réserve de la validation de la filière d\'assainissement par le SPANC.</p>',`attdatmod`='202411111844',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--184448-- UPDATE `tier_lig` SET `lig2`='6',`ligdatmod`='202411111844',`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--184448-- UPDATE `vent_att` SET `att94`='<p>Sous réserve de la validation de la filière d\'assainissement par le SPANC.</p>',`att24`='Rainéa Saône et Bresse
42 Rue Tourneloup
71000 MÂCON
0744306670
setbresse@rainea.fr
www.rainea.fr
\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 Proposition pour votre installation (Devis N° DEV--6)\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 \r\n\r\n \r\n \r\n\r\n | \r\n
\r\n
\r\n','/mnt/big/prod/toosmart_rainea/data/tmp/Devis_DEV--6.pdf§Devis_DEV--6.pdf','0','v2017b' )
UID:1611--184531-- UPDATE `email` SET `type`='',`bcc`='' WHERE 1=1 AND (id_email = '163') LIMIT 1
UID:1611--184531-- UPDATE `vent_att` SET `attf104`='20241111',`id_work`='411',`attdatmod`='202411111845',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1
UID:1611--184531-- UPDATE `vent_att` SET `attf104`='20241111',`id_work`='411',`attf106`='20241111',`attdatmod`='202411111845',`attusermod`='1611',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '140') AND (id_type = '165') LIMIT 1