"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 = 108SELECT * FROM ps_od_oosbutton JOIN ps_od_oosbutton_lang USING (id_product) WHERE id_product = 5526 AND id_lang = 1 Hiwatch HWI-B620H-Z - 2 Megapixel Hikvision IP Camera, 1/3\" Progressive Scan…
  • -35%
Hiwatch HWI-B620H-Z - 2 Megapixel Hikvision IP Camera, 1/3" Progressive Scan…
search
  • Hiwatch HWI-B620H-Z - 2 Megapixel Hikvision IP Camera, 1/3" Progressive Scan…

Hiwatch HWI-B620H-Z - 2 Megapixel Hikvision IP Camera, 1/3\" Progressive Scan…

2 Megapixel Hikvision IP Camera - 1/3" Progressive Scan CMOS - Compression H.265+ / H.265 - 2.8~12mm motorised auto-focus lens - EXIR IR LEDs range 30 m - WDR | 3DNR | BLC | IP67 | SD Slot
€126.10 €194.00 Save 35%
Tax included
Reference HWI-B620H-Z
Brand Hiwatch
Quantity
Available in 24/48h

Free shipping
Hiwatch HWI-B620H-Z - 2 Megapixel Hikvision IP Camera, 1/3" Progressive Scan…

Hiwatch HWI-B620H-Z - 2 Megapixel Hikvision IP Camera, 1/3\" Progressive Scan…

€126.10 €194.00 Save 35%

You might also like

  • Hikvision HiWatch Series
  • IP camera
  • 1/2.8" Progressive Scan CMOS
  • 2 Megapixel (1920x1080)
  • 2.8~12 mm motorised varifocal autofocus lens
  • 0 Lux
  • IR Range 30 m
  • H.265+/H.265/H.264+/H.264
  • Dual stream
  • RJ-45 10/100 BaseT
  • PoE IEEE802.3af
  • SD card recording
  • Weatherproof IP67
  • IR Cut
  • WDR (120dB)
  • WEB, CMS, Smartphone and NVR interface
  • ONVIF Compatible

Features

  • 2 Megapixel Hikvision IP Camera
  • 1/3" Progressive Scan CMOS
  • Compression H.265+ / H.265
  • 2.8~12mm motorised auto-focus lens
  • EXIR IR LEDs range 30 m
  • WDR | 3DNR | BLC | IP67 | SD Slot

Specs

Brand Hikvision
Range HiWatch Series
Image sensor 1/2.8" Progressive Scan CMOS
Maximum resolution 2 Megapixel (1920x1080)
Main Stream rate 1080p / 720p (25 FPS)
Extra Stream rate D1 / CIF (1 ~ 25 FPS)
Compression H.265+/H.265/H.264+/H.264
Bitrate 32 Kbps ~ 8 Mbps
Lens 2.8 mm ~ 12 mm Motorised Autofocus
Minimum illumination Colour 0.01 Lux @ F1.2 | Colour 0.018 Lux @ F1.6
Infrared lighting 0 Lux / EXIR LEDs IR (30 m)
Image improvements WDR (120dB), BLC, 3D-NR, AGC, Motion detection
Day / Night Removable mechanical ICR filter
Alarms No
Audio No
Network interface Ethernet 10/100 BaseT
Internal memory Slot for MicroSD card, Max 128 GB
Remote access Web Browser, Smartphone App IVMS 4500 and PC Software IVMS 4200
Interoperability ONVIF, PSIA, CGI, ISAPI
Power DC 12 V / 800 mA, PoE IEEE802.3af
Degree of protection Weatherproof IP67
Material Metallic
Temp. operation -30º C ~ +50º C
Dimensions 244.4 mm (D) x 105 (Ø) mm
Weight 1015 g

Package content

  • Hikvision IP Bullet Camera
  • Installation material
  • Instructions

Data sheet

Weight
1015 g
1015 g
Power
DC 12 V / 800 mA, PoE IEEE802.3af
Temp. operation
-30º C ~ +50º C
Degree of protection
Weatherproof IP67
Dimensions
244.4 mm (D) x 105 (Ø) mm
Transfer Rate
32 Kbps ~ 8 Mbps
Power supply
DC 12 V / 800 mA, PoE IEEE802.3af
Material
Metallic
Range
HiWatch Series
Audio
No
Image sensor
1/2.8\" Progressive Scan CMOS
Minimum illumination
Colour 0.01 Lux @ F1.2 | Colour 0.018 Lux @ F1.6
Lens
2.8 mm ~ 12 mm Motorised Autofocus
Maximum resolution
2 Megapixel (1920x1080)
Infrared lighting
0 Lux / EXIR LEDs IR (30 m)
Image improvements
WDR (120dB), BLC, 3D-NR, AGC, Motion detection
Day / Night
Removable mechanical ICR filter
Alarms
No
Internal memory
Slot for MicroSD card, Max 128 GB
Remote access
Web Browser, Smartphone App IVMS 4500 and PC Software IVMS 4200
Main Stream rate
1080p / 720p (25 FPS)
Extra Stream rate
D1 / CIF (1 ~ 25 FPS)
Compression
H.265+/H.265/H.264+/H.264
Network interface
Ethernet 10/100 BaseT
Interoperability
ONVIF, PSIA, CGI, ISAPI