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 = '06 ' AND I.SBFAM = '054 ' AND I.GRP = '054137 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '06 ' AND SBFAM = '054 ' AND GRP = '054137 ')) ORDER BY I.Seq OFFSET 30 ROWS FETCH NEXT 15 ROWS ONLY
Cappuccio di taratura e ricarica (alim. non compreso)NA010G Cappuccio di taratura e ricarica alim non compreso...Dettagli
Rilev. monogas portatile MICRO IV - per O2 - Range 25% Vol.NE600G Rilev monogas portatile MICRO IV per O2 Range 25 Vol...Dettagli
Staffa preforata di montaggio per sensori di gas industrialiTR530 Dettagli
Griglia di protezione meccanica per sensori di gas industrialiTR533 Dettagli