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 = '03 ' AND I.SBFAM = '048 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '03 ' AND SBFAM = '048 ')) ORDER BY I.Seq OFFSET 150 ROWS FETCH NEXT 15 ROWS ONLY
Adapter M20, ABS, to self sealing coupling (10 pcs.)AD20ABS Adapter M20 ABS to self sealing coupling 10 pcs...Dettagli
O-Ring for AFS 35 (50pcs)O-RINGVE50 ORing for AFS 35 50pcs...Dettagli
Sampling point T-piece, Ø 32 mm, set, for concrete insertSP32CT Sampling point Tpiece 32 mm set for concrete insert...Dettagli
Compressed-air connection, Ø 25 mm, ABSCC25ABS Compressedair connection 25 mm ABS...Dettagli
Repl filter mat 5pcs, FBL 25 PC EFMFBL25PCEFM Repl filter mat 5pcs FBL 25 PC EFM...Dettagli
Smoke Sensing Device for REK 511, 0.3% Obs./mSSD515-3S Smoke Sensing Device for REK 511 03 Obsm...Dettagli
Smoke Sensing Device for REK 511, 1.2% Obs./mSSD515-1S Smoke Sensing Device for REK 511 12 Obsm...Dettagli
Sampling point for ceiling duct, M20, Ø 36 mm grey, ABS, compl. setSPM20ABS-SET Sampling point for ceiling duct M20 36 mm grey ABS compl set...Dettagli