"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 = 9420 AND id_lang = 1 EAS-84SPL-AM - Electronic protection of EAS articles, Product…
  • -35%
EAS-84SPL-AM - Electronic protection of EAS articles, Product…
search
  • EAS-84SPL-AM - Electronic protection of EAS articles, Product…

EAS-84SPL-AM - Electronic protection of EAS articles, Product…

Electronic protection of EAS articles - Product anti-theft alarm system - Low frequency Passive device 58 KHz - Compatible with SPL detector - Maximum security - Suitable for all types of businesses
€0.16 €0.25 Save 35%
Tax included
Reference EAS-84SPL-AM
Brand Branded
Quantity
Available in 24/48h

Free shipping
EAS-84SPL-AM - Electronic protection of EAS articles, Product…

EAS-84SPL-AM - Electronic protection of EAS articles, Product…

€0.16 €0.25 Save 35%
  • Electronic protection of EAS articles
  • Anti-shoplifting pin
  • Low frequency 58 KHz
  • Maximum security
  • Compatible with SPL detector
  • 55 x 30 mm
  • Suitable for all types of businesses

Features

  • Electronic protection of EAS articles
  • Product anti-theft alarm system
  • Low frequency Passive device 58 KHz
  • Compatible with SPL detector
  • Maximum security
  • Suitable for all types of businesses

Specs

RFID 58 KHz Passive
Material ABS
Anti Theft Magnetic Security Tag
Lot 200 pieces
Reading distance 1.8 meters
Magnetic tape size 42 mm
Dimensions 55 x 30 mm
Weight 35 g

Package content

    Data sheet

    Weight
    35 g
    35 g
    Dimensions
    55 x 30 mm
    55*30 mm
    Material
    ABS
    PVC
    Reading distance
    1.8 meters
    RFID
    58 KHz Passive
    Anti Theft
    Magnetic Security Tag
    Lot
    200 pieces
    Magnetic tape size
    42 mm