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 = 'FAG0AB002'
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 = 'FDA0AB002'
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'
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 = 'FAC0AB006'
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'
Pre-assembled manifold Ø 1” made of stainless steel AISI 304, and used to distribute pipe into the rooms. It is equipped with on-off valves (suitable for electrothermic heads) on the return manifold, flow-meters with scale 0 to 5 L/m, digital flow and return thermometers with a liquid-crystal display, air vent valves and drain valves with hose nozzles and plugs, brackets with vibration-damping rubber tops, which can be installed into cabinet or onto the wall, and fittings for polybutylene pipe Ø 17 mm.
Pre-assembled manifold Ø 1” made of stainless steel AISI 304, and used to distribute pipe into the rooms. It is equipped with on-off valves (suitable for electrothermic heads) on the return manifold, flow-meters with scale 0 to 5 L/m, digital flow and return thermometers with a liquid-crystal display, air vent valves and drain valves with hose nozzles and plugs, brackets with vibration-damping rubber tops, which can be installed into cabinet or onto the wall, and fittings for polybutylene pipe Ø 17 mm.
