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
Staffa da parete per telecamere serie PTZ12PFB712W Dettagli
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
Adattatore Backbox, dimensioni diam 136.0 x 40.0 mmSBV-136B Adattatore Backbox compatibilita SNVL6083RPL5083RP SCV6083RP6023RP5085P5083RP dimensioni 1360 x 400 mm...Dettagli