"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 = 283SELECT * FROM ps_od_oosbutton JOIN ps_od_oosbutton_lang USING (id_product) WHERE id_product = 17848 AND id_lang = 1 CAROLB Siren for outward CAROL
  • -35%
Demes OEM CAROLB Siren for outward CAROL
search
  • Demes OEM CAROLB Siren for outward CAROL

CAROLB Siren for outward CAROL

Siren for outward CAROL. Built in ABS plastic in WHITE colour. No BATTERY. Silverside integrated to protect all the inner circuitry. Operation as powered siren at 12V or self-powered siren with battery 7.2V
€51.58 €79.35 Save 35%
Tax included
Reference CAROLB
Brand Dem
Quantity
Available in 24/48h

Free shipping
Demes OEM CAROLB Siren for outward CAROL

CAROLB Siren for outward CAROL

€51.58 €79.35 Save 35%

CAROLB. Siren for outward CAROL. Built in ABS plastic in WHITE colour. No BATTERY. Silverside integrated to protect all the inner circuitry. Operation as powered siren at 12V or self-powered siren with battery 7.2V Sirena carol blanca.

- Siren for outward CAROL- Built in ABS plastic in WHITE colour- No BATTERY- Silverside integrated to protect all the inner circuitry- Operation as powered siren at 12V or self-powered siren with battery 7.2V (optional)- 2 blinking (cancellable option) LEDs with permanent signalling integrated to indicate the optimum operation of the siren- Piezoelectric loudspeaker- Cover and wall tamper- Flashing light pilot- Specifications of the integrated norma circuit:- Controlled by microprocessor- 2 sound types available (acute and grave)- 4 timings: 2, 3, 5 and 10 cycles (every cycle takes 60 sec. of sound and 30 sec. idle), according to the valid regulations in some Spanish regions- Activation by negative or positive- 2 powers available: 85 dB and 112 dB- Dimensions: 220 x 310 x 70 mm- Option to customize with screen-printing (min. 25 units and up to 3 inks free of charge) in a max. area of 16 x 16 cm

- DEM-810

Dem