UID:1607--095733-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','205','1','202411060957' )
UID:1607--095733-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1607',`att18`='France',`attf102`='20241106',`attf103`='1',`attf104`='1',`attf105`='20241106',`attdatmod`='202411060957',`attusermod`='1607',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '261') AND (id_type = '80') LIMIT 1
UID:1607--095734-- UPDATE `tier_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '80') AND (id_tier = '261') LIMIT 1
UID:1607--095734-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1607',`att18`='France',`attf102`='20241106',`attf103`='1',`attf104`='1',`attf105`='20241106',`att22`='CLI--2',`attdatmod`='202411060957',`attusermod`='1607',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '261') AND (id_type = '80') LIMIT 1
UID:1607--095734-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1607',`att18`='France',`attf102`='20241106',`attf103`='1',`attf104`='1',`attf105`='20241106',`att22`='CLI--2',`att16`='Pellerin',`attdatmod`='202411060957',`attusermod`='1607',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '261') AND (id_type = '80') LIMIT 1
UID:1607--095738-- UPDATE `tier_att` SET `actif`='0' WHERE 1=1 AND ( id_tier = '261') AND (id_type = '80') LIMIT 1
UID:1607--095738-- UPDATE `tier_lig` SET `actif`='0' WHERE 1=1 AND (id_tier = '261') AND (id_type = '80')
UID:1607--095738-- UPDATE `tier_att` SET `attX`='',`actif`='0',`att19`='44.803778',`att20`='-0.497628',`attdatmod`='202411060957',`attusermod`='1607',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '261') AND (id_type = '80') LIMIT 1
UID:1607--095757-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','205','1','202411060957' )
UID:1607--095757-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1607',`att18`='France',`attf102`='20241106',`attf103`='1',`attf104`='1',`attf105`='20241106',`attdatmod`='202411060957',`attusermod`='1607',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '262') AND (id_type = '80') LIMIT 1
UID:1607--095757-- UPDATE `tier_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '80') AND (id_tier = '262') LIMIT 1
UID:1607--095757-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1607',`att18`='France',`attf102`='20241106',`attf103`='1',`attf104`='1',`attf105`='20241106',`att22`='CLI--2',`attdatmod`='202411060957',`attusermod`='1607',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '262') AND (id_type = '80') LIMIT 1
UID:1607--095757-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1607',`att18`='France',`attf102`='20241106',`attf103`='1',`attf104`='1',`attf105`='20241106',`att22`='CLI--2',`att16`='Pellerin',`attdatmod`='202411060957',`attusermod`='1607',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '262') AND (id_type = '80') LIMIT 1
UID:1607--095932-- UPDATE `tier_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '80') AND (id_tier = '262') LIMIT 1
UID:1607--095932-- UPDATE `tier_att` SET `att3`='',`att90`='<p>Veut avoir un prix pour tous à l\'égout, et si pas intéressant lui faire une propo pour ANC</p>',`att1`='Derrou',`att10`='monsieur',`att12`='philip.derrou@outlook.fr',`att14`='',`att15`='',`att7`='34360',`att17`='',`att6`='0602731214',`att5`='',`att11`='web',`attdatmod`='202411060959',`attusermod`='1607',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '262') AND (id_type = '80') LIMIT 1
UID:1607--095932-- UPDATE `tier_att` SET `att3`='',`att90`='<p>Veut avoir un prix pour tous à l\'égout, et si pas intéressant lui faire une propo pour ANC</p>',`att1`='Derrou',`att10`='monsieur',`att12`='philip.derrou@outlook.fr',`att14`='',`att15`='',`att7`='34360',`att17`='',`att6`='0602731214',`att5`='',`att11`='web',`att19`='44.803778',`att20`='-0.497628',`attdatmod`='202411060959',`attusermod`='1607',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '262') AND (id_type = '80') LIMIT 1
UID:1607--095932-- UPDATE `tier_lig` SET `lig2`='2',`ligdatmod`='202411060959',`ligusermod`='1607' WHERE 1=1 AND ( id_tier = '175') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '90') LIMIT 1
UID:1607--095932-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202411060959' )
UID:1607--095932-- UPDATE `tier_att` SET `att2`='Derrou',`att3`='',`att4`='',`att5`='0602731214',`att6`='philip.derrou@outlook.fr',`att7`='monsieur',`att8`='262',`att10`='1607',`attdatmod`='202411060959',`attusermod`='1607',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '263') AND (id_type = '149') LIMIT 1
UID:1607--095932-- UPDATE `tier_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '149') AND (id_tier = '263') LIMIT 1
UID:1607--145932-- UPDATE `vent_lig` SET `lig10`='',`ligdatmod`='202411061459',`ligusermod`='1607' WHERE 1=1 AND ( id_vent = '80') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '193') LIMIT 1
UID:1607--145932-- 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`='202411061459',`ligusermod`='1607' WHERE 1=1 AND ( id_vent = '80') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '193') LIMIT 1
UID:1607--145933-- UPDATE `vent_att` SET `att7`='3970',`att8`='397',`att21`='4367',`att9`='4367',`att27`='0',`att29`='0',`att28`='3970',`att30`='397',`attdatmod`='202411061459',`attusermod`='1607',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '80') AND (id_type = '165') LIMIT 1
UID:1607--145946-- UPDATE `vent_lig` SET `lig10`='2329',`ligdatmod`='202411061459',`ligusermod`='1607' WHERE 1=1 AND ( id_vent = '80') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '193') LIMIT 1
UID:1607--145946-- UPDATE `vent_lig` SET `lig10`='2329',`lig6`='9.80',`lig17`='98',`lig18`='9.8',`lig2`='98.00',`lig5`='10',`lig4`='98.00',`lig7`='107.80',`lig15`='107.80',`lig90`='<p><b>Fourniture d\'une rehausse pour poste de relevage intégré FILTRE SYLVA VEGETAL.</b></p>',`ligdatmod`='202411061459',`ligusermod`='1607' WHERE 1=1 AND ( id_vent = '80') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '193') LIMIT 1
UID:1607--145946-- UPDATE `vent_att` SET `att7`='4068',`att8`='406.8',`att21`='4474.8',`att9`='4474.8',`att27`='0',`att29`='0',`att28`='4068',`att30`='406.8',`attdatmod`='202411061459',`attusermod`='1607',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '80') AND (id_type = '165') LIMIT 1
UID:1607--150304-- UPDATE `vent_lig` SET `lig10`='',`ligdatmod`='202411061503',`ligusermod`='1607' WHERE 1=1 AND ( id_vent = '80') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '193') LIMIT 1
UID:1607--150304-- UPDATE `vent_lig` SET `lig10`='',`lig6`='0.00',`lig17`='0',`lig18`='0',`lig2`='0.00',`lig5`='0',`lig4`='0.00',`lig7`='0.00',`lig15`='0.00',`lig90`='',`ligdatmod`='202411061503',`ligusermod`='1607' WHERE 1=1 AND ( id_vent = '80') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '193') LIMIT 1
UID:1607--150304-- UPDATE `vent_att` SET `att7`='3970',`att8`='397',`att21`='4367',`att9`='4367',`att27`='0',`att29`='0',`att28`='3970',`att30`='397',`attdatmod`='202411061503',`attusermod`='1607',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '80') AND (id_type = '165') LIMIT 1
UID:1607--150314-- UPDATE `vent_lig` SET `lig10`='5751',`ligdatmod`='202411061503',`ligusermod`='1607' WHERE 1=1 AND ( id_vent = '80') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '193') LIMIT 1
UID:1607--150314-- UPDATE `vent_lig` SET `lig10`='5751',`lig6`='249.70',`lig17`='2497',`lig18`='249.7',`lig2`='2497.00',`lig5`='10',`lig4`='2497.00',`lig7`='2746.70',`lig15`='2746.70',`lig90`='<p><b>Fourniture d\'un module de gestion des eaux de pluie "Val\'Eau In+ Connecté" comprenant :</b></p><p><br></p><p>- Une pompe de surface.</p><p>- Un bac de disconnexion de 17 litres utiles.</p><p> Disconnexion de type AB - conforme norme EN1717</p><p>- Une sonde de niveau.</p><p>- Un boîtier de contrôle.</p><p><br></p><p>- Système connecté à une application.</p><p><br></p><p><br></p><p>Raccordements au réseau de l\'habitation à prévoir par un plombier.</p>',`ligdatmod`='202411061503',`ligusermod`='1607' WHERE 1=1 AND ( id_vent = '80') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '193') LIMIT 1
UID:1607--150314-- UPDATE `vent_att` SET `att7`='6467',`att8`='646.7',`att21`='7113.7',`att9`='7113.7',`att27`='0',`att29`='0',`att28`='6467',`att30`='646.7',`attdatmod`='202411061503',`attusermod`='1607',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '80') AND (id_type = '165') LIMIT 1
UID:1607--150330-- UPDATE `vent_lig` SET `lig10`='5289',`ligdatmod`='202411061503',`ligusermod`='1607' WHERE 1=1 AND ( id_vent = '80') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '193') LIMIT 1
UID:1607--150330-- UPDATE `vent_lig` SET `lig10`='5289',`lig6`='268.00',`lig17`='2680',`lig18`='268',`lig2`='2680.00',`lig4`='2680.00',`lig7`='2948.00',`lig15`='2948.00',`lig90`='<p><b>Fourniture et mise en service d\'une cuve de régulation eau de pluie EPARCO 5m3 comprenant :</b></p><p><b><br></b></p><p>- Une cuve PE 5m3.</p><p>- Un couvercle passage piéton.</p><p>- Un filtre autonettoyant et sa grille de filtration.</p><p>- Une protection anti moustique.</p><p>- Une arrivée d\'eau tranquille.</p><p>- Un kit régulation.</p><p> </p><p><b><br></b></p><p><b><br></b></p><p><b>- Cuve garantie 10 ans</b></p><p><b><br></b></p><p><b><br></b></p><p><b><br></b></p><p><b><br></b></p><p><b><br></b></p>',`ligdatmod`='202411061503',`ligusermod`='1607' WHERE 1=1 AND ( id_vent = '80') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '193') LIMIT 1
UID:1607--150331-- UPDATE `vent_att` SET `att7`='6650',`att8`='665',`att21`='7315',`att9`='7315',`att27`='0',`att29`='0',`att28`='6650',`att30`='665',`attdatmod`='202411061503',`attusermod`='1607',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '80') AND (id_type = '165') LIMIT 1
UID:1607--150419-- UPDATE `vent_lig` SET `lig10`='',`ligdatmod`='202411061504',`ligusermod`='1607' WHERE 1=1 AND ( id_vent = '80') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '193') LIMIT 1
UID:1607--150419-- UPDATE `vent_lig` SET `lig10`='',`lig6`='0.00',`lig17`='0',`lig18`='0',`lig2`='0.00',`lig5`='0',`lig4`='0.00',`lig7`='0.00',`lig15`='0.00',`lig90`='',`ligdatmod`='202411061504',`ligusermod`='1607' WHERE 1=1 AND ( id_vent = '80') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '193') LIMIT 1
UID:1607--150420-- UPDATE `vent_att` SET `att7`='3970',`att8`='397',`att21`='4367',`att9`='4367',`att27`='0',`att29`='0',`att28`='3970',`att30`='397',`attdatmod`='202411061504',`attusermod`='1607',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '80') AND (id_type = '165') LIMIT 1
UID:1607--150431-- UPDATE `vent_lig` SET `lig10`='2363',`ligdatmod`='202411061504',`ligusermod`='1607' WHERE 1=1 AND ( id_vent = '80') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '193') LIMIT 1
UID:1607--150431-- UPDATE `vent_lig` SET `lig10`='2363',`lig6`='497.50',`lig17`='4975',`lig18`='497.5',`lig19`='3973.00',`lig2`='4975.00',`lig5`='10',`lig4`='4975.00',`lig7`='5472.50',`lig15`='5472.50',`lig90`='<p><b>Fourniture et mise en service d\'une filière FILIERE PLATE ECORCES DE PIN 4EH comprenant :</b></p><p><br></p><p>- Une fosse toutes eaux de 3m3 équipée d\'un préfiltre PF16 permettant de piéger les matières et de protéger le filtre.</p><p>- Un filtre compact 4EH composé d\'écorces de pin maritime Français.</p><p>- Un extracteur statique SEPTIPAK.</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>- Vérification du bon fonctionnement de la filière.</p><p><br></p><p><br></p><p>- Garantie 10 ans sans entretien du matériau filtrant.</p><p><br></p><p>- Fabrication Française disposant d\'un agrément Ministériel n° 2022-002-ext01-mod01 et conforme à la Norme NF-EN 12566-3+A1 et à l\'arrêté du 7 septembre 2009.</p>',`ligdatmod`='202411061504',`ligusermod`='1607' WHERE 1=1 AND ( id_vent = '80') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '193') LIMIT 1
UID:1607--150431-- UPDATE `vent_att` SET `att7`='8945',`att8`='894.5',`att21`='9839.5',`att9`='9839.5',`att27`='0',`att29`='0',`att28`='8945',`att30`='894.5',`attdatmod`='202411061504',`attusermod`='1607',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '80') AND (id_type = '165') LIMIT 1
UID:1609--155501-- UPDATE `vent_lig` SET `lig10`='',`ligdatmod`='202411061555',`ligusermod`='1609' WHERE 1=1 AND ( id_vent = '56') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '182') LIMIT 1
UID:1609--155501-- UPDATE `vent_lig` SET `lig10`='',`lig6`='0.00',`lig17`='0',`lig18`='0',`lig2`='0.00',`lig5`='0',`lig4`='0.00',`lig7`='0.00',`lig15`='0.00',`lig90`='',`ligdatmod`='202411061555',`ligusermod`='1609' WHERE 1=1 AND ( id_vent = '56') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '182') LIMIT 1
UID:1609--155501-- UPDATE `vent_att` SET `att7`='0',`att8`='0',`att21`='0',`att9`='0',`att27`='0',`att29`='0',`att28`='0',`att30`='0',`attdatmod`='202411061555',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '56') AND (id_type = '165') LIMIT 1
UID:1609--155508-- UPDATE `vent_lig` SET `lig10`='5731',`ligdatmod`='202411061555',`ligusermod`='1609' WHERE 1=1 AND ( id_vent = '56') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '182') LIMIT 1
UID:1609--155508-- UPDATE `vent_lig` SET `lig10`='5731',`lig6`='241.70',`lig17`='2417',`lig18`='241.7',`lig2`='2417.00',`lig5`='10',`lig4`='2417.00',`lig7`='2658.70',`lig15`='2658.70',`lig90`='<p><b>Fourniture d\'un module de gestion des eaux de pluie "Val\'Eau Out" comprenant :</b></p><p><b><br></b></p><p>- Une pompe immergée.</p><p>- Un bac de disconnexion de 17 litres utiles.</p><p> Disconnexion de type AB - conforme norme EN1717</p><p>- Une sonde de niveau.</p><p>- Un boîtier de contrôle.</p><p><br></p><p><br></p><p>Raccordements au réseau de l\'habitation à prévoir par un plombier.</p>',`ligdatmod`='202411061555',`ligusermod`='1609' WHERE 1=1 AND ( id_vent = '56') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '182') LIMIT 1
UID:1609--155509-- UPDATE `vent_att` SET `att7`='2417',`att8`='241.7',`att21`='2658.7',`att9`='2658.7',`att27`='0',`att29`='0',`att28`='2417',`att30`='241.7',`attdatmod`='202411061555',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '56') AND (id_type = '165') LIMIT 1
UID:1609--171823-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','165','410','1','202411061718' )
UID:1609--171823-- UPDATE `vent_att` SET `att1`='86',`attf100`='20241106',`attf101`='1',`att11`='1609',`attf105`='20241106',`att43`='Remise TTC',`attdatmod`='202411061718',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '116') AND (id_type = '165') LIMIT 1
UID:1609--171823-- UPDATE `vent_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '165') AND (id_vent = '116') LIMIT 1
UID:1609--171823-- UPDATE `vent_att` SET `att1`='86',`attf100`='20241106',`attf101`='1',`att11`='1609',`attf105`='20241106',`att43`='Remise TTC',`att2`='211',`attdatmod`='202411061718',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '116') AND (id_type = '165') LIMIT 1
UID:1609--171823-- UPDATE `vent_att` SET `att1`='86',`attf100`='20241106',`attf101`='1',`att11`='1609',`attf105`='20241206',`att43`='Remise TTC',`att2`='211',`attdatmod`='202411061718',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '116') AND (id_type = '165') LIMIT 1
UID:1609--171823-- UPDATE `vent_att` SET `att1`='86',`attf100`='20241106',`attf101`='1',`att11`='1609',`attf105`='20241206',`att43`='Remise TTC',`att2`='211',`att13`='68f55fe0v5nnxhfm',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/68f55fe0v5nnxhfm',`attdatmod`='202411061718',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '116') AND (id_type = '165') LIMIT 1
UID:1609--171823-- UPDATE `vent_att` SET `att1`='86',`attf100`='20241106',`attf101`='1',`att11`='1609',`attf105`='20241206',`att43`='Remise TTC',`att2`='211',`att13`='68f55fe0v5nnxhfm',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/68f55fe0v5nnxhfm',`att4`='DEV--7',`attdatmod`='202411061718',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '116') AND (id_type = '165') LIMIT 1
UID:1609--171823-- UPDATE `vent_att` SET `att1`='86',`attf100`='20241106',`attf101`='1',`att11`='1609',`attf105`='20241206',`att43`='Remise TTC',`att2`='211',`att13`='68f55fe0v5nnxhfm',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/68f55fe0v5nnxhfm',`att4`='DEV--7',`att18`='Rainea Rainéa Oust et Vilaine
11 Berthé
56220 PLUHERLIN
oustetvilaine@rainea.fr
www.rainea.fr',`att19`=' 5 Prenleho 35550 BRUC SUR AFF',`att20`=' 5 Prenleho 35550 BRUC SUR AFF',`att22`=' Rainea Rainéa Oust et Vilaine
SAS au captial de 5000€ - SIREN 931567663 - RCS : Vannes\n
TVA : FR 14931567663
IBAN : FR76 1380 7109 6533 7219 1638 260 - BIC : CCBPFRPPNAN',`att31`='5 Prenleho',`att33`='35550',`att34`='BRUC SUR AFF',`att35`='France',`att38`='5 Prenleho',`att40`='35550',`att41`='BRUC SUR AFF',`att42`='France',`attdatmod`='202411061718',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '116') AND (id_type = '165') LIMIT 1
UID:1609--171830-- UPDATE `vent_att` SET `att15`='',`att45`='',`att26`='',`attdatmod`='202411061718',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '116') AND (id_type = '165') LIMIT 1
UID:1609--171855-- UPDATE `vent_att` SET `att91`='<p>Devis ECOFLO<br></p>',`attf101`='0',`attdatmod`='202411061718',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '116') AND (id_type = '165') LIMIT 1
UID:1609--171858-- UPDATE `vent_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '165') AND (id_vent = '116') LIMIT 1
UID:1609--171858-- UPDATE `tier_lig` SET `lig2`='7',`ligdatmod`='202411061718',`ligusermod`='1609' WHERE 1=1 AND ( id_tier = '179') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '101') LIMIT 1
UID:1609--171858-- UPDATE `vent_att` SET `att24`='Rainéa Oust et Vilaine
11 Berthé
56220 PLUHERLIN
0648147135
oustetvilaine@rainea.fr
www.rainea.fr
Rainea Rainéa Oust et Vilaine
11 Berthé
56220 PLUHERLIN
oustetvilaine@rainea.fr
www.rainea.fr',`att19`=' 5 Prenleho 35550 BRUC SUR AFF',`att20`=' 5 Prenleho 35550 BRUC SUR AFF',`att22`=' Rainea Rainéa Oust et Vilaine
SAS au captial de 5000€ - SIREN 931567663 - RCS : Vannes\n
TVA : FR 14931567663
IBAN : FR76 1380 7109 6533 7219 1638 260 - BIC : CCBPFRPPNAN',`att31`='5 Prenleho',`att33`='35550',`att34`='BRUC SUR AFF',`att35`='France',`att38`='5 Prenleho',`att40`='35550',`att41`='BRUC SUR AFF',`att42`='France',`attdatmod`='202411061754',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '117') AND (id_type = '165') LIMIT 1
UID:1609--175438-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','117','202411061754','202411061754' )
UID:1609--175438-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411061754',`ligusermod`='1609' WHERE 1=1 AND ( id_vent = '117') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '222') LIMIT 1
UID:1609--175438-- UPDATE `vent_att` SET `att91`='<p>DEVIS REP<br></p>',`att15`='',`att45`='',`att26`='',`attdatmod`='202411061754',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '117') AND (id_type = '165') LIMIT 1
UID:1609--175438-- UPDATE `vent_att` SET `att91`='<p>DEVIS REP<br></p>',`att15`='',`att45`='',`att26`='',`att7`='0',`att8`='0',`att21`='0',`att9`='0',`att27`='0',`att29`='0',`att28`='0',`att30`='0',`attdatmod`='202411061754',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '117') AND (id_type = '165') LIMIT 1
UID:1609--175450-- UPDATE `vent_lig` SET `lig10`='3461',`ligdatmod`='202411061754',`ligusermod`='1609' WHERE 1=1 AND ( id_vent = '117') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '222') LIMIT 1
UID:1609--175450-- UPDATE `vent_lig` SET `lig10`='3461',`lig6`='384.00',`lig13`='0.00',`lig16`='0',`lig17`='3840',`lig18`='384',`lig19`='0.00',`lig2`='3840.00',`lig5`='10',`lig4`='3840.00',`lig7`='4224.00',`lig9`='',`lig14`='0',`lig15`='4224.00',`lig90`='<p><b>Fourniture et mise en service d\'une cuve de régulation eau de pluie REWATEC 7m3 comprenant :</b></p><p><br></p><p>- Une cuve plate PE 7m3.</p><p>- Un couvercle passage piéton D550.</p><p>- Une réhausse D550 H: 20cm et son joint étanche.</p><p>- Un filtre autonettoyant et sa grille de filtration.</p><p>- Un couvercle anti rongeurs / anti moustiques.</p><p>- Une arrivée d\'eau tranquille.</p><p>- Un disque de régulation.</p><p><br></p><p> (pompe non fournie)</p><p><br></p><p>- Fabrication Française</p><p>- Cuve garantie 35 ans</p><p><br></p>',`ligdatmod`='202411061754',`ligusermod`='1609' WHERE 1=1 AND ( id_vent = '117') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '222') LIMIT 1
UID:1609--175450-- UPDATE `vent_att` SET `att7`='3840',`att8`='384',`att21`='4224',`att9`='4224',`att27`='0',`att29`='0',`att28`='3840',`att30`='384',`attdatmod`='202411061754',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '117') AND (id_type = '165') LIMIT 1
UID:1609--180135-- UPDATE `vent_lig` SET `lig10`='',`ligdatmod`='202411061801',`ligusermod`='1609' WHERE 1=1 AND ( id_vent = '117') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '222') LIMIT 1
UID:1609--180135-- UPDATE `vent_lig` SET `lig10`='',`lig6`='0.00',`lig17`='0',`lig18`='0',`lig2`='0.00',`lig5`='0',`lig4`='0.00',`lig7`='0.00',`lig15`='0.00',`lig90`='',`ligdatmod`='202411061801',`ligusermod`='1609' WHERE 1=1 AND ( id_vent = '117') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '222') LIMIT 1
UID:1609--180135-- UPDATE `vent_att` SET `att7`='0',`att8`='0',`att21`='0',`att9`='0',`att27`='0',`att29`='0',`att28`='0',`att30`='0',`attdatmod`='202411061801',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '117') AND (id_type = '165') LIMIT 1
UID:1609--180143-- UPDATE `vent_lig` SET `lig10`='5467',`ligdatmod`='202411061801',`ligusermod`='1609' WHERE 1=1 AND ( id_vent = '117') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '222') LIMIT 1
UID:1609--180143-- UPDATE `vent_lig` SET `lig10`='5467',`lig6`='267.00',`lig17`='2670',`lig18`='267',`lig2`='2670.00',`lig5`='10',`lig4`='2670.00',`lig7`='2937.00',`lig15`='2937.00',`lig90`='<p><b>Fourniture d\'une Cuve Rainéa 5 000L comprenant:</b></p><p><br></p><p>Une cuve de récupération PEHD d\'une capacité de 5 000L.</p><p>- une arrivée d\'eau tranquille Ø100.</p><p>- un couvercle passage piéton verrouillable.</p><p>- une réhausse avec équipement de filtration (filtre autonettoyant 0,6 mm avec 2 passes cloison étanches).</p><p>- un système de trop-plein pour la cuve et pour le filtre.</p><p><br></p><p>Cuve garantie 10 Ans (100% étanche et imputrescible).</p><p><br></p><p>Fabriquée en Normandie.</p><p><br></p><p>Système conforme à la norme NF P 16-005</p>',`ligdatmod`='202411061801',`ligusermod`='1609' WHERE 1=1 AND ( id_vent = '117') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '222') LIMIT 1
UID:1609--180143-- UPDATE `vent_att` SET `att7`='2670',`att8`='267',`att21`='2937',`att9`='2937',`att27`='0',`att29`='0',`att28`='2670',`att30`='267',`attdatmod`='202411061801',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '117') AND (id_type = '165') LIMIT 1
UID:1609--181319-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','117','202411061813','202411061813' )
UID:1609--181319-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411061813',`ligusermod`='1609' WHERE 1=1 AND ( id_vent = '117') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '223') LIMIT 1
UID:1609--181320-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411061813',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '117') AND (id_type = '165') LIMIT 1
UID:1609--181331-- UPDATE `vent_lig` SET `lig10`='5775',`ligdatmod`='202411061813',`ligusermod`='1609' WHERE 1=1 AND ( id_vent = '117') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '223') LIMIT 1
UID:1609--181331-- UPDATE `vent_lig` SET `lig10`='5775',`lig6`='190.70',`lig13`='0.00',`lig16`='0',`lig17`='1907',`lig18`='190.7',`lig19`='0.00',`lig2`='1907.00',`lig5`='10',`lig4`='1907.00',`lig7`='2097.70',`lig9`='',`lig14`='0',`lig15`='2097.70',`lig90`='<p><b>Fourniture d\'un module de gestion des eaux de pluie "Val\'Eau In" comprenant :</b></p><p><b><br></b></p><p>- Une pompe de surface.</p><p>- Un bac de disconnexion de 17 litres utiles.</p><p> Disconnexion de type AB - conforme norme EN1717</p><p>- Une sonde de niveau.</p><p>- Un boîtier de contrôle.</p><p><br></p><p><br></p><p>Raccordements au réseau de l\'habitation à prévoir par un plombier.</p>',`ligdatmod`='202411061813',`ligusermod`='1609' WHERE 1=1 AND ( id_vent = '117') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '223') LIMIT 1
UID:1609--181331-- UPDATE `vent_att` SET `att7`='4577',`att8`='457.7',`att21`='5034.7',`att9`='5034.7',`att27`='0',`att29`='0',`att28`='4577',`att30`='457.7',`attdatmod`='202411061813',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '117') AND (id_type = '165') LIMIT 1
UID:1609--181444-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','117','202411061814','202411061814' )
UID:1609--181444-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411061814',`ligusermod`='1609' WHERE 1=1 AND ( id_vent = '117') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '224') LIMIT 1
UID:1609--181444-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411061814',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '117') AND (id_type = '165') LIMIT 1
UID:1606--183444-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','205','1','202411061834' )
UID:1606--183444-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1606',`att18`='France',`attf102`='20241106',`attf103`='1',`attf104`='1',`attf105`='20241106',`attdatmod`='202411061834',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '264') AND (id_type = '80') LIMIT 1
UID:1606--183444-- UPDATE `tier_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '80') AND (id_tier = '264') LIMIT 1
UID:1606--183444-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1606',`att18`='France',`attf102`='20241106',`attf103`='1',`attf104`='1',`attf105`='20241106',`att22`='CLI--9',`attdatmod`='202411061834',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '264') AND (id_type = '80') LIMIT 1
UID:1606--183444-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1606',`att18`='France',`attf102`='20241106',`attf103`='1',`attf104`='1',`attf105`='20241106',`att22`='CLI--9',`att16`='Neudin',`attdatmod`='202411061834',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '264') AND (id_type = '80') LIMIT 1
UID:1606--183920-- UPDATE `tier_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '80') AND (id_tier = '264') LIMIT 1
UID:1606--183920-- UPDATE `tier_att` SET `att3`='Gérard',`att90`='<p>Contact foire de St-Lô</p><p>2 personnes retraitées.</p><p>Souhaitent informations sur osmoseur.</p><p>rdv le 05/11/2024 chez eux.</p>',`att1`='DOUSSAUD',`att10`='madame_monsieur',`att12`='gerard.doussaud@orange.fr',`att14`='33, Place Henri Chardon',`att15`='',`att7`='50000',`att17`='Saint-Lô',`att6`='0676253237',`att5`='',`att11`='salon',`attdatmod`='202411061839',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '264') AND (id_type = '80') LIMIT 1
UID:1606--183920-- UPDATE `tier_att` SET `att3`='Gérard',`att90`='<p>Contact foire de St-Lô</p><p>2 personnes retraitées.</p><p>Souhaitent informations sur osmoseur.</p><p>rdv le 05/11/2024 chez eux.</p>',`att1`='DOUSSAUD',`att10`='madame_monsieur',`att12`='gerard.doussaud@orange.fr',`att14`='33, Place Henri Chardon',`att15`='',`att7`='50000',`att17`='Saint-Lô',`att6`='0676253237',`att5`='',`att11`='salon',`att19`='49.101063',`att20`='-1.08392',`attdatmod`='202411061839',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '264') AND (id_type = '80') LIMIT 1
UID:1606--183920-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','264','202411061839','202411061839' )
UID:1606--183920-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='33, Place Henri Chardon',`lig3`='',`lig4`='50000',`lig5`='Saint-Lô',`lig6`='France',`ligdatmod`='202411061839',`ligusermod`='1606' WHERE 1=1 AND ( id_tier = '264') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '152') LIMIT 1
UID:1606--183921-- UPDATE `tier_att` SET `att3`='Gérard',`att90`='<p>Contact foire de St-Lô</p><p>2 personnes retraitées.</p><p>Souhaitent informations sur osmoseur.</p><p>rdv le 05/11/2024 chez eux.</p>',`att1`='DOUSSAUD',`att10`='madame_monsieur',`att12`='gerard.doussaud@orange.fr',`att14`='33, Place Henri Chardon',`att15`='',`att7`='50000',`att17`='Saint-Lô',`att6`='0676253237',`att5`='',`att11`='salon',`att19`='49.101063',`att20`='-1.08392',`attf100`='1',`attdatmod`='202411061839',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '264') AND (id_type = '80') LIMIT 1
UID:1606--183921-- UPDATE `tier_lig` SET `lig2`='9',`ligdatmod`='202411061839',`ligusermod`='1606' WHERE 1=1 AND ( id_tier = '172') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '82') LIMIT 1
UID:1606--183921-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202411061839' )
UID:1606--183921-- UPDATE `tier_att` SET `att2`='DOUSSAUD',`att3`='Gérard',`att4`='',`att5`='0676253237',`att6`='gerard.doussaud@orange.fr',`att7`='madame_monsieur',`att8`='264',`att10`='1606',`attdatmod`='202411061839',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '265') AND (id_type = '149') LIMIT 1
UID:1606--183921-- UPDATE `tier_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '149') AND (id_tier = '265') LIMIT 1
UID:1606--183924-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202411061839' )
UID:1606--183924-- UPDATE `vent_att` SET `att1`='OPP-',`att2`='264',`attf100`='20241106',`att6`='1606',`attdatmod`='202411061839',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '118') AND (id_type = '148') LIMIT 1
UID:1606--183924-- UPDATE `vent_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '148') AND (id_vent = '118') LIMIT 1
UID:1606--183924-- UPDATE `vent_att` SET `att1`='OPP-DOUSSAUD',`att2`='264',`attf100`='20241106',`att6`='1606',`attdatmod`='202411061839',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '118') AND (id_type = '148') LIMIT 1
UID:1606--183924-- UPDATE `vent_att` SET `att1`='OPP-DOUSSAUD',`att2`='264',`attf100`='20241106',`att6`='1606',`att5`='',`att10`='particulier',`attdatmod`='202411061839',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '118') AND (id_type = '148') LIMIT 1
UID:1606--183958-- UPDATE `vent_att` SET `att8`='152',`att9`='265',`attf102`='202411051000',`att3`='traitement_eau',`attdatmod`='202411061839',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '118') AND (id_type = '148') LIMIT 1
UID:1606--183958-- UPDATE `vent_att` SET `att8`='152',`att9`='265',`attf102`='202411051000',`att3`='traitement_eau',`id_work`='374',`attdatmod`='202411061839',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '118') AND (id_type = '148') LIMIT 1
UID:1609--184200-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202411061842' )
UID:1609--184200-- UPDATE `vent_att` SET `att1`='OPP-',`att2`='211',`attf100`='20241106',`att6`='1609',`attdatmod`='202411061842',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '119') AND (id_type = '148') LIMIT 1
UID:1609--184200-- UPDATE `vent_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '148') AND (id_vent = '119') LIMIT 1
UID:1609--184200-- UPDATE `vent_att` SET `att1`='OPP-Gomis',`att2`='211',`attf100`='20241106',`att6`='1609',`attdatmod`='202411061842',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '119') AND (id_type = '148') LIMIT 1
UID:1609--184200-- UPDATE `vent_att` SET `att1`='OPP-Gomis',`att2`='211',`attf100`='20241106',`att6`='1609',`att5`='',`att10`='particulier',`attdatmod`='202411061842',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '119') AND (id_type = '148') LIMIT 1
UID:1609--184217-- UPDATE `vent_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '148') AND (id_vent = '119') LIMIT 1
UID:1609--184217-- UPDATE `vent_att` SET `att90`='<p>Travaux complémentaires <br></p>',`att8`='',`att9`='',`att3`='divers',`attdatmod`='202411061842',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '119') AND (id_type = '148') LIMIT 1
UID:1609--184219-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','165','410','1','202411061842' )
UID:1609--184219-- UPDATE `vent_att` SET `att1`='119',`attf100`='20241106',`attf101`='1',`att11`='1609',`attf105`='20241106',`att43`='Remise TTC',`attdatmod`='202411061842',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '120') AND (id_type = '165') LIMIT 1
UID:1609--184219-- UPDATE `vent_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '165') AND (id_vent = '120') LIMIT 1
UID:1609--184219-- UPDATE `vent_att` SET `att1`='119',`attf100`='20241106',`attf101`='1',`att11`='1609',`attf105`='20241106',`att43`='Remise TTC',`att2`='211',`attdatmod`='202411061842',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '120') AND (id_type = '165') LIMIT 1
UID:1609--184219-- UPDATE `vent_att` SET `att1`='119',`attf100`='20241106',`attf101`='1',`att11`='1609',`attf105`='20241206',`att43`='Remise TTC',`att2`='211',`attdatmod`='202411061842',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '120') AND (id_type = '165') LIMIT 1
UID:1609--184220-- UPDATE `vent_att` SET `att1`='119',`attf100`='20241106',`attf101`='1',`att11`='1609',`attf105`='20241206',`att43`='Remise TTC',`att2`='211',`att13`='gpym0sd-kd78h6wb',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/gpym0sd-kd78h6wb',`attdatmod`='202411061842',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '120') AND (id_type = '165') LIMIT 1
UID:1609--184220-- UPDATE `vent_att` SET `att1`='119',`attf100`='20241106',`attf101`='1',`att11`='1609',`attf105`='20241206',`att43`='Remise TTC',`att2`='211',`att13`='gpym0sd-kd78h6wb',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/gpym0sd-kd78h6wb',`att4`='DEV--8',`attdatmod`='202411061842',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '120') AND (id_type = '165') LIMIT 1
UID:1609--184220-- UPDATE `vent_att` SET `att1`='119',`attf100`='20241106',`attf101`='1',`att11`='1609',`attf105`='20241206',`att43`='Remise TTC',`att2`='211',`att13`='gpym0sd-kd78h6wb',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/gpym0sd-kd78h6wb',`att4`='DEV--8',`att18`='Rainea Rainéa Oust et Vilaine
11 Berthé
56220 PLUHERLIN
oustetvilaine@rainea.fr
www.rainea.fr',`att19`=' 5 Prenleho 35550 BRUC SUR AFF',`att20`=' 5 Prenleho 35550 BRUC SUR AFF',`att22`=' Rainea Rainéa Oust et Vilaine
SAS au captial de 5000€ - SIREN 931567663 - RCS : Vannes\n
TVA : FR 14931567663
IBAN : FR76 1380 7109 6533 7219 1638 260 - BIC : CCBPFRPPNAN',`att31`='5 Prenleho',`att33`='35550',`att34`='BRUC SUR AFF',`att35`='France',`att38`='5 Prenleho',`att40`='35550',`att41`='BRUC SUR AFF',`att42`='France',`attdatmod`='202411061842',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '120') AND (id_type = '165') LIMIT 1
UID:1609--184224-- UPDATE `vent_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '165') AND (id_vent = '120') LIMIT 1
UID:1609--184224-- UPDATE `vent_att` SET `att15`='',`att45`='',`att26`='',`attdatmod`='202411061842',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '120') AND (id_type = '165') LIMIT 1
UID:1609--184224-- UPDATE `tier_lig` SET `lig2`='8',`ligdatmod`='202411061842',`ligusermod`='1609' WHERE 1=1 AND ( id_tier = '179') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '101') LIMIT 1
UID:1609--184224-- UPDATE `vent_att` SET `att15`='',`att45`='',`att26`='',`att24`='Rainéa Oust et Vilaine
11 Berthé
56220 PLUHERLIN
0648147135
oustetvilaine@rainea.fr
www.rainea.fr
Rainea Rainéa 50
330 Rue Valvire
50000 Saint-Lô
manche@rainea.fr
www.rainea.fr',`att19`=' 33, Place Henri Chardon 50000 Saint-Lô',`att20`=' 33, Place Henri Chardon 50000 Saint-Lô',`att22`=' Rainea Rainéa 50
SAS au captial de 5000€ - SIREN 933465817 - RCS : Coutances\n
TVA : FR91933465817
IBAN : - BIC : ',`att31`='33, Place Henri Chardon',`att33`='50000',`att34`='Saint-Lô',`att35`='France',`att38`='33, Place Henri Chardon',`att40`='50000',`att41`='Saint-Lô',`att42`='France',`attdatmod`='202411061843',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '121') AND (id_type = '165') LIMIT 1
UID:1609--184329-- UPDATE `vent_att` SET `att1`='REP',`attdatmod`='202411061843',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '87') AND (id_type = '148') LIMIT 1
UID:1609--184347-- UPDATE `vent_att` SET `att1`='ANC',`attdatmod`='202411061843',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '86') AND (id_type = '148') LIMIT 1
UID:1606--184402-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','121','202411061844','202411061844' )
UID:1606--184402-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411061844',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--184402-- UPDATE `vent_att` SET `att15`='virement',`att45`='30% à la commande, solde fin de chantier.',`att26`='',`attdatmod`='202411061844',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '121') AND (id_type = '165') LIMIT 1
UID:1606--184402-- 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`='202411061844',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '121') AND (id_type = '165') LIMIT 1
UID:1609--184405-- UPDATE `vent_att` SET `att1`='Travaux complémentaires',`attdatmod`='202411061844',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '119') AND (id_type = '148') LIMIT 1
UID:1609--184416-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','165','410','1','202411061844' )
UID:1609--184416-- UPDATE `vent_att` SET `att1`='87',`attf100`='20241106',`attf101`='1',`att11`='1609',`attf105`='20241106',`att43`='Remise TTC',`attdatmod`='202411061844',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '122') AND (id_type = '165') LIMIT 1
UID:1609--184416-- UPDATE `vent_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '165') AND (id_vent = '122') LIMIT 1
UID:1609--184416-- UPDATE `vent_att` SET `att1`='87',`attf100`='20241106',`attf101`='1',`att11`='1609',`attf105`='20241106',`att43`='Remise TTC',`att2`='211',`attdatmod`='202411061844',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '122') AND (id_type = '165') LIMIT 1
UID:1609--184416-- UPDATE `vent_att` SET `att1`='87',`attf100`='20241106',`attf101`='1',`att11`='1609',`attf105`='20241206',`att43`='Remise TTC',`att2`='211',`attdatmod`='202411061844',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '122') AND (id_type = '165') LIMIT 1
UID:1609--184416-- UPDATE `vent_att` SET `att1`='87',`attf100`='20241106',`attf101`='1',`att11`='1609',`attf105`='20241206',`att43`='Remise TTC',`att2`='211',`att13`='wes4wi3p93y-0mj4',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/wes4wi3p93y-0mj4',`attdatmod`='202411061844',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '122') AND (id_type = '165') LIMIT 1
UID:1609--184416-- UPDATE `vent_att` SET `att1`='87',`attf100`='20241106',`attf101`='1',`att11`='1609',`attf105`='20241206',`att43`='Remise TTC',`att2`='211',`att13`='wes4wi3p93y-0mj4',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/wes4wi3p93y-0mj4',`att4`='DEV--9',`attdatmod`='202411061844',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '122') AND (id_type = '165') LIMIT 1
UID:1609--184416-- UPDATE `vent_att` SET `att1`='87',`attf100`='20241106',`attf101`='1',`att11`='1609',`attf105`='20241206',`att43`='Remise TTC',`att2`='211',`att13`='wes4wi3p93y-0mj4',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/wes4wi3p93y-0mj4',`att4`='DEV--9',`att18`='Rainea Rainéa Oust et Vilaine
11 Berthé
56220 PLUHERLIN
oustetvilaine@rainea.fr
www.rainea.fr',`att19`=' 5 Prenleho 35550 BRUC SUR AFF',`att20`=' 5 Prenleho 35550 BRUC SUR AFF',`att22`=' Rainea Rainéa Oust et Vilaine
SAS au captial de 5000€ - SIREN 931567663 - RCS : Vannes\n
TVA : FR 14931567663
IBAN : FR76 1380 7109 6533 7219 1638 260 - BIC : CCBPFRPPNAN',`att31`='5 Prenleho',`att33`='35550',`att34`='BRUC SUR AFF',`att35`='France',`att38`='5 Prenleho',`att40`='35550',`att41`='BRUC SUR AFF',`att42`='France',`attdatmod`='202411061844',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '122') AND (id_type = '165') LIMIT 1
UID:1609--184419-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','122','202411061844','202411061844' )
UID:1609--184419-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411061844',`ligusermod`='1609' WHERE 1=1 AND ( id_vent = '122') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '226') LIMIT 1
UID:1609--184419-- UPDATE `vent_att` SET `att15`='',`att45`='',`att26`='',`attdatmod`='202411061844',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '122') AND (id_type = '165') LIMIT 1
UID:1609--184419-- UPDATE `vent_att` SET `att15`='',`att45`='',`att26`='',`att7`='0',`att8`='0',`att21`='0',`att9`='0',`att27`='0',`att29`='0',`att28`='0',`att30`='0',`attdatmod`='202411061844',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '122') AND (id_type = '165') LIMIT 1
UID:1609--184427-- UPDATE `vent_lig` SET `lig10`='3483',`ligdatmod`='202411061844',`ligusermod`='1609' WHERE 1=1 AND ( id_vent = '122') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '226') LIMIT 1
UID:1609--184427-- UPDATE `vent_lig` SET `lig10`='3483',`lig6`='319.00',`lig13`='0.00',`lig16`='0',`lig17`='3190',`lig18`='319',`lig19`='0.00',`lig2`='3190.00',`lig5`='10',`lig4`='3190.00',`lig7`='3509.00',`lig9`='',`lig14`='0',`lig15`='3509.00',`lig90`='<p><b>Fourniture et mise en service d\'une cuve de régulation eau de pluie REWATEC 5m3 comprenant :</b></p><p><br></p><p>- Une cuve plate PE 5m3.</p><p>- Un couvercle passage piéton D550.</p><p>- Une réhausse D550 H: 20cm et son joint étanche.</p><p>- Un filtre autonettoyant et sa grille de filtration.</p><p>- Un couvercle anti rongeurs / anti moustiques.</p><p>- Une arrivée d\'eau tranquille.</p><p>- Un disque de régulation.</p><p><br></p><p> (pompe non fournie)</p><p><br></p><p>- Fabrication Française</p><p>- Cuve garantie 35 ans</p><p><br></p><p><br></p><p><br></p><p><br></p><p><b><br></b></p>',`ligdatmod`='202411061844',`ligusermod`='1609' WHERE 1=1 AND ( id_vent = '122') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '226') LIMIT 1
UID:1609--184427-- UPDATE `vent_att` SET `att7`='3190',`att8`='319',`att21`='3509',`att9`='3509',`att27`='0',`att29`='0',`att28`='3190',`att30`='319',`attdatmod`='202411061844',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '122') AND (id_type = '165') LIMIT 1
UID:1606--184432-- UPDATE `vent_lig` SET `lig10`='2653',`ligdatmod`='202411061844',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--184432-- UPDATE `vent_lig` SET `lig10`='2653',`lig6`='180.00',`lig13`='0.00',`lig16`='0',`lig17`='900',`lig18`='180',`lig19`='0.00',`lig2`='900.00',`lig5`='20',`lig4`='900.00',`lig7`='1080.00',`lig9`='',`lig14`='0',`lig15`='1080.00',`lig90`='<p><b>Fourniture d\'un osmoseur domestique compact NETOS comprenant:</b></p><p><br></p><p>- Un osmoseur NETOS.</p><p>- Un robinet simple.</p><p>- Kit de raccordement.</p><p>- Cartouches (filtre 5µm, charbon actif, bloc de charbon, membrane).</p><p><br></p><p><br></p><p>Certificat de conformité Européen.</p><p>Garantie 2 ans. </p>',`ligdatmod`='202411061844',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--184432-- UPDATE `vent_att` SET `att7`='900',`att8`='180',`att21`='1080',`att9`='1080',`att27`='0',`att29`='0',`att28`='900',`att30`='180',`attdatmod`='202411061844',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '121') AND (id_type = '165') LIMIT 1
UID:1609--184436-- UPDATE `vent_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '165') AND (id_vent = '122') LIMIT 1
UID:1609--184436-- UPDATE `tier_lig` SET `lig2`='9',`ligdatmod`='202411061844',`ligusermod`='1609' WHERE 1=1 AND ( id_tier = '179') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '101') LIMIT 1
UID:1609--184436-- UPDATE `vent_att` SET `att24`='Rainéa Oust et Vilaine
11 Berthé
56220 PLUHERLIN
0648147135
oustetvilaine@rainea.fr
www.rainea.fr
Fourniture et pose d\'un osmoseur domestique compact NETOS comprenant:
- Un osmoseur NETOS.
- Un robinet simple.
- Kit de raccordement.
- Cartouches (filtre 5µm, charbon actif, bloc de charbon, membrane).
Certificat de conformité Européen.
Garantie 2 ans.
',`ligdatmod`='202411061845',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--184539-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411061845',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '121') AND (id_type = '165') LIMIT 1
UID:1606--184558-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','121','202411061845','202411061845' )
UID:1606--184558-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411061845',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '227') LIMIT 1
UID:1606--184559-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411061845',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '121') AND (id_type = '165') LIMIT 1
UID:1606--184720-- UPDATE `vent_lig` SET `actif`='0' WHERE 1=1 AND (id_vent = '121') AND (id_type = '165') AND (id_tlig = '162') AND (id_lig = '227')
UID:1606--184721-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411061847',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '121') AND (id_type = '165') LIMIT 1
UID:1606--184757-- UPDATE `vent_lig` SET `lig2`='1200.00',`ligdatmod`='202411061847',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--184757-- UPDATE `vent_lig` SET `lig2`='1200.00',`lig6`='120.00',`lig17`='1200',`lig18`='120',`lig4`='1200.00',`lig7`='1320.00',`lig15`='1320.00',`ligdatmod`='202411061847',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--184757-- UPDATE `vent_att` SET `att7`='1200',`att8`='120',`att21`='1320',`att9`='1320',`att27`='0',`att29`='0',`att28`='1200',`att30`='120',`attdatmod`='202411061847',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '121') AND (id_type = '165') LIMIT 1
UID:1606--184810-- UPDATE `vent_lig` SET `lig2`='1150.00',`ligdatmod`='202411061848',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--184810-- UPDATE `vent_lig` SET `lig2`='1150.00',`lig6`='115.00',`lig17`='1150',`lig18`='115',`lig4`='1150.00',`lig7`='1265.00',`lig15`='1265.00',`ligdatmod`='202411061848',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--184810-- UPDATE `vent_att` SET `att7`='1150',`att8`='115',`att21`='1265',`att9`='1265',`att27`='0',`att29`='0',`att28`='1150',`att30`='115',`attdatmod`='202411061848',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '121') AND (id_type = '165') LIMIT 1
UID:1606--184832-- UPDATE `vent_lig` SET `lig2`='1170.00',`ligdatmod`='202411061848',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--184832-- UPDATE `vent_lig` SET `lig2`='1170.00',`lig6`='117.00',`lig17`='1170',`lig18`='117',`lig4`='1170.00',`lig7`='1287.00',`lig15`='1287.00',`ligdatmod`='202411061848',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--184832-- UPDATE `vent_att` SET `att7`='1170',`att8`='117',`att21`='1287',`att9`='1287',`att27`='0',`att29`='0',`att28`='1170',`att30`='117',`attdatmod`='202411061848',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '121') AND (id_type = '165') LIMIT 1
UID:1606--184839-- UPDATE `vent_lig` SET `lig2`='1172.00',`ligdatmod`='202411061848',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--184839-- UPDATE `vent_lig` SET `lig2`='1172.00',`lig6`='117.20',`lig17`='1172',`lig18`='117.2',`lig4`='1172.00',`lig7`='1289.20',`lig15`='1289.20',`ligdatmod`='202411061848',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--184839-- UPDATE `vent_att` SET `att7`='1172',`att8`='117.2',`att21`='1289.2',`att9`='1289.2',`att27`='0',`att29`='0',`att28`='1172',`att30`='117.2',`attdatmod`='202411061848',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '121') AND (id_type = '165') LIMIT 1
UID:1606--184845-- UPDATE `vent_lig` SET `lig2`='1173.00',`ligdatmod`='202411061848',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--184845-- UPDATE `vent_lig` SET `lig2`='1173.00',`lig6`='117.30',`lig17`='1173',`lig18`='117.3',`lig4`='1173.00',`lig7`='1290.30',`lig15`='1290.30',`ligdatmod`='202411061848',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--184846-- UPDATE `vent_att` SET `att7`='1173',`att8`='117.3',`att21`='1290.3',`att9`='1290.3',`att27`='0',`att29`='0',`att28`='1173',`att30`='117.3',`attdatmod`='202411061848',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '121') AND (id_type = '165') LIMIT 1
UID:1606--184904-- UPDATE `vent_lig` SET `lig2`='1172.90',`ligdatmod`='202411061849',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--184904-- UPDATE `vent_lig` SET `lig2`='1172.90',`lig6`='117.29',`lig17`='1172.9',`lig18`='117.29',`lig4`='1172.90',`lig7`='1290.19',`lig15`='1290.19',`ligdatmod`='202411061849',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--184904-- UPDATE `vent_att` SET `att7`='1172.9',`att8`='117.29',`att21`='1290.19',`att9`='1290.19',`att27`='0',`att29`='0',`att28`='1172.9',`att30`='117.29',`attdatmod`='202411061849',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '121') AND (id_type = '165') LIMIT 1
UID:1606--184910-- UPDATE `vent_lig` SET `lig2`='1172.70',`ligdatmod`='202411061849',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--184910-- UPDATE `vent_lig` SET `lig2`='1172.70',`lig6`='117.27',`lig17`='1172.7',`lig18`='117.27',`lig4`='1172.70',`lig7`='1289.97',`lig15`='1289.97',`ligdatmod`='202411061849',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--184911-- UPDATE `vent_att` SET `att7`='1172.7',`att8`='117.27',`att21`='1289.97',`att9`='1289.97',`att27`='0',`att29`='0',`att28`='1172.7',`att30`='117.27',`attdatmod`='202411061849',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '121') AND (id_type = '165') LIMIT 1
UID:1606--184918-- UPDATE `vent_lig` SET `lig2`='1172.80',`ligdatmod`='202411061849',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--184918-- UPDATE `vent_lig` SET `lig2`='1172.80',`lig6`='117.28',`lig17`='1172.8',`lig18`='117.28',`lig4`='1172.80',`lig7`='1290.08',`lig15`='1290.08',`ligdatmod`='202411061849',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--184918-- UPDATE `vent_att` SET `att7`='1172.8',`att8`='117.28',`att21`='1290.08',`att9`='1290.08',`att27`='0',`att29`='0',`att28`='1172.8',`att30`='117.28',`attdatmod`='202411061849',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '121') AND (id_type = '165') LIMIT 1
UID:1606--184925-- UPDATE `vent_lig` SET `lig2`='1172.75',`ligdatmod`='202411061849',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--184925-- UPDATE `vent_lig` SET `lig2`='1172.75',`lig17`='1172.75',`lig18`='117.275',`lig4`='1172.75',`lig7`='1290.03',`lig15`='1290.03',`ligdatmod`='202411061849',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--184925-- UPDATE `vent_att` SET `att7`='1172.75',`att21`='1290.03',`att9`='1290.03',`att27`='0',`att29`='0',`att28`='1172.75',`att30`='117.275',`attdatmod`='202411061849',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '121') AND (id_type = '165') LIMIT 1
UID:1606--184931-- UPDATE `vent_lig` SET `lig2`='1172.72',`ligdatmod`='202411061849',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--184931-- UPDATE `vent_lig` SET `lig2`='1172.72',`lig6`='117.27',`lig17`='1172.72',`lig18`='117.272',`lig4`='1172.72',`lig7`='1289.99',`lig15`='1289.99',`ligdatmod`='202411061849',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--184931-- UPDATE `vent_att` SET `att7`='1172.72',`att8`='117.27',`att21`='1289.99',`att9`='1289.99',`att27`='0',`att29`='0',`att28`='1172.72',`att30`='117.272',`attdatmod`='202411061849',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '121') AND (id_type = '165') LIMIT 1
UID:1606--184937-- UPDATE `vent_lig` SET `lig2`='1172.73',`ligdatmod`='202411061849',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--184937-- UPDATE `vent_lig` SET `lig2`='1172.73',`lig17`='1172.73',`lig18`='117.273',`lig4`='1172.73',`lig7`='1290.00',`lig15`='1290.00',`ligdatmod`='202411061849',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--184937-- UPDATE `vent_att` SET `att7`='1172.73',`att21`='1290',`att9`='1290',`att27`='0',`att29`='0',`att28`='1172.73',`att30`='117.273',`attdatmod`='202411061849',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '121') AND (id_type = '165') LIMIT 1
UID:1606--185015-- UPDATE `vent_lig` SET `lig2`='1200.00',`ligdatmod`='202411061850',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--185015-- UPDATE `vent_lig` SET `lig2`='1200.00',`lig6`='120.00',`lig17`='1200',`lig18`='120',`lig4`='1200.00',`lig7`='1320.00',`lig15`='1320.00',`ligdatmod`='202411061850',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--185015-- UPDATE `vent_att` SET `att7`='1200',`att8`='120',`att21`='1320',`att9`='1320',`att27`='0',`att29`='0',`att28`='1200',`att30`='120',`attdatmod`='202411061850',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '121') AND (id_type = '165') LIMIT 1
UID:1606--185054-- UPDATE `vent_lig` SET `lig2`='1172.73',`ligdatmod`='202411061850',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--185054-- UPDATE `vent_lig` SET `lig2`='1172.73',`lig6`='117.27',`lig17`='1172.73',`lig18`='117.273',`lig4`='1172.73',`lig7`='1290.00',`lig15`='1290.00',`ligdatmod`='202411061850',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '121') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '225') LIMIT 1
UID:1606--185054-- UPDATE `vent_att` SET `att7`='1172.73',`att8`='117.27',`att21`='1290',`att9`='1290',`att27`='0',`att29`='0',`att28`='1172.73',`att30`='117.273',`attdatmod`='202411061850',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '121') AND (id_type = '165') LIMIT 1
UID:1606--185503-- UPDATE `vent_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '165') AND (id_vent = '121') LIMIT 1
UID:1606--185503-- UPDATE `tier_lig` SET `lig2`='9',`ligdatmod`='202411061855',`ligusermod`='1606' WHERE 1=1 AND ( id_tier = '172') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '83') LIMIT 1
UID:1606--185503-- UPDATE `vent_att` SET `att24`='Rainéa 50
330 Rue Valvire
50000 Saint-Lô
0763868140
manche@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--9)\r\n \r\n\r\n \r\n Bonjour Madame et Monsieur DOUSSAUD,
\r\n Comme convenu, vous trouverez en pièce jointe le devis correspondant à votre projet d\'osmoseur. 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.
Bien cordialement,
\r\n \r\n\r\n \r\n Votre équipe RAINEA - Rainéa 50\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/rainea50.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/soft/v2017b/../../data/doc/1/19-17-896-1§Osmoseur NETOS.pdf;/mnt/big/prod/toosmart_rainea/soft/v2017b/../../data/doc/1/20-18-248-1§Présentation Rainéa 50.pdf;/mnt/big/prod/toosmart_rainea/soft/v2017b/../../data/doc/1/21-19-590-1§rib.pdf;/mnt/big/prod/toosmart_rainea/data/tmp/Devis_DEV--9.pdf§Devis_DEV--9.pdf','0','v2017b' )
UID:1606--185757-- UPDATE `email` SET `type`='',`bcc`='' WHERE 1=1 AND (id_email = '155') LIMIT 1
UID:1606--185757-- UPDATE `vent_att` SET `attf104`='20241106',`id_work`='411',`attdatmod`='202411061857',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '121') AND (id_type = '165') LIMIT 1
UID:1606--185757-- UPDATE `vent_att` SET `attf104`='20241106',`id_work`='411',`attf106`='20241106',`attdatmod`='202411061857',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '121') AND (id_type = '165') LIMIT 1
UID:1606--190019-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20241106','1606','1','manche@rainea.fr','Rainea','gerard.doussaud@orange.fr','gerard.doussaud@orange.fr','manche@rainea.fr','Nouvelle proposition de RAINEA : Devis N° DEV--9','\r\n\r\nNouveau Devis RAINEA\r\n\r\n\r\n\r\n\r\n \r\n \r\n\r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n | \r\n\r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n Proposition pour votre installation (Devis N° DEV--9)\r\n \r\n\r\n \r\n Bonjour Madame et Monsieur DOUSSAUD,
\r\n Comme convenu, vous trouverez en pièce jointe le devis correspondant à votre projet d\'osmoseur. 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.
Bien cordialement,
\r\n \r\n\r\n \r\n Votre équipe RAINEA - Rainéa 50\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/soft/v2017b/../../data/doc/1/19-17-896-1§Osmoseur NETOS.pdf;/mnt/big/prod/toosmart_rainea/soft/v2017b/../../data/doc/1/21-19-590-1§rib.pdf;/mnt/big/prod/toosmart_rainea/data/tmp/Devis_DEV--9.pdf§Devis_DEV--9.pdf','0','v2017b' )
UID:1606--190019-- UPDATE `email` SET `type`='',`bcc`='' WHERE 1=1 AND (id_email = '156') LIMIT 1
UID:1--234532-- UPDATE `my_user` SET `token`='d.-x@4cp9!xdapcis-q9' WHERE 1=1 AND (user_id = '1593') LIMIT 1
UID:1--234532-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20241106','-1','1','','','hanaa@toosmart.io','Kadioui Hanaa','','Renouvellement de votre mot de passe','\nNous avons reçu une demande de changement de mot de passe sur votre compte hanaa@toosmart.io
\nCliquez sur ce lien pour pouvoir le changer :
\n
Changer le mot de passe
\n
\nSi vous n\'avez pas demandé de renouvellement de mot de passe, vous pouvez supprimer ce mail.
\nVotre mot de passe ne sera pas changé tant que vous n\'aurez pas utiliser le lien ci dessus.\n
https://rainea.toosmart.app/index.php?f=MTMtaWQ6MTppZC0tbG9naW5wYWdlOkRfcmVzZXRwYXNzOmxvZ2lucGFnZS0tdG9rZW46ZC4teEA0Y3A5IXhkYXBjaXMtcTk6dG9rZW4tMTM=&logout=1','','0','v2017b' )
UID:1--234532-- UPDATE `email` SET `type`='',`bcc`='' WHERE 1=1 AND (id_email = '157') LIMIT 1
UID:1--234651--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0
UID:1--234658--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0
UID:1--234701-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','152','180','1','118','202411062347','202411062347' )
UID:1--234701-- UPDATE `tier_lig` SET `actif`='1',`ligdatmod`='202411062347',`ligusermod`='1' WHERE 1=1 AND ( id_tier = '118') AND ( id_type = '152') AND ( id_tlig = '180') AND ( id_lig = '153') LIMIT 1
UID:1--234701--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0
UID:1--234755-- UPDATE `tier_lig` SET `lig1`='hanaa1test0611@toosmart.fr',`lig3`='Test 0611',`lig4`='Hanaa1',`lig2`='https://object-storage.toosmart.app/signaturerainea/saintmalo.png',`ligdatmod`='202411062347',`ligusermod`='1' WHERE 1=1 AND ( id_tier = '118') AND ( id_type = '152') AND ( id_tlig = '180') AND ( id_lig = '153') LIMIT 1
UID:1--234755--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0
UID:1--234755-- INSERT INTO `my_user` (`nom`,`prenom`,`langue`,`email`,`pass`,`actif` ) VALUES ('Test 0611','Hanaa1','FR','hanaa1test0611@toosmart.fr','45wh2xjks6sxxfrkz.d6','1' )
UID:1--234755-- UPDATE `my_user` SET `pass`='$2y$05$IzUuoztJ80Tr0iq4zHWmjeClRfCyNgXSmudjmfH81N1O5kegvBq2G',`hash`='f1b64d8164c07ca170cc0bb92c83192e',`pass_has_to_change`='0' WHERE 1=1 AND (user_id = '1612') LIMIT 1
UID:1--234755-- UPDATE `my_user` SET `token`='#z!as38h3#x3j!xf8a$8' WHERE 1=1 AND (user_id = '1612') LIMIT 1
UID:1--234755-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20241106','-1','1','','','hanaa1test0611@toosmart.fr','Hanaa1 Test 0611','','Création de votre compte','\r\n\r\nCréation de votre compte Rainea\r\n\r\n\r\n \r\n \r\n\r\n \r\n \r\n\r\n\r\n\r\n \r\n \r\n\r\n \r\n \r\n | \r\n\r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n Création de votre compte Rainea\r\n Bienvenue chez Rainea,
votre login est : hanaa1test0611@toosmart.fr .
\r\n\r\n \r\n\r\n \r\n Cliquez sur ce lien pour définir votre mot de passe : \r\n \r\n\r\n \r\n \r\n \r\n | \r\n \r\n | \r\n \r\n \r\n \r\n | \r\n \r\n \r\n\r\n \r\n \r\n\r\n | \r\n
\r\n
\r\n','','0','v2017b' )
UID:1--234755-- UPDATE `email` SET `type`='raw',`bcc`='' WHERE 1=1 AND (id_email = '158') LIMIT 1
UID:1--234755-- INSERT INTO `param_group_user` (`id_base`,`id_user`,`id_group`,`type` ) VALUES ('1','1612','78','1' )
UID:1--234755-- INSERT INTO `param_group_user` (`id_base`,`id_user`,`id_group`,`type` ) VALUES ('1','1612','45','1' )
UID:1--234755-- UPDATE `tier_lig` SET `lig1`='1612',`lig3`='Test 0611',`lig4`='Hanaa1',`lig2`='https://object-storage.toosmart.app/signaturerainea/saintmalo.png',`ligdatmod`='202411062347',`ligusermod`='1' WHERE 1=1 AND ( id_tier = '118') AND ( id_type = '152') AND ( id_tlig = '180') AND ( id_lig = '153') LIMIT 1
UID:1--235306-- UPDATE `my_user` SET `token`='i5wywx2m@0v@!n-nr!2n' WHERE 1=1 AND (user_id = '1612') LIMIT 1
UID:1--235306-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20241106','-1','1','','','hanaa1test0611@toosmart.fr','Hanaa1 Test 0611','','Renouvellement de votre mot de passe','\nNous avons reçu une demande de changement de mot de passe sur votre compte hanaa1test0611@toosmart.fr
\nCliquez sur ce lien pour pouvoir le changer :
\n
Changer le mot de passe
\n
\nSi vous n\'avez pas demandé de renouvellement de mot de passe, vous pouvez supprimer ce mail.
\nVotre mot de passe ne sera pas changé tant que vous n\'aurez pas utiliser le lien ci dessus.\n
https://rainea.toosmart.app/index.php?f=MTItaWQ6MTppZC0tbG9naW5wYWdlOkRfcmVzZXRwYXNzOmxvZ2lucGFnZS0tdG9rZW46aTV3eXd4Mm1AMHZAIW4tbnIhMm46dG9rZW4tMTI=&logout=1','','0','v2017b' )
UID:1--235306-- UPDATE `email` SET `type`='',`bcc`='' WHERE 1=1 AND (id_email = '159') LIMIT 1
UID:1612--235826-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','205','1','202411062358' )
UID:1612--235826-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1612',`att18`='France',`attf102`='20241106',`attf103`='1',`attf104`='1',`attf105`='20241106',`attdatmod`='202411062358',`attusermod`='1612',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '266') AND (id_type = '80') LIMIT 1
UID:1612--235826-- UPDATE `tier_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '80') AND (id_tier = '266') LIMIT 1
UID:1612--235826-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1612',`att18`='France',`attf102`='20241106',`attf103`='1',`attf104`='1',`attf105`='20241106',`att22`='CLI-19',`attdatmod`='202411062358',`attusermod`='1612',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '266') AND (id_type = '80') LIMIT 1
UID:1612--235826-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1612',`att18`='France',`attf102`='20241106',`attf103`='1',`attf104`='1',`attf105`='20241106',`att22`='CLI-19',`att16`='Test 0611',`attdatmod`='202411062358',`attusermod`='1612',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '266') AND (id_type = '80') LIMIT 1