SELECT puf_tbu_cartelle_lingue.traduzione AS TRAD_CARTELLA, * FROM puf_tbu_cartelle
INNER JOIN puf_tba_tipi_file ON puf_tba_tipi_file.id = puf_tbu_cartelle.id_tipi_file
INNER JOIN puf_tbu_file ON puf_tbu_file.id_cartelle = puf_tbu_cartelle.id
INNER JOIN puf_tbu_cartelle_lingue on puf_tbu_cartelle_lingue.id_cartelle = puf_tbu_cartelle.id
WHERE codice = 'FAC0CB053'
AND puf_tbu_cartelle_lingue.id_lingue = '2'
AND puf_tbu_file.id_lingue_2 = '1000'
AND puf_tbu_file.id_lingue_1 = '2'
AND puf_tbu_file.obsoleto = '0'
SELECT puf_tbu_cartelle_lingue.traduzione AS TRAD_CARTELLA, * FROM puf_tbu_cartelle
INNER JOIN puf_tba_tipi_file ON puf_tba_tipi_file.id = puf_tbu_cartelle.id_tipi_file
INNER JOIN puf_tbu_file ON puf_tbu_file.id_cartelle = puf_tbu_cartelle.id
INNER JOIN puf_tbu_cartelle_lingue on puf_tbu_cartelle_lingue.id_cartelle = puf_tbu_cartelle.id
WHERE codice = 'FAC0CB062'
AND puf_tbu_cartelle_lingue.id_lingue = '2'
AND puf_tbu_file.id_lingue_2 = '1000'
AND puf_tbu_file.id_lingue_1 = '2'
AND puf_tbu_file.obsoleto = '0'
SELECT puf_tbu_cartelle_lingue.traduzione AS TRAD_CARTELLA, * FROM puf_tbu_cartelle
INNER JOIN puf_tba_tipi_file ON puf_tba_tipi_file.id = puf_tbu_cartelle.id_tipi_file
INNER JOIN puf_tbu_file ON puf_tbu_file.id_cartelle = puf_tbu_cartelle.id
INNER JOIN puf_tbu_cartelle_lingue on puf_tbu_cartelle_lingue.id_cartelle = puf_tbu_cartelle.id
WHERE codice = 'FAG0CB025'
AND puf_tbu_cartelle_lingue.id_lingue = '2'
AND puf_tbu_file.id_lingue_2 = '1000'
AND puf_tbu_file.id_lingue_1 = '2'
AND puf_tbu_file.obsoleto = '0'
SELECT puf_tbu_cartelle_lingue.traduzione AS TRAD_CARTELLA, * FROM puf_tbu_cartelle
INNER JOIN puf_tba_tipi_file ON puf_tba_tipi_file.id = puf_tbu_cartelle.id_tipi_file
INNER JOIN puf_tbu_file ON puf_tbu_file.id_cartelle = puf_tbu_cartelle.id
INNER JOIN puf_tbu_cartelle_lingue on puf_tbu_cartelle_lingue.id_cartelle = puf_tbu_cartelle.id
WHERE codice = 'FEC0CB000'
AND (puf_tbu_cartelle_lingue.id_lingue = '2' OR puf_tbu_cartelle_lingue.id_lingue = '1')
AND puf_tbu_file.id_lingue_2 = '1000'
AND puf_tbu_file.id_lingue_1 = '2'
AND puf_tbu_file.obsoleto = '0'
Controlled mechanical ventilation unit with a high-efficiency heat recovery system, designed for ceiling or wall installation. Manufactured from PPE and steel, with constant-flow EC fans. Available in two versions: with a standard heat recovery system or an enthalpy heat recovery system (model ERV).
ISO Coarse 65% (G4) filters fitted as standard; a condensate trap at the outlet is mandatory (SF-M or SF-P).
Controlled mechanical ventilation unit with a high-efficiency heat recovery system, designed for ceiling or wall installation. Manufactured from PPE and steel, with constant-flow EC fans. Available in two versions: with a standard heat recovery system or an enthalpy heat recovery system (model ERV).
ISO Coarse 65% (G4) filters fitted as standard; a condensate trap at the outlet is mandatory (SF-M or SF-P).
