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 1185 ROWS FETCH NEXT 15 ROWS ONLY
IP Bullet camera IR, 2M, 5.2 ~ 62.4mm mot., IR 70m, WDR, IK10, IP67XNO-6120R Wisenet X con DSP Wisenet 5 network IR antivandalo bullet camera da esterno 2MP 60fps Full HD1080p ottica zoom da 52 624mm 12x 5458530 triplo codec H265H264MJPEG con WiseStream II Multiple streaming 150dB WDR True Day Night ICR High Powered IR LEDs...Dettagli