"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 = 105SELECT * FROM ps_od_oosbutton JOIN ps_od_oosbutton_lang USING (id_product) WHERE id_product = 2890 AND id_lang = 1 AC-CARTEL-ES - Plastic sign, Screenprint Area with Video…
  • -35%
AC-CARTEL-ES - Plastic sign, Screenprint Area with Video…
search
  • AC-CARTEL-ES - Plastic sign, Screenprint Area with Video…

AC-CARTEL-ES - Plastic sign, Screenprint Area with Video…

Plastic sign - Screenprint Area with Video Surveillance - Approved - 297 (H) x 210 (W) mm - Interior/exterior use - Required in all CCTV installations
€2.18 €3.36 Save 35%
Tax included
Reference AC-CARTEL-ES
Brand Branded
Quantity
Available Now

Free shipping
AC-CARTEL-ES - Plastic sign, Screenprint Area with Video…

AC-CARTEL-ES - Plastic sign, Screenprint Area with Video…

€2.18 €3.36 Save 35%

Plastic plate for interior/exterior. Silk-screen print of Area with video surveillance, approved under current regulations.

According to the Organic Law 15/1999, current legislation on video surveillance, any body that has supervised protection 24 hours by security cameras should mark it properly by a sufficiently visible informational poster. In this poster it must be indicated the body to which citizens can exercise their rights of access, rectification, cancellation or opposition of the data contained in the recording files.

Essential element in any public CCTV installation.

Features

  • Plastic sign
  • Screenprint Area with Video Surveillance
  • Approved
  • 297 (H) x 210 (W) mm
  • Interior/exterior use
  • Required in all CCTV installations

Specs

Material Flexible plastic
Dimensions 297 (H) x 210 (W) mm
Utilization environment Interior/Exterior
Language Spanish

Package content

  • - Plastic sign

Data sheet

Dimensions
297 (H) x 210 (W) mm
Material
Flexible plastic
Utilization environment
Interior/Exterior
Language
Spanish