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 = 'FAC0HA003'
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'
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 = 'FAB0HA004'
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'
Insulated flexible duct made of polyolefin resin film with antibacterial and antimold additive. Equipped with spring steel wire spiral, thermal insulating layer in polyester fiber (thickness 25 mm, density 16 kg/m³) and external protection with aluminium film (flame retardant).
Insulated flexible duct made of polyolefin resin film with antibacterial and antimold additive. Equipped with spring steel wire spiral, thermal insulating layer in polyester fiber (thickness 25 mm, density 16 kg/m³) and external protection with aluminium film (flame retardant).
