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
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
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
Termica brandeggiata 400*300/60mm con temperaturaTPC-PT8420A-TB60Z30 Termica brandeggiata 40030060mm con temperatura...Dettagli
Termica brandeggiata 400*300/25mm con temperaturaTPC-PT8420A-TB25Z30 Termica brandeggiata 40030025mm con temperatura...Dettagli
Termica brandeggiata 400*300/35mm con temperaturaTPC-PT8420A-TB35Z30 Termica brandeggiata 40030035mm con temperatura...Dettagli
Thermal Network Hybrid Bullet Camera - 75mm lensTPC-BF8621-B75Z45 Thermal Network Hybrid Bullet Camera 75mm lens...Dettagli
Termica brandeggiata 400*300/100mm con temperaturaTPC-PT8420A-TB100Z30 Termica brandeggiata 400300100mm con temperatura...Dettagli