"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 = 294SELECT * FROM ps_od_oosbutton JOIN ps_od_oosbutton_lang USING (id_product) WHERE id_product = 20922 AND id_lang = 1 Nivian Retail NVS-IPC-I4 - Nivian Smart Camera 1080P, Wifi 2.4 GHz, Audio | IR…
Hikvision HWT-B120-P Cámara bullet 4 en 1 Serie HiWatch de…
search
  • Hikvision HWT-B120-P Cámara bullet 4 en 1 Serie HiWatch de…

Nivian Retail NVS-IPC-I4 - Nivian Smart Camera 1080P, Wifi 2.4 GHz, Audio | IR…

Nivian Smart Camera 1080P - Wifi 2.4 GHz - Audio | IR Range 9 m - Micro SD card slot up to 128 GB - Compatible with TUYA Smart - Compatible with Google Asistant and Alexa
Reference NVS-IPC-I4
Brand Imou by Dahua
Quantity

Free shipping
  • Nivian Smart Camera
  • 1/2.7" Progressive CMOS
  • 1080p (1920 x 1080)
  • 4 mm Lens
  • IR Range 9 m
  • Compression H.264
  • Wifi IEEE 802.11 b/g/n 2.4 GHz
  • Micro SD card slot up to 128 GB
  • Your Cloud Storage (under subscription)
  • Two-way audio (integrated mic and speaker)
  • Compatible with TUYA Smart App
  • Compatible with Google Assistant and Alexa Echo
  • Smart Home control and automation from app

Features

  • Nivian Smart Camera 1080P
  • Wifi 2.4 GHz
  • Audio | IR Range 9 m
  • Micro SD card slot up to 128 GB
  • Compatible with TUYA Smart
  • Compatible with Google Asistant and Alexa

Specs

Brand Nivian Smart
Image sensor 1/2.7” Progressive CMOS
Resolution 1920x1080 (1080P), 640x480 (VGA)
Transfer Rate 15 FPS
Compression H.264
Lens 4 mm (D: 85º)
Minimum illumination 0 Lux | IR range up to 9 m
Characteristics Motion Detection, Privacy Mask
Audio Bidirectional audio (Microphone, audio input & output)
Network interface WiFi IEEE 802.11b/g/n 2.4GHz
Plug&Play Access P2P, with QR code scan
Events notification Push notification and recording of video and image on SD card
Remote access Tuya Cloud, Google Assistant and Amazon Echo
Internal memory Slot MicroSD card, Max 128 GB (not included)/Tuya Cloud Storage
Use Interior
Power DC 5 V / 1 A
Dimensions / Weight 73 (Ø) x 149 (Al) / 240 g

Package content

  • IP camera
  • Power supply DC 5 V / 1000 mA
  • Mounting accessories
  • User Manual