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 = 'FDA0AB001'
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 = 'FAC0AB001'
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 = 'FAG0AB001'
AND puf_tbu_cartelle_lingue.id_lingue = '2'
AND puf_tbu_file.id_lingue_2 = '3'
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 = 'FAG0AB001'
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 = 'FAB0AB004'
AND puf_tbu_cartelle_lingue.id_lingue = '2'
AND puf_tbu_file.id_lingue_2 = '8'
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 = 'FAB0AB004'
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'
TOP COMPOSIT manifold Ø 1” is made of thermoplastic, and it is used to distribute the pipes into the rooms. It is provided with flow meters on each circuit, digital flow and return thermometers with a liquidcrystal display, on-off valves (suitable for electrothermal heads), micrometric lockshield valves with data labels to locate rooms, end fittings with ball air vent valves and ball drain valves with hose nozzles and plugs, brackets which can be installed in cabinets or fixed on the wall, and push fit fittings for polyethylene pipes Ø 12, Ø 16 or Ø 17. Operating Pressure: 4 bar. Temperature Range: 5-60 °C.
TOP COMPOSIT manifold Ø 1” is made of thermoplastic, and it is used to distribute the pipes into the rooms. It is provided with flow meters on each circuit, digital flow and return thermometers with a liquidcrystal display, on-off valves (suitable for electrothermal heads), micrometric lockshield valves with data labels to locate rooms, end fittings with ball air vent valves and ball drain valves with hose nozzles and plugs, brackets which can be installed in cabinets or fixed on the wall, and push fit fittings for polyethylene pipes Ø 12, Ø 16 or Ø 17. Operating Pressure: 4 bar. Temperature Range: 5-60 °C.
