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 = '01157 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ' AND GRP = '01157 ')) ORDER BY I.Seq OFFSET 960 ROWS FETCH NEXT 15 ROWS ONLY
24" Tecnologia: LED Backlight Risoluzione: Full-HD 1920 x 1080 Input HDMDS-D5024FC 24 Tecnologia LED Backlight Risoluzione FullHD 1920 x 1080 Input HDMIVGABNCAUDIO Output BNC AUDIO Speaker Integrati Angolo di visione 170180 3D Comb Filter 3D Noise Reduction 3D Deinterlace Compatibilit con staffe VESA Case Plastico...Dettagli
Scatola di giunzione in alluminio per telecamera (139.3mmx50.0mm)ACM202-B Scatola di giunzione in alluminio per telecamera 1393mmx500mm 1716mmx500mm con pressacavo...Dettagli