"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:23 [
  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" => "28161"
    "name" => "Wisenet WAVE-ENC-04 Encoder license."
    "id_image" => "297644"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28161"
  ]
  4 => array:6 [
    "id_product" => "28162"
    "name" => "Wisenet WAVE-IO-01 Entry/Exit Unit License."
    "id_image" => "297645"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28162"
  ]
  5 => array:6 [
    "id_product" => "28163"
    "name" => "Wisenet WAVE-PRO-16 16 x Hanwha IP Camera Server Recording…"
    "id_image" => "297646"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28163"
  ]
  6 => array:6 [
    "id_product" => "28164"
    "name" => "Wisenet WAVE-PRO-24 24 x Hanwha IP Camera Server Recording…"
    "id_image" => "297647"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28164"
  ]
  7 => array:6 [
    "id_product" => "28165"
    "name" => "Wisenet WAVE-PRO-48 48 x Hanwha IP Camera Server Recording…"
    "id_image" => "297648"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28165"
  ]
  8 => 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"
  ]
  9 => array:6 [
    "id_product" => "28179"
    "name" => "Wisenet WAVE-EMB-04 4 x Play license for Hanwha NVR."
    "id_image" => "297663"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28179"
  ]
  10 => array:6 [
    "id_product" => "28181"
    "name" => "Wisenet WAVE-PRO-04 4 x Hanwha IP Camera Server Recording…"
    "id_image" => "297665"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28181"
  ]
  11 => array:6 [
    "id_product" => "28182"
    "name" => "Wisenet WAVE-PRO-08 8 x Hanwha IP Camera Server Recording…"
    "id_image" => "297666"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28182"
  ]
  12 => array:6 [
    "id_product" => "28190"
    "name" => "Reyee RG-NBS3200-48GT4XS-P - Manageable Reyee Cloud PoE Switch PoE L2, 48 PoE + 4…"
    "id_image" => "297674"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28190"
  ]
  13 => array:6 [
    "id_product" => "28217"
    "name" => "Reyee RG-ES216GC - Reyee Switch Cloud Layer 2, 16 RJ45 Gigabit ports,…"
    "id_image" => "297701"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28217"
  ]
  14 => 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"
  ]
  15 => array:6 [
    "id_product" => "28247"
    "name" => "Aeotec ZW100 Multisensor 6 Aeotec Z-Wave Plus"
    "id_image" => "297731"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28247"
  ]
  16 => array:6 [
    "id_product" => "28248"
    "name" => "Hochiki ACC-EN(WHT)SCI Hochiki multi-sensor detector"
    "id_image" => "297732"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28248"
  ]
  17 => array:6 [
    "id_product" => "28249"
    "name" => "Wisenet TNO-3030T IP thermal tube, 13.7 mm fixed optics, 16º…"
    "id_image" => "297733"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28249"
  ]
  18 => array:6 [
    "id_product" => "28250"
    "name" => "Wisenet TNO-3040T IP thermal tube, 19 mm fixed optics, 11.5º…"
    "id_image" => "297734"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28250"
  ]
  19 => array:6 [
    "id_product" => "28251"
    "name" => "Philio Technology PST10 Philio 4-in-1 multisensor"
    "id_image" => "297735"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28251"
  ]
  20 => 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"
  ]
  21 => 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"
  ]
  22 => 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 = 150SELECT * FROM ps_od_oosbutton JOIN ps_od_oosbutton_lang USING (id_product) WHERE id_product = 19836 AND id_lang = 1 Dahua SD50225-HC-LA 4 in 1 motorized dome day / night 350 ° /…
Dahua SD50225-HC-LA 4 in 1 motorized dome day / night 350 ° /…
search
  • Dahua SD50225-HC-LA 4 in 1 motorized dome day / night 350 ° /…

Dahua SD50225-HC-LA 4 in 1 motorized dome day / night 350 ° /…

4 in 1 motorized dome day / night 350 ° / sec., Vandal resistant for outdoor use. 1 / 2,8 ""Sony STARVIS T CMOS, 2MP. Resolution 1080P (25 ips), 720P (25/50 ips). 4 in 1 output (HDCVI / HDTVI / AHD / 960H). 4.8 ~ 120mm 25X Optical Zoom (H: 58.5 ° ~ 2.8 °). 16X digital zoom. ICR filter. OSD, AWB,…
€598.55

Including €0.06 for ecotax

Tax included
Reference SD50225-HC-LA
Brand Dahua
Quantity
Available in 24/48h

Free shipping
Dahua SD50225-HC-LA 4 in 1 motorized dome day / night 350 ° /…

Dahua SD50225-HC-LA 4 in 1 motorized dome day / night 350 ° /…

€598.55

Dahua SD50225-HC-LA. 4 in 1 motorized dome day / night 350 ° / sec., Vandal resistant for outdoor use. 1 / 2,8 ""Sony STARVIS T CMOS, 2MP. Resolution 1080P (25 ips), 720P (25/50 ips). 4 in 1 output (HDCVI / HDTVI / AHD / 960H). 4.8 ~ 120mm 25X Optical Zoom (H: 58.5 ° ~ 2.8 °). 16X digital zoom. ICR filter. OSD, AWB, AGC, BLC, HLC, 120 dB real WDR, 2D / 3D-DNR, 24 privacy masks. 300 presets DH-SD, Pelco-D / P. 1 audio input. 2 inputs / 1 alarm output. RS485. IP66, IK10. 24V DC. Includes feeder. Sd50225-hc-la.



        

    

Characteristics

  •     StarLight technology
  •     1 / 2.8 "Sony® STARVIS ™ CMOS sensor, 2 megapixel
  •     25X optical zoom
  •     Up to 25/30 ips at 1080P, 25/30/50/60 ips at 720P
  •     WDR 120dB, 3D-DNR
  •     4-in-1 video output (HDCVI / HDTVI / AHD / CVBS)
  •     Degree of protection IP67
  •     Anti-vandalism IK10

Specs

  •     1 / 2.8 ”Sony® STARVIS ™ CMOS sensor, 2 megapixels
  •     Digital resolution: 1080P (1920x1080), 720P (1280x720)
  •     Pictures per second: 25/30 ips @ 1080P, 25/30/50/60 ips @ 720P
  •     4 in 1 video output: HDCVI / HDTVI / AHD / CVBS
  •     0.005 lux F1.6 (color) / 0.0005 lux F1.6 (B / W)
  •     Removable mechanical filter
  •     25X Optical Zoom: 4.8 ~ 120mm
  •     Viewing angle: 58.5 ° ~ 2.8 ° (H), 33.2 ° ~ 1.5 ° (V), 67.5 ° ~ 3.2 ° (D)
  •     Automatic, semi-automatic and manual focus control
  •     16X digital zoom
  •     White Balance: Auto, Indoor, Outdoor, Tracking, Manual, Sodium Lamp, Daylight, Street Light
  •     Automatic and manual gain control
  •     Backlight compensation (BLC, HLC)
  •     True WDR 120 dB
  •     2D / 3D digital noise reduction
  •     Digital defog
  •     24 zone privacy mask
  •     Horizontal positioner: 0 ° ~ 360 ° continuous
  •     Vertical positioner: 0 ° ~ 90 °, autoflip 180 °
  •     Manual speed: 0.1 ° ~ 350 ° / sec. (H), 0.1 ° ~ 250 ° / sec. (V)
  •     Preset speed: 500 ° / sec. (H), 500 ° / sec. (V)
  •     300 presets
  •     DH-SD and Pelco-D / P protocols (automatic recognition)
  •     5 patterns, 8 rounds of up to 32 presets each, 5 scans
  •     RS485 port (1200 ~ 9600 bps)
  •     1 audio input
  •     2 inputs / 1 alarm output
  •     Power supply: 24V DC / 2.5A (± 25%)
  •     Consumption: 15.5W (18.5W with fan and active PTZ)
  •     -40 ° C ~ + 60 ° C operating temperature
  •     Relative humidity: <95%
  •     Degree of protection IP67
  •     Anti-vandalism IK10
  •     Lightning-proof 6KV
  •     Dimensions: Ø186.2 x 253 mm
  •     Weight: 2.5 kg
  •     Includes power adapter

- DAHUA-2313