SELECT I.Description, I.DescriptionHTML, I.Code, I.PackPiecesNr, I.Id, (SELECT TOP 1 II.FileName FROM Media II WHERE II.EntityId = I.Id AND II.Type = 'IMAGE' AND II.EntityName = 'Item' ORDER BY Seq) AS Image, Trolese_WebSite.dbo.getSEOUrlByContentId(I.Code,'IT',NULL,NULL,I.LevelCode,0) AS SEOURL, COUNT(*) OVER() AS totResults FROM Item I WHERE I.LevelCode = 'ITEM' AND I.State IN (50,60) AND I.FAM IS NOT NULL AND I.Enabled = 1 AND I.Visible = 1 AND I.Deleted <> 1 AND I.State IN ('50','60') AND ((1=1 AND I.FAM = '01 ' AND I.SBFAM = '010 ' AND I.GRP = '01050 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '010 ' AND GRP = '01050 ')) ORDER BY I.Seq OFFSET 105 ROWS FETCH NEXT 15 ROWS ONLY
4MP Wisenet HD+ BulletHCO-7010RA Bullet camera 4MP WiseNet HD CMOS PS QHD 2560 x 1440 25fps over coax BNC AHD CVBS per installazione DWDR ottica fissa 28mm 20m IR range ICR distmax 500m motion detec Coax Ctrl IP66 IK10 12 Vdc...Dettagli
Dome HDCVI 2MP, 4 out, 2.7-13.5mm, IR 30 metri, 12VdcHAC-HDBW1801R-Z Dome HDCVI 2MP 4 out 27135mm IR 30 metri 12Vdc...Dettagli
2MP Starlight IR Active Deterrence Wizsense PTZSD3A200-GNP-W-PV Dettagli
TLC 1080p Fissa 3.6 mm 12V IR 30 mHAC-HFW1200T-S5 TLC 1080p Fissa 36 mm 12V IR 30 m...Dettagli
TLC 1080p Fissa 3.6 mm 12V IR 20 mHAC-HFW1200R-S5 TLC 1080p Fissa 36 mm 12V IR 20 m...Dettagli
Dome 1080p fissa 2.8 mm 12V IR 50 m MicrofonoHAC-HDW1200EM-A-S5 Dome 1080p fissa 28 mm 12V IR 50 m Microfono...Dettagli
Dome 1080p Varifocale 2.7~12 mm 12V IR 30 mHAC-HDBW1200R-Z-S5 Dome 1080p Varifocale 2712 mm 12V IR 30 m...Dettagli
Box Camera 4K 12V \24V ICR \Starlight \WDRHAC-HF3805G Box Camera 8MP HDCVI WDR 43” 8MP progressive scan CMOS M43 mount lens 30fps38402160 HDMI 15fps38402160 BNC 140db WDR Ultralow starlight technology2D3D NR HDMI video output directly Builtin Mic Software upgrade with USB Intelligent functions Up to 50...Dettagli
DOME 2K Fissa 1.18mm 12V WDR \IK10 antivandaloHAC-EW2501 DOME 2K Fissa 118mm 12V WDR IK10 antivandalo...Dettagli