UID:1606--073141-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','205','1','202411220731' ) UID:1606--073141-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1606',`att18`='France',`attf102`='20241122',`attf103`='1',`attf104`='1',`attf105`='20241122',`attdatmod`='202411220731',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '289') AND (id_type = '80') LIMIT 1 UID:1606--073141-- UPDATE `tier_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '80') AND (id_tier = '289') LIMIT 1 UID:1606--073142-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1606',`att18`='France',`attf102`='20241122',`attf103`='1',`attf104`='1',`attf105`='20241122',`att22`='CLI--11',`attdatmod`='202411220731',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '289') AND (id_type = '80') LIMIT 1 UID:1606--073142-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1606',`att18`='France',`attf102`='20241122',`attf103`='1',`attf104`='1',`attf105`='20241122',`att22`='CLI--11',`att16`='Neudin',`attdatmod`='202411220731',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '289') AND (id_type = '80') LIMIT 1 UID:1606--073328-- UPDATE `tier_att` SET `att3`='Christine',`att90`='',`att1`='LE PRIEUR',`att10`='madame',`att12`='avocat.le.prieur@wanadoo.fr',`att14`='11 Rue Affichard',`att15`='',`att7`='50300',`att17`='Avranches',`att6`='0661162790',`att5`='',`att11`='prospection_perso',`attdatmod`='202411220733',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '289') AND (id_type = '80') LIMIT 1 UID:1606--073328-- UPDATE `tier_att` SET `att3`='Christine',`att90`='',`att1`='LE PRIEUR',`att10`='madame',`att12`='avocat.le.prieur@wanadoo.fr',`att14`='11 Rue Affichard',`att15`='',`att7`='50300',`att17`='Avranches',`att6`='0661162790',`att5`='',`att11`='prospection_perso',`att19`='48.683253',`att20`='-1.356232',`attdatmod`='202411220733',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '289') AND (id_type = '80') LIMIT 1 UID:1606--073328-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','289','202411220733','202411220733' ) UID:1606--073328-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='11 Rue Affichard',`lig3`='',`lig4`='50300',`lig5`='Avranches',`lig6`='France',`ligdatmod`='202411220733',`ligusermod`='1606' WHERE 1=1 AND ( id_tier = '289') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '165') LIMIT 1 UID:1606--073328-- UPDATE `tier_att` SET `att3`='Christine',`att90`='',`att1`='LE PRIEUR',`att10`='madame',`att12`='avocat.le.prieur@wanadoo.fr',`att14`='11 Rue Affichard',`att15`='',`att7`='50300',`att17`='Avranches',`att6`='0661162790',`att5`='',`att11`='prospection_perso',`att19`='48.683253',`att20`='-1.356232',`attf100`='1',`attdatmod`='202411220733',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '289') AND (id_type = '80') LIMIT 1 UID:1606--073332-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','289','202411220733','202411220733' ) UID:1606--073332-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`ligdatmod`='202411220733',`ligusermod`='1606' WHERE 1=1 AND ( id_tier = '289') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '166') LIMIT 1 UID:1606--073423-- UPDATE `tier_lig` SET `lig2`='9 Chemin du Rivage',`lig3`='',`lig4`='50300',`lig5`='Vains',`lig6`='',`ligdatmod`='202411220734',`ligusermod`='1606' WHERE 1=1 AND ( id_tier = '289') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '166') LIMIT 1 UID:1606--073720-- UPDATE `tier_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '80') AND (id_tier = '289') LIMIT 1 UID:1606--073720-- UPDATE `tier_att` SET `att90`='<p>Résidence secondaire (2 petites maisons appartenant à ses parents).</p><p>Dégât des eaux en 2015. Est en train (doucement) de rénover.</p><p>Les maisons ne sont pas habitables en l\'état.</p><p>Au total :5 pp  / 4 ch</p><p>Visite du SPANC: Fosse non trouvée donc Mise en demeure de réaliser les travaux.</p><p>Possibilité de subvention de l\'AESN</p><p>Etude de sol et de filière commandée à M. Poisson</p>',`attdatmod`='202411220737',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '289') AND (id_type = '80') LIMIT 1 UID:1606--073720-- UPDATE `tier_lig` SET `lig2`='11',`ligdatmod`='202411220737',`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--073720-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202411220737' ) UID:1606--073720-- UPDATE `tier_att` SET `att2`='LE PRIEUR',`att3`='Christine',`att4`='',`att5`='0661162790',`att6`='avocat.le.prieur@wanadoo.fr',`att7`='madame',`att8`='289',`att10`='1606',`attdatmod`='202411220737',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '290') AND (id_type = '149') LIMIT 1 UID:1606--073720-- UPDATE `tier_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '149') AND (id_tier = '290') LIMIT 1 UID:1606--073722-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202411220737' ) UID:1606--073722-- UPDATE `vent_att` SET `att1`='OPP-',`att2`='289',`attf100`='20241122',`att6`='1606',`attdatmod`='202411220737',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '154') AND (id_type = '148') LIMIT 1 UID:1606--073722-- UPDATE `vent_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '148') AND (id_vent = '154') LIMIT 1 UID:1606--073722-- UPDATE `vent_att` SET `att1`='OPP-LE PRIEUR',`att2`='289',`attf100`='20241122',`att6`='1606',`attdatmod`='202411220737',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '154') AND (id_type = '148') LIMIT 1 UID:1606--073722-- UPDATE `vent_att` SET `att1`='OPP-LE PRIEUR',`att2`='289',`attf100`='20241122',`att6`='1606',`att5`='',`att10`='particulier',`attdatmod`='202411220737',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '154') AND (id_type = '148') LIMIT 1 UID:1606--073802-- UPDATE `vent_att` SET `att8`='166',`att9`='290',`attf102`='202410231000',`att3`='',`attdatmod`='202411220738',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '154') AND (id_type = '148') LIMIT 1 UID:1606--073802-- UPDATE `vent_att` SET `att8`='166',`att9`='290',`attf102`='202410231000',`att3`='',`id_work`='374',`attdatmod`='202411220738',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '154') AND (id_type = '148') LIMIT 1 UID:1606--073918-- UPDATE `vent_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '148') AND (id_vent = '154') LIMIT 1 UID:1606--073918-- UPDATE `vent_att` SET `att90`='<p>Présent lors de la visite du SPANC.</p><p>Aucune fosse trouvée sur le terrain (petit). </p><p>Présence d\'un puits.</p><p>Etude commandée à M. Poisson : En attente</p><p>Ai préconisé une Ecoflo béton</p>',`attdatmod`='202411220739',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '154') AND (id_type = '148') LIMIT 1 UID:1606--074009-- UPDATE `tier_att` SET `att90`='<p>Résidence secondaire (2 petites maisons appartenant à ses parents).</p><p>Dégât des eaux en 2015. Est en train (doucement) de rénover.</p><p>Les maisons ne sont pas habitables en l\'état.</p><p>Au total :5 pp  / 4 ch</p><p>Visite du SPANC: Fosse non trouvée donc Mise en demeure de réaliser les travaux.</p><p>Possibilité de subvention de l\'AESN</p><p>Etude de sol et de filière commandée à M. Poisson</p>',`att5`='0233602589',`attdatmod`='202411220740',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '289') AND (id_type = '80') LIMIT 1 UID:1606--074047-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','165','410','1','202411220740' ) UID:1606--074047-- UPDATE `vent_att` SET `att1`='154',`attf100`='20241122',`attf101`='1',`att11`='1606',`attf105`='20241122',`att43`='Remise TTC',`attdatmod`='202411220740',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '155') AND (id_type = '165') LIMIT 1 UID:1606--074047-- UPDATE `vent_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '165') AND (id_vent = '155') LIMIT 1 UID:1606--074047-- UPDATE `vent_att` SET `att1`='154',`attf100`='20241122',`attf101`='1',`att11`='1606',`attf105`='20241122',`att43`='Remise TTC',`att2`='289',`attdatmod`='202411220740',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '155') AND (id_type = '165') LIMIT 1 UID:1606--074047-- UPDATE `vent_att` SET `att1`='154',`attf100`='20241122',`attf101`='1',`att11`='1606',`attf105`='20241222',`att43`='Remise TTC',`att2`='289',`attdatmod`='202411220740',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '155') AND (id_type = '165') LIMIT 1 UID:1606--074047-- UPDATE `vent_att` SET `att1`='154',`attf100`='20241122',`attf101`='1',`att11`='1606',`attf105`='20241222',`att43`='Remise TTC',`att2`='289',`att13`='0rxx24utngn0-s-0',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/0rxx24utngn0-s-0',`attdatmod`='202411220740',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '155') AND (id_type = '165') LIMIT 1 UID:1606--074047-- UPDATE `vent_att` SET `att1`='154',`attf100`='20241122',`attf101`='1',`att11`='1606',`attf105`='20241222',`att43`='Remise TTC',`att2`='289',`att13`='0rxx24utngn0-s-0',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/0rxx24utngn0-s-0',`att4`='DEV--11',`attdatmod`='202411220740',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '155') AND (id_type = '165') LIMIT 1 UID:1606--074047-- UPDATE `vent_att` SET `att1`='154',`attf100`='20241122',`attf101`='1',`att11`='1606',`attf105`='20241222',`att43`='Remise TTC',`att2`='289',`att13`='0rxx24utngn0-s-0',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/0rxx24utngn0-s-0',`att4`='DEV--11',`att18`='

Rainea Rainéa 50


330 Rue Valvire
50000 Saint-Lô



manche@rainea.fr


www.rainea.fr',`att19`=' 9 Chemin du Rivage 50300 Vains',`att20`=' 11 Rue Affichard 50300 Avranches',`att22`='

Rainea Rainéa 50


SAS au captial de 5000€ - SIREN 933465817 - RCS : Coutances\n
TVA : FR91933465817
IBAN : - BIC : ',`att31`='11 Rue Affichard',`att33`='50300',`att34`='Avranches',`att35`='France',`att38`='9 Chemin du Rivage',`att40`='50300',`att41`='Vains',`att42`='',`attdatmod`='202411220740',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '155') AND (id_type = '165') LIMIT 1 UID:1606--074103-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','155','202411220741','202411220741' ) UID:1606--074103-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411220741',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '155') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '293') LIMIT 1 UID:1606--074103-- UPDATE `vent_att` SET `att15`='virement',`att45`='30% à la commande, solde fin de chantier.',`att26`='',`attdatmod`='202411220741',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '155') AND (id_type = '165') LIMIT 1 UID:1606--074104-- 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`='202411220741',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '155') AND (id_type = '165') LIMIT 1 UID:1606--074342-- UPDATE `vent_lig` SET `lig10`='3421',`ligdatmod`='202411220743',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '155') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '293') LIMIT 1 UID:1606--074342-- UPDATE `vent_lig` SET `lig10`='3421',`lig6`='612.00',`lig13`='0.00',`lig16`='0',`lig17`='6120',`lig18`='612',`lig19`='4350.00',`lig2`='6120.00',`lig5`='10',`lig4`='6120.00',`lig7`='6732.00',`lig9`='',`lig14`='0',`lig15`='6732.00',`lig90`='<p><b>Fourniture et mise en service d\'une filière compacte ECOFLO BETON MONOLITHE 5EH sortie BASSE 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 ECOFLO.</p><p>- Un filtre compact 5EH 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.</p><p><br></p><p>- Fabrication Française disposant d\'un agrément Ministériel n° 2023-002-ext01 et conforme à la Norme NF-EN 12566-3+A1 et à l\'arrêté du 7 septembre 2009.</p>',`ligdatmod`='202411220743',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '155') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '293') LIMIT 1 UID:1606--074342-- UPDATE `vent_att` SET `att7`='6120',`att8`='612',`att21`='6732',`att9`='6732',`att27`='0',`att29`='0',`att28`='6120',`att30`='612',`attdatmod`='202411220743',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '155') AND (id_type = '165') LIMIT 1 UID:1606--074406-- UPDATE `vent_lig` SET `lig10`='',`ligdatmod`='202411220744',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '155') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '293') LIMIT 1 UID:1606--074406-- 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`='202411220744',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '155') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '293') LIMIT 1 UID:1606--074407-- UPDATE `vent_att` SET `att7`='0',`att8`='0',`att21`='0',`att9`='0',`att27`='0',`att29`='0',`att28`='0',`att30`='0',`attdatmod`='202411220744',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '155') AND (id_type = '165') LIMIT 1 UID:1606--074428-- UPDATE `vent_lig` SET `lig10`='3399',`ligdatmod`='202411220744',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '155') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '293') LIMIT 1 UID:1606--074428-- UPDATE `vent_lig` SET `lig10`='3399',`lig17`='6470',`lig19`='4700.00',`lig2`='6470.00',`lig4`='6470.00',`lig7`='6470.00',`lig15`='6470.00',`lig90`='<p><b>Fourniture et mise en service d\'une filière compacte ECOFLO BETON MONOLITHE 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 ECOLO.</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><br></p><p>- Fabrication Française disposant d\'un agrément Ministériel n° 2023-002-ext01 et conforme à la Norme NF-EN 12566-3+A1 et à l\'arrêté du 7 septembre 2009.</p>',`ligdatmod`='202411220744',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '155') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '293') LIMIT 1 UID:1606--074429-- UPDATE `vent_att` SET `att7`='6470',`att8`='0',`att21`='6470',`att9`='6470',`att27`='0',`att29`='0',`att28`='6470',`att30`='0',`attdatmod`='202411220744',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '155') AND (id_type = '165') LIMIT 1 UID:1606--074441-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','155','202411220744','202411220744' ) UID:1606--074441-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411220744',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '155') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '294') LIMIT 1 UID:1606--074441-- UPDATE `vent_att` SET `att8`='0',`att27`='0',`att29`='0',`att30`='0',`attdatmod`='202411220744',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '155') AND (id_type = '165') LIMIT 1 UID:1606--074452-- UPDATE `vent_lig` SET `lig10`='2242',`ligdatmod`='202411220744',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '155') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '294') LIMIT 1 UID:1606--074452-- UPDATE `vent_lig` SET `lig10`='2242',`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`='202411220744',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '155') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '294') LIMIT 1 UID:1606--074453-- UPDATE `vent_att` SET `att7`='9920',`att8`='345',`att21`='10265',`att9`='10265',`att27`='0',`att29`='0',`att28`='9920',`att30`='345',`attdatmod`='202411220744',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '155') AND (id_type = '165') LIMIT 1 UID:1606--074455-- UPDATE `vent_lig` SET `lig10`='',`ligdatmod`='202411220744',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '155') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '294') LIMIT 1 UID:1606--074455-- 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`='202411220744',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '155') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '294') LIMIT 1 UID:1606--074455-- UPDATE `vent_att` SET `att7`='6470',`att8`='0',`att21`='6470',`att9`='6470',`att27`='0',`att29`='0',`att28`='6470',`att30`='0',`attdatmod`='202411220744',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '155') AND (id_type = '165') LIMIT 1 UID:1606--074506-- UPDATE `vent_lig` SET `lig10`='2288',`ligdatmod`='202411220745',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '155') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '294') LIMIT 1 UID:1606--074506-- UPDATE `vent_lig` SET `lig10`='2288',`lig6`='345.00',`lig17`='3450',`lig18`='345',`lig2`='3450.00',`lig5`='10',`lig4`='3450.00',`lig7`='3795.00',`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`='202411220745',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '155') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '294') LIMIT 1 UID:1606--074506-- UPDATE `vent_att` SET `att7`='9920',`att8`='345',`att21`='10265',`att9`='10265',`att27`='0',`att29`='0',`att28`='9920',`att30`='345',`attdatmod`='202411220745',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '155') AND (id_type = '165') LIMIT 1 UID:1606--074530-- UPDATE `vent_lig` SET `lig2`='4450.00',`ligdatmod`='202411220745',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '155') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '294') LIMIT 1 UID:1606--074530-- UPDATE `vent_lig` SET `lig2`='4450.00',`lig6`='445.00',`lig17`='4450',`lig18`='445',`lig4`='4450.00',`lig7`='4895.00',`lig15`='4895.00',`ligdatmod`='202411220745',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '155') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '294') LIMIT 1 UID:1606--074530-- UPDATE `vent_att` SET `att7`='10920',`att8`='445',`att21`='11365',`att9`='11365',`att27`='0',`att29`='0',`att28`='10920',`att30`='445',`attdatmod`='202411220745',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '155') AND (id_type = '165') LIMIT 1 UID:1606--074711-- UPDATE `vent_att` SET `att91`='<p>Etude de sol et de filière obligatoire afin de valider le système.</p>',`attdatmod`='202411220747',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '155') AND (id_type = '165') LIMIT 1 UID:1606--074711-- UPDATE `vent_lig` SET `lig2`='4750.00',`ligdatmod`='202411220747',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '155') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '294') LIMIT 1 UID:1606--074711-- UPDATE `vent_lig` SET `lig2`='4750.00',`lig6`='475.00',`lig17`='4750',`lig18`='475',`lig4`='4750.00',`lig7`='5225.00',`lig15`='5225.00',`ligdatmod`='202411220747',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '155') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '294') LIMIT 1 UID:1606--074711-- UPDATE `vent_att` SET `att91`='<p>Etude de sol et de filière obligatoire afin de valider le système.</p>',`att7`='11220',`att8`='475',`att21`='11695',`att9`='11695',`att27`='0',`att29`='0',`att28`='11220',`att30`='475',`attdatmod`='202411220747',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '155') AND (id_type = '165') LIMIT 1 UID:1606--074733-- UPDATE `vent_lig` SET `lig2`='4950.00',`ligdatmod`='202411220747',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '155') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '294') LIMIT 1 UID:1606--074733-- UPDATE `vent_lig` SET `lig2`='4950.00',`lig6`='495.00',`lig17`='4950',`lig18`='495',`lig4`='4950.00',`lig7`='5445.00',`lig15`='5445.00',`ligdatmod`='202411220747',`ligusermod`='1606' WHERE 1=1 AND ( id_vent = '155') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '294') LIMIT 1 UID:1606--074733-- UPDATE `vent_att` SET `att7`='11420',`att8`='495',`att21`='11915',`att9`='11915',`att27`='0',`att29`='0',`att28`='11420',`att30`='495',`attdatmod`='202411220747',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '155') AND (id_type = '165') LIMIT 1 UID:1606--075127-- UPDATE `vent_att` SET `att91`='<p>Etude de sol et de filière obligatoire afin de valider le système.</p><p>Les 2 maisons à la demande de la cliente seront reliées au même assainissement.</p><p>Mise aux normes des réseaux de plomberie, évacuations comprises, dans les 2 maisons sont à prévoir par la cliente.</p>',`attdatmod`='202411220751',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '155') AND (id_type = '165') LIMIT 1 UID:1606--075142-- UPDATE `vent_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '165') AND (id_vent = '155') LIMIT 1 UID:1606--075142-- UPDATE `tier_lig` SET `lig2`='11',`ligdatmod`='202411220751',`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--075142-- UPDATE `vent_att` SET `att24`='

Rainéa 50

330 Rue Valvire

50000 Saint-Lô

0763868140

manche@rainea.fr

www.rainea.fr

',`attdatmod`='202411220751',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '155') AND (id_type = '165') LIMIT 1 UID:1606--075142-- UPDATE `vent_att` SET `id_work`='375',`attdatmod`='202411220751',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '154') AND (id_type = '148') LIMIT 1 UID:1606--075254-- UPDATE `vent_att` SET `att94`='<p>Etude de sol et de filière obligatoire afin de valider le système.\r\n</p><p>Les 2 maisons à la demande de la cliente seront reliées au même assainissement.\r\n</p><p>Mise aux normes des réseaux de plomberie, évacuations comprises, dans les 2 maisons sont à prévoir par la cliente.</p><p>\r\n</p><p>\r\n</p>',`attdatmod`='202411220752',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '155') AND (id_type = '165') LIMIT 1 UID:1606--075344-- UPDATE `vent_att` SET `att94`='<p>Etude de sol et de filière obligatoire afin de valider le système.\r\n</p><p>Les 2 maisons à la demande de la cliente seront reliées au même assainissement.\r\n</p><p>La mise aux normes des réseaux de plomberie, évacuations comprises, dans les 2 maisons est à prévoir par la cliente.</p><p>\r\n</p><p>\r\n</p>',`attdatmod`='202411220753',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '155') AND (id_type = '165') LIMIT 1 UID:1606--080418-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','205','1','202411220804' ) UID:1606--080418-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1606',`att18`='France',`attf102`='20241122',`attf103`='1',`attf104`='1',`attf105`='20241122',`attdatmod`='202411220804',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '291') AND (id_type = '80') LIMIT 1 UID:1606--080418-- UPDATE `tier_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '80') AND (id_tier = '291') LIMIT 1 UID:1606--080418-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1606',`att18`='France',`attf102`='20241122',`attf103`='1',`attf104`='1',`attf105`='20241122',`att22`='CLI--12',`attdatmod`='202411220804',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '291') AND (id_type = '80') LIMIT 1 UID:1606--080418-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1606',`att18`='France',`attf102`='20241122',`attf103`='1',`attf104`='1',`attf105`='20241122',`att22`='CLI--12',`att16`='Neudin',`attdatmod`='202411220804',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '291') AND (id_type = '80') LIMIT 1 UID:1606--081340-- UPDATE `tier_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '80') AND (id_tier = '291') LIMIT 1 UID:1606--081340-- UPDATE `tier_att` SET `att3`='Serge',`att90`='<p>Fosse septique et épandage ne sont plus aux normes.</p><p>Visite sur place le 15 octobre 2024.</p><p>Commande d\'étude de sol et de filière commandée à Amélie Careau : En attente de date de rdv (pour être présent)</p>',`att1`='DESVAUX',`att10`='madame_monsieur',`att12`='msm.desvaux@gmail.com',`att14`='14 Route de Butte Rouge',`att15`='',`att7`='50140',`att17`='Romagny-Fontenay',`att6`='0670687124',`att5`='',`att11`='salon',`attdatmod`='202411220813',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '291') AND (id_type = '80') LIMIT 1 UID:1606--081340-- UPDATE `tier_att` SET `att3`='Serge',`att90`='<p>Fosse septique et épandage ne sont plus aux normes.</p><p>Visite sur place le 15 octobre 2024.</p><p>Commande d\'étude de sol et de filière commandée à Amélie Careau : En attente de date de rdv (pour être présent)</p>',`att1`='DESVAUX',`att10`='madame_monsieur',`att12`='msm.desvaux@gmail.com',`att14`='14 Route de Butte Rouge',`att15`='',`att7`='50140',`att17`='Romagny-Fontenay',`att6`='0670687124',`att5`='',`att11`='salon',`att19`='48.647827',`att20`='-0.961604',`attdatmod`='202411220813',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '291') AND (id_type = '80') LIMIT 1 UID:1606--081340-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','291','202411220813','202411220813' ) UID:1606--081340-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='14 Route de Butte Rouge',`lig3`='',`lig4`='50140',`lig5`='Romagny-Fontenay',`lig6`='France',`ligdatmod`='202411220813',`ligusermod`='1606' WHERE 1=1 AND ( id_tier = '291') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '167') LIMIT 1 UID:1606--081340-- UPDATE `tier_att` SET `att3`='Serge',`att90`='<p>Fosse septique et épandage ne sont plus aux normes.</p><p>Visite sur place le 15 octobre 2024.</p><p>Commande d\'étude de sol et de filière commandée à Amélie Careau : En attente de date de rdv (pour être présent)</p>',`att1`='DESVAUX',`att10`='madame_monsieur',`att12`='msm.desvaux@gmail.com',`att14`='14 Route de Butte Rouge',`att15`='',`att7`='50140',`att17`='Romagny-Fontenay',`att6`='0670687124',`att5`='',`att11`='salon',`att19`='48.647827',`att20`='-0.961604',`attf100`='1',`attdatmod`='202411220813',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '291') AND (id_type = '80') LIMIT 1 UID:1606--081340-- UPDATE `tier_lig` SET `lig2`='12',`ligdatmod`='202411220813',`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--081340-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202411220813' ) UID:1606--081340-- UPDATE `tier_att` SET `att2`='DESVAUX',`att3`='Serge',`att4`='',`att5`='0670687124',`att6`='msm.desvaux@gmail.com',`att7`='madame_monsieur',`att8`='291',`att10`='1606',`attdatmod`='202411220813',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '292') AND (id_type = '149') LIMIT 1 UID:1606--081340-- UPDATE `tier_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '149') AND (id_tier = '292') LIMIT 1 UID:1606--081342-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202411220813' ) UID:1606--081342-- UPDATE `vent_att` SET `att1`='OPP-',`att2`='291',`attf100`='20241122',`att6`='1606',`attdatmod`='202411220813',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '156') AND (id_type = '148') LIMIT 1 UID:1606--081342-- UPDATE `vent_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '148') AND (id_vent = '156') LIMIT 1 UID:1606--081342-- UPDATE `vent_att` SET `att1`='OPP-DESVAUX',`att2`='291',`attf100`='20241122',`att6`='1606',`attdatmod`='202411220813',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '156') AND (id_type = '148') LIMIT 1 UID:1606--081342-- UPDATE `vent_att` SET `att1`='OPP-DESVAUX',`att2`='291',`attf100`='20241122',`att6`='1606',`att5`='',`att10`='particulier',`attdatmod`='202411220813',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '156') AND (id_type = '148') LIMIT 1 UID:1606--081424-- UPDATE `vent_att` SET `att8`='167',`att9`='292',`attf102`='202410151430',`att3`='assainissement',`attdatmod`='202411220814',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '156') AND (id_type = '148') LIMIT 1 UID:1606--081424-- UPDATE `vent_att` SET `att8`='167',`att9`='292',`attf102`='202410151430',`att3`='assainissement',`id_work`='374',`attdatmod`='202411220814',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '156') AND (id_type = '148') LIMIT 1 UID:1606--081542-- UPDATE `vent_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '148') AND (id_vent = '156') LIMIT 1 UID:1606--081542-- UPDATE `vent_att` SET `att90`='<p>Fosse et épandage ne sont plus aux normes</p>',`attdatmod`='202411220815',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '156') AND (id_type = '148') LIMIT 1 UID:1606--081612-- UPDATE `tier_att` SET `att5`='0233593546',`attdatmod`='202411220816',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '291') AND (id_type = '80') LIMIT 1 UID:1606--142924-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','205','1','202411221429' ) UID:1606--142924-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1606',`att18`='France',`attf102`='20241122',`attf103`='1',`attf104`='1',`attf105`='20241122',`attdatmod`='202411221429',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '293') AND (id_type = '80') LIMIT 1 UID:1606--142924-- UPDATE `tier_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '80') AND (id_tier = '293') LIMIT 1 UID:1606--142924-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1606',`att18`='France',`attf102`='20241122',`attf103`='1',`attf104`='1',`attf105`='20241122',`att22`='CLI--13',`attdatmod`='202411221429',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '293') AND (id_type = '80') LIMIT 1 UID:1606--142924-- UPDATE `tier_att` SET `id_work`='259',`att8`='particulier',`att21`='1606',`att18`='France',`attf102`='20241122',`attf103`='1',`attf104`='1',`attf105`='20241122',`att22`='CLI--13',`att16`='Neudin',`attdatmod`='202411221429',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '293') AND (id_type = '80') LIMIT 1 UID:1606--142929-- UPDATE `tier_att` SET `att3`='',`att90`='',`att1`='',`att8`='professionnel',`att10`='',`att12`='',`att14`='',`att15`='',`att7`='',`att17`='',`att6`='',`att5`='',`att11`='',`attdatmod`='202411221429',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '293') AND (id_type = '80') LIMIT 1 UID:1606--142929-- UPDATE `tier_att` SET `att3`='',`att90`='',`att1`='',`att8`='professionnel',`att10`='',`att12`='',`att14`='',`att15`='',`att7`='',`att17`='',`att6`='',`att5`='',`att11`='',`att19`='44.491091',`att20`='-0.193983',`attdatmod`='202411221429',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '293') AND (id_type = '80') LIMIT 1 UID:1--143606--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--143632--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--143658-- UPDATE `tier_att` SET `att18`='FR76 1380 7007 0333 7219 6886 242',`att19`='CCBPFRPPNAN',`attdatmod`='202411221436',`attusermod`='1',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '172') AND (id_type = '152') LIMIT 1 UID:1--143658--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:1606--144056-- UPDATE `tier_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '80') AND (id_tier = '293') LIMIT 1 UID:1606--144056-- UPDATE `tier_att` SET `att3`='Quentin',`att90`='<p>Contact entrant via Rainéa.fr</p><p>Doit se mettre en conformité (prévu lors de la reprise du restaurant) et installer un séparateur de graisse.</p><p>rdv sur place puis un 2ème rdv avec le TP (Eureska) pour pouvoir lui faire un devis.</p><p>Devis demandé à FB</p>',`att1`='SALVAN',`att9`='LA MARINA',`att10`='monsieur',`att12`='marinasaintvaast@gmail.com',`att14`='8 Quai Commandant Albert Paris',`att7`='50550',`att17`='Saint-Vaast-La-Hougue',`att6`='0698298456',`att5`='0233437562',`att11`='web',`att4`='FR17828873570',`attdatmod`='202411221440',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '293') AND (id_type = '80') LIMIT 1 UID:1606--144056-- UPDATE `tier_att` SET `att3`='Quentin',`att90`='<p>Contact entrant via Rainéa.fr</p><p>Doit se mettre en conformité (prévu lors de la reprise du restaurant) et installer un séparateur de graisse.</p><p>rdv sur place puis un 2ème rdv avec le TP (Eureska) pour pouvoir lui faire un devis.</p><p>Devis demandé à FB</p>',`att1`='SALVAN',`att9`='LA MARINA',`att10`='monsieur',`att12`='marinasaintvaast@gmail.com',`att14`='8 Quai Commandant Albert Paris',`att7`='50550',`att17`='Saint-Vaast-La-Hougue',`att6`='0698298456',`att5`='0233437562',`att11`='web',`att4`='FR17828873570',`att19`='49.589314',`att20`='-1.26364',`attdatmod`='202411221440',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '293') AND (id_type = '80') LIMIT 1 UID:1606--144056-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','293','202411221440','202411221440' ) UID:1606--144056-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='8 Quai Commandant Albert Paris',`lig3`='',`lig4`='50550',`lig5`='Saint-Vaast-La-Hougue',`lig6`='France',`ligdatmod`='202411221440',`ligusermod`='1606' WHERE 1=1 AND ( id_tier = '293') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '168') LIMIT 1 UID:1606--144056-- UPDATE `tier_att` SET `att3`='Quentin',`att90`='<p>Contact entrant via Rainéa.fr</p><p>Doit se mettre en conformité (prévu lors de la reprise du restaurant) et installer un séparateur de graisse.</p><p>rdv sur place puis un 2ème rdv avec le TP (Eureska) pour pouvoir lui faire un devis.</p><p>Devis demandé à FB</p>',`att1`='SALVAN',`att9`='LA MARINA',`att10`='monsieur',`att12`='marinasaintvaast@gmail.com',`att14`='8 Quai Commandant Albert Paris',`att7`='50550',`att17`='Saint-Vaast-La-Hougue',`att6`='0698298456',`att5`='0233437562',`att11`='web',`att4`='FR17828873570',`att19`='49.589314',`att20`='-1.26364',`attf100`='1',`attdatmod`='202411221440',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '293') AND (id_type = '80') LIMIT 1 UID:1606--144056-- UPDATE `tier_lig` SET `lig2`='13',`ligdatmod`='202411221440',`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--144056-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202411221440' ) UID:1606--144056-- UPDATE `tier_att` SET `att2`='SALVAN',`att3`='Quentin',`att4`='0233437562',`att5`='0698298456',`att6`='marinasaintvaast@gmail.com',`att7`='monsieur',`att8`='293',`att10`='1606',`attdatmod`='202411221440',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '294') AND (id_type = '149') LIMIT 1 UID:1606--144056-- UPDATE `tier_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '149') AND (id_tier = '294') LIMIT 1 UID:1606--144106-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202411221441' ) UID:1606--144106-- UPDATE `vent_att` SET `att1`='OPP-',`att2`='293',`attf100`='20241122',`att6`='1606',`attdatmod`='202411221441',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '157') AND (id_type = '148') LIMIT 1 UID:1606--144106-- UPDATE `vent_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '148') AND (id_vent = '157') LIMIT 1 UID:1606--144106-- UPDATE `vent_att` SET `att1`='OPP-SALVAN',`att2`='293',`attf100`='20241122',`att6`='1606',`attdatmod`='202411221441',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '157') AND (id_type = '148') LIMIT 1 UID:1606--144106-- UPDATE `vent_att` SET `att1`='OPP-SALVAN',`att2`='293',`attf100`='20241122',`att6`='1606',`att5`='LA MARINA',`att10`='professionnel',`attdatmod`='202411221441',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '157') AND (id_type = '148') LIMIT 1 UID:1606--144143-- UPDATE `vent_att` SET `att8`='168',`att9`='294',`attf102`='202411191100',`att3`='',`attdatmod`='202411221441',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '157') AND (id_type = '148') LIMIT 1 UID:1606--144143-- UPDATE `vent_att` SET `att8`='168',`att9`='294',`attf102`='202411191100',`att3`='',`id_work`='374',`attdatmod`='202411221441',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '157') AND (id_type = '148') LIMIT 1 UID:1606--144609-- UPDATE `vent_att` SET `newobj`='0' WHERE 1=1 AND (id_type = '148') AND (id_vent = '157') LIMIT 1 UID:1606--144609-- UPDATE `vent_att` SET `att90`='<p>Mise aux normes et engagement lors du rachat du restaurant.</p><p>Installation d\'un séparateur de graisse.</p><p>Envoi du tableau de dimensionnement du séparateur / nb de couverts/nb de services/jour pour choisir entre taille 03 ou taille 04 : Réponse du client  le 22/11/2024 Taille 03</p><p>Il m\'avait dit 350 couverts environ / jour, ce qui équivaudrait à une taille 04 (à partir de 312) mais comme il ne fait se nb de couverts que en saison, il préfère une taille 03 (raison financière)</p>',`att3`='assainissement',`attdatmod`='202411221446',`attusermod`='1606',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '157') AND (id_type = '148') LIMIT 1