"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 = 33SELECT * FROM ps_od_oosbutton JOIN ps_od_oosbutton_lang USING (id_product) WHERE id_product = 21211 AND id_lang = 1 Surface plate, Hot-Dip Galvanizing 450XL and 550 towers (Ref. 313412 and 3142xx) Televes
  • -35%
CON100-CAP - BNC male connector, Simple, Fast, Reusable,…
search
  • CON100-CAP - BNC male connector, Simple, Fast, Reusable,…

Surface plate, Hot-Dip Galvanizing 450XL and 550 towers (Ref. 313412 and 3142xx) Televes

Ground surface mount plate using pikes, no need for concrete. Used for bolting on it a pivoting base from 450XL or 550 range (ref. 313412 and 3142xx). The hot-dip galvanizing surface treatment provides enhanced durability in adverse corrosion conditions. Grey finish.
€330.33 €508.20 Save 35%
Tax included
Reference televes-312911
Brand Televes
Quantity
Available in 24/48h

Free shipping
CON100-CAP - BNC male connector, Simple, Fast, Reusable,…

Surface plate, Hot-Dip Galvanizing 450XL and 550 towers (Ref. 313412 and 3142xx) Televes

€330.33 €508.20 Save 35%

Ground surface mount plate using pikes, no need for concrete. Used for bolting on it a pivoting base from 450XL or 550 range (ref. 313412 and 3142xx).

Features

  • The hot-dip galvanizing surface treatment provides enhanced durability in adverse corrosion conditions
  • Grey finish

Data sheet

Weight
600 g
Power
DC 12V / 462mA max., PoE IEEE802.3af
Temp. operation
-30º C ~ +60º C
Dimensions
41.2 (H) x 119.9 (Ø) mm
Transfer Rate
32 Kbps ~ 8 Mbps
Dimensions / Weight
25 (D) x 10 (W) mm / 5 g
Compatibility
Microcoaxial cable and RG59
Connection type
BNC male for crimp
Image sensor
1/1.3\" Progressive Scan CMOS
Minimum illumination
0.01 Lux (F1.2)
Basic functions
OSD Menu
Lens
Lens 1.6 mm Fisheye
Maximum resolution
2560x1440 (4 MP)
Image improvements
3D-NR, BLC, AWB, AGC, ROI, Defog
Day / Night
Removable mechanical ICR filter
Alarms
1 inputs / 1 relay
Internal memory
MicroSD card up to 128GB (not included)
Remote access
Web browser, Safire Control Center Smartphone App and PC Software
Main Stream rate
12.5fps(2560 × 1440), 25fps(1920 × 1080, 1280 × 720)
Compression
H.264/MJPEG
Network interface
Ethernet 10/100/1000 BaseT
Video analysis
VCA: Cross-line, intrusion detection, area entry/exit detection, removed/abandoned object detection Intersection analysis: Detects and analyzes flow in an intersection-like scene and generates reports. Supports intersection up to 10 shapes
Interoperability
HIKVISION, ONVIF, PSIA, CGI, ISAPI
Display modes
16 visualisation modes supported, including image correction/de-warping Views: Fisheye, panoramic, up to 8 ePTZ and various combinations