"hola"
SELECT p.id_product, pl.name, id_image, t.id_button, IFNULL(pcl.name, "Sin stock con fecha de entrada") as contact, p.id_product as id_od_outofstock FROM ps_product p LEFT JOIN ps_product_lang pl ON p.id_product = pl.id_product AND pl.id_lang = 1 LEFT JOIN ps_od_oosbutton t ON t.id_product = p.id_product LEFT JOIN ps_contact_lang pcl ON t.id_button = pcl.id_contact AND pcl.id_lang = 1 LEFT JOIN ps_image_shop i ON p.id_product = i.id_product AND i.cover = 1 WHERE (t.id_button IS NOT NULL) GROUP BY id_product
array:8 [
  0 => array:6 [
    "id_product" => "203"
    "name" => "Power supply 4 Amp. Single channel amplifier serie Tas 001 Triax"
    "id_image" => "2627"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "203"
  ]
  1 => array:6 [
    "id_product" => "204"
    "name" => "Triax TAS 050 Mono Amplifier TDT UHF 50 dB"
    "id_image" => "2632"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "204"
  ]
  2 => array:6 [
    "id_product" => "21818"
    "name" => "Tegui Dual camera B/W TC-70 Europa Series"
    "id_image" => "294910"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "21818"
  ]
  3 => array:6 [
    "id_product" => "28166"
    "name" => "Wisenet WAVE-VW-02 Video Wall License. Management of 2 monitors."
    "id_image" => "297649"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28166"
  ]
  4 => array:6 [
    "id_product" => "28225"
    "name" => "Risco RP512B00000A Polycarbonate box for ProSYS Plus control…"
    "id_image" => "297709"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28225"
  ]
  5 => array:6 [
    "id_product" => "28756"
    "name" => "Bticino 336803. Cable for connection to the installation of internal stations installed on a desktop support"
    "id_image" => "298287"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28756"
  ]
  6 => array:6 [
    "id_product" => "28758"
    "name" => "Hikvision pro DS-2CD3646G2/P-IZS(2.8-12MM) Cámara IP 4MP bullet…"
    "id_image" => "298289"
    "id_button" => "0"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28758"
  ]
  7 => array:6 [
    "id_product" => "28780"
    "name" => "Risco RVIM3A15000A / PFA150 Pole adapter for PFBx PFAx"
    "id_image" => "298428"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28780"
  ]
]
SELECT * FROM ps_od_oosbutton_manufacturer WHERE id_manufacturer = 65SELECT * FROM ps_od_oosbutton JOIN ps_od_oosbutton_lang USING (id_product) WHERE id_product = 28755 AND id_lang = 1 Tegui 374001. Connection hose between columns for the connection between SERIES 7 plates of the Conventional…
Tegui 374001. Connection hose between columns for the connection between SERIES 7 plates of the Conventional…
search
  • Tegui 374001. Connection hose between columns for the connection between SERIES 7 plates of the Conventional…

Tegui 374001. Connection hose between columns for the connection between SERIES 7 plates of the Conventional…

Tegui 374001. Connection hose between columns for the connection between SERIES 7 plates of the Conventional system placed on their sides. One patch cord is required for each additional column. 70cm. of length.
€5.49
Tax included
Reference tegui-374001
Brand Tegui
Quantity
In Stock

Free shipping
Tegui 374001. Connection hose between columns for the connection between SERIES 7 plates of the Conventional…

Tegui 374001. Connection hose between columns for the connection between SERIES 7 plates of the Conventional…

€5.49

Connection hose between columns for the connection between SERIES 7 plates of the Conventional system placed on their sides.

One patch cord is required for each additional column.

70cm.

of length.

FeaturesValue
Halogen free according to EN IEC 60754-2-
Reaction-to-fire according to EN 13501-6: Flaming droplets/particlesNone
Cable height approx.6 mm
Reaction-to-fire according to EN 13501-6: Smoke productionNone
Reaction-to-fire according to EN 13501-6: ClassNone
Number of pilot/reduced conductors-
Cable width approx.5 mm
Nominal cross section pilot/reduced conductors- mm²
Weight- kg
Low temperature resistant according to EN 60811-504+505+506No
Oil resistant according to EN IEC 60811-404No
Conductor surfaceBare
Material armouring-
Number of stranding elements-
Torsion resistantNo
Reaction-to-fire according to EN 13501-6: AcidityNone
Min. permitted bending radius, stationary application/permanent installation- mm
Min. permitted bending radius, moving application/free movement- mm
Min. permitted bending radius, moving application with forced guidance- mm
Shape of conductorRound
Specification material outer sheath-
Specification core insulation-
Colour outer sheathGrey
Number of strands per conductor-
Conductor resistance at 20 °C- Ohm/km
Halogen free according to EN IEC 60754-3-
Strand diameter- mm
Low smoke according to EN IEC 61034-2No
Nominal voltage U12 kV
Stranding elementNo
Nominal voltage U012 kV
Number of cores3
Screen-
Core identificationOther
Suspension elementNone
Material core insulation-
Nominal cross section conductor0.16 mm²
Halogen free according to EN IEC 60754-1-
Flame retardant according to IEC 60332-3-24 (Cat C)-
Flame retardant according to IEC 60332-3-25 (Cat D)-
Conductor materialCopper
Screen over strandingNone
Screen over stranding elementNone
Outer diameter approx.2 mm
Drain wire-
Flame retardant according to IEC 60332-3-22 (Cat A)-
Material outer sheath-
Flame retardant according to IEC 60332-3-23 (Cat B)-
Flame retardant according to IEC 60332-1-2-
Max. conductor temperature- °C
Flame retardant according to IEC 60332-3-21 (Cat A F/R)-
Protective barrier-
AWG size26
Armouring/reinforcement-
Permitted cable outer temperature after assembling without vibration- °C
Permitted cable outer temperature during assembling/handling- °C
With protective conductorNo
Core identification according to HD 308 S2-
Max. tensile strength during installation- kN
Cable geometryFlat
Conductor categoryClass 6 = very flexible
Nominal cross section pilot/reduced conductors (AWG)-
Nominal cross section conductor (AWG)- kcmil