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 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ')) ORDER BY I.Seq OFFSET 2640 ROWS FETCH NEXT 15 ROWS ONLY
Flush mountSHD-1408FW Polycarbonate Inceiling Flush Mount for Dome cameras Compatible with PND9080R XND60806080R6080RV6080V8080R8080V8080RVL6080RL6080RVL6080V HCV6070R60806080R7070R7080R White...Dettagli
Flush mountSHD-1198FW Polycarbonate Inceiling Flush Mount for Dome cameras Compatible with QND6070R6082R7080R8080R HCD6070R6080R7070R7080R White...Dettagli
2MP BoxQNB-6002 Wisenet Q network box camera 2MP 30fps triplo codec H265H264MJPEG con WiseStream II Streaming multipli 120dB WDR True Day Night ICR Advanced Video Analytics Hallway View Motion detection Tampering Defocus detection audio bidirezionale e solt SDSDHCS...Dettagli