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 = 'FAB0HB014'
AND puf_tbu_cartelle_lingue.id_lingue = '2'
AND puf_tbu_file.id_lingue_2 = '999'
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 = 'FAC0HB031'
AND puf_tbu_cartelle_lingue.id_lingue = '2'
AND puf_tbu_file.id_lingue_2 = '2'
AND puf_tbu_file.id_lingue_1 = '1'
AND puf_tbu_file.obsoleto = '0'
ABS plastic diffuser with smooth white RAL 9010 paintable finish. Grille to match the PLA room vents.
Quick fastening by pressure. Can be used in both supply and return air.
ABS plastic diffuser with smooth white RAL 9010 paintable finish. Grille to match the PLA room vents.
Quick fastening by pressure. Can be used in both supply and return air.
