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 = 'FAC0HC002'
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'
Circular room plenum in antistatic and antibacterial PP Ø 125 mm for air distribution systems. Designed for ceiling or wall installation, it is equipped with two spigots for flat ducting (102x50 mm) with suitable ring. It is supplied as standard with dust cover on the valve connection (DN 125 mm) and removable cap.
Circular room plenum in antistatic and antibacterial PP Ø 125 mm for air distribution systems. Designed for ceiling or wall installation, it is equipped with two spigots for flat ducting (102x50 mm) with suitable ring. It is supplied as standard with dust cover on the valve connection (DN 125 mm) and removable cap.
