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 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '06 ' AND SBFAM = '054 ')) ORDER BY I.Seq OFFSET 285 ROWS FETCH NEXT 15 ROWS ONLY
Nasetto di ricambio GPLKX097GP Nasetto di ricambio per sensori S2096ME e S2097ME...Dettagli
Bombola 1 l. - 34 bar - 34 litri utili SO2 10 ppm in N2BO468 Bombola 1 l 34 bar 34 litri utili SO2 10 ppm in N2...Dettagli
Cono convogliatore per sensori di gas industriali diametro cm. 47TR532 Cono convogliatore per sensori di gas industriali diametro cm 47...Dettagli
Valv. 12.20 per bombola 12 l. - gas inertiBO300 Valv 1220 per bombola 12 l gas inerti...Dettagli
Cartuccia GAS AZOTO - 10litri - merce pericolosaSIB99 cartuccia GAS AZOTO 10litri merce pericolosa...Dettagli
Griglia di protezione meccanica per sensori di gas industrialiTR533 Dettagli