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 = 'FBA0CA011'
AND puf_tbu_cartelle_lingue.id_lingue = '2'
AND puf_tbu_file.id_lingue_2 = '1000'
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 = 'FDA0CA003'
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 = 'FCA0CA018'
AND puf_tbu_cartelle_lingue.id_lingue = '2'
AND puf_tbu_file.id_lingue_2 = '1000'
AND puf_tbu_file.id_lingue_1 = '999'
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 = 'FAG0CA011'
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'
Ductable isothermal dehumidifier with summer and winter integration for horizontal ceiling installation. It consists of a complete cooling unit (with refrigerant R134a), centrifugal fan and pre and post‐treatment coils to be supplied separately with cooled water (15 °C).
Ductable isothermal dehumidifier with summer and winter integration for horizontal ceiling installation. It consists of a complete cooling unit (with refrigerant R134a), centrifugal fan and pre and post‐treatment coils to be supplied separately with cooled water (15 °C).
