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 2250 ROWS FETCH NEXT 15 ROWS ONLY
Indoor housingUHI-OG-0 Custodia per interno in alluminio con vetro auto pulente per gruppi camera fino a 317mm...Dettagli
Adatt. Da Controsoff. X Speed DomeDS1671ZJ Adatt Da Controsoff X Speed Dome...Dettagli
Atx power dps-200pb-185 a,52v&12v,190w101700342 Atx power dps200pb185 a52v12v190w...Dettagli
Media Converter 1 x RJ45 10/100Mbps / 1 x fibra ottica 100BASE-FX (SC)DMC-515SC 10100BaseTX to 100BaseFX Singlemode Media Converter with SC Fiber Connector UTP to Singlemode Fiber Media Converter SC Fiber connector HalfFullDuplex Distance up to 15km Includes Power Supply for standalone use...Dettagli