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 = 'FAB0HB013'
AND (puf_tbu_cartelle_lingue.id_lingue = '2' OR puf_tbu_cartelle_lingue.id_lingue = '1')
AND puf_tbu_file.id_lingue_2 = '2'
AND puf_tbu_file.id_lingue_1 = '1'
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 = 'FAC0HB020'
AND (puf_tbu_cartelle_lingue.id_lingue = '2' OR puf_tbu_cartelle_lingue.id_lingue = '1')
AND puf_tbu_file.id_lingue_2 = '2'
AND puf_tbu_file.id_lingue_1 = '1'
AND puf_tbu_file.obsoleto = '0'
Diffuser designed to ensure optimal air distribution. Suitable for both air supply and return, it is made of galvanized sheet metal with internal insulation and is equipped with an aluminum grille.
Features:
Ceiling or wall installation
Adjustable airflow rate
Maximum airflow: 150 m³/h
Optional filters: op to 3 filters
Possible Connections:
5 x Duo White 75/90 mm
3 x DN 100 mm
1 x DN 125 mm
Diffuser designed to ensure optimal air distribution. Suitable for both air supply and return, it is made of galvanized sheet metal with internal insulation and is equipped with an aluminum grille.
Features:
Ceiling or wall installation
Adjustable airflow rate
Maximum airflow: 150 m³/h
Optional filters: op to 3 filters
Possible Connections:
5 x Duo White 75/90 mm
3 x DN 100 mm
1 x DN 125 mm
