"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 = 321SELECT * FROM ps_od_oosbutton JOIN ps_od_oosbutton_lang USING (id_product) WHERE id_product = 21617 AND id_lang = 1 Ezviz by Hikvision C3WN Compact WiFi IP camera Ezviz from…
  • -35%
Dahua SSD-E800S512G 2.5 "SATA DAHUA hard drive. 512GB capacity
search
  • Dahua SSD-E800S512G 2.5 "SATA DAHUA hard drive. 512GB capacity

Ezviz by Hikvision C3WN Compact WiFi IP camera Ezviz from…

Compact WiFi IP camera Ezviz from HIKVISION with IR lighting 30m for outdoors. 1 / 2.9 ""CMOS of 2MP. H.264 format. Resolution up to 1080P at 30ips. ICR filter. 2.8 mm (95 °) fixed lens. Digital WDR, 3D-DNR. Incorporates microphone. MicroSD slot. RJ45 network port. Cloud-based EZVIZ protocol.…
€507.88 €781.36 Save 35%
Tax included
Reference C3WN
Brand Aeotec
Quantity
In Stock

Free shipping
Dahua SSD-E800S512G 2.5 "SATA DAHUA hard drive. 512GB capacity

Ezviz by Hikvision C3WN Compact WiFi IP camera Ezviz from…

€507.88 €781.36 Save 35%

Ezviz by Hikvision C3WN. Compact WiFi IP camera Ezviz from HIKVISION with IR lighting 30m for outdoors. 1 / 2.9 ""CMOS of 2MP. H.264 format. Resolution up to 1080P at 30ips. ICR filter. 2.8 mm (95 °) fixed lens. Digital WDR, 3D-DNR. Incorporates microphone. MicroSD slot. RJ45 network port. Cloud-based EZVIZ protocol. IP66. 12V DC

   

Specifications

    Image Sensor 1 / 2.9 "CMOS, 2 Megapixel

    Maximum resolution: 1080P (1920x1080)

    H.264 video compression

    Main Stream: 1080P (30 ips)

    Day / night mode with removable mechanical filter (ICR)

    0.02 lux F2.0 / 0 lux IR On

    IR illumination up to 30 meters

    2.8mm fixed lens

    Viewing angle: 95 ° (H), 110 ° (D)

    Imaging modes: Digital WDR, 3D-DNR

    Intelligent motion sensor alarm

    Incorporates microphone

    Noise suppression function

    MicroSD card slot up to 256GB (card not included)

    Self-adaptive RJ45 Ethernet port (10 / 100M)

    Access Point WiFi Linking

    2.4GHz IEEE802.11b / g / n WiFi interface

    WEP 64 / 128bit, WPA / WPA2 and WPA-PSK / WPA2-PSK data encryption

    EZVIZ proprietary cloud-based protocol

    Remote viewing and management on smartphones with the EZVIZ or Studio EZVIZ app

    Power supply: 12V DC, 1A

    Consumption: Max. 6W

    Degree of protection IP66

    Dimensions: 72 (W) x 72 (H) x 150 mm

    Weight: 288g

Aeotec