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 = '011 ' AND I.GRP = '01153 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ' AND GRP = '01153 ')) ORDER BY I.Seq OFFSET 615 ROWS FETCH NEXT 15 ROWS ONLY
TRAFFIC SPEED DOME IP 8" 40X WDR 140dB SMART 4MP IR 400m NEMA 4XIDS-2VS435-F840-EY RISOLUZIONE 4MP 2560 1440 FRAME RATE 25FPS 2560 1440 SENSORE 118 Progressive Scan CMOS SENSIBILTA Color 0002 Lux F13 AGC ON BW 00002 Lux F13 AGC ON 0 lux con IR DAYNIGHT ICR OTTICA 6 mm to 240 mm Zoom Ottico 40X ottico 16x digitale COMPRESSIONE VI...Dettagli
Mini Full HD Wi-Fi Camera - Full HD Resolution 1080P@30fps - H.264 VideoDCS-8000LHV2 Mini Full HD WiFi Camera Full HD Resolution 1080P30fps H264 Video Compression One way audiobuilt in Mic Night Vision with 5M IR illumination IEEE 80211n 24GHz 1x1 Bluetooth interface support for installation Person Detection Support ONVIF pro...Dettagli