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 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ')) ORDER BY I.Seq OFFSET 5280 ROWS FETCH NEXT 15 ROWS ONLY
PTZ IP AI 4MP 40x WDR IR Starlight 36V/Hi-PoESD8A440-HNF-PA PTZ IP AI 4MP 40x WDR IR Starlight 36VHiPoE...Dettagli
Wisenet Q network IR dome da interno, 2MP, ottica 2.8mm PoE/12VDCQND-6012R Wisenet Q network IR dome camera da interno 2MP 30fps ottica fissa da 28mm 11374 triple codec H265H264MJPEG con WiseStream Multiple streaming 120dB WDR True Day Night ICR IR da 20m Motion detection Tampering Defocus detection Hallway View Directiona...Dettagli