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 90 ROWS FETCH NEXT 15 ROWS ONLY
Manicotto di giunzione RossoCM10908 Manicotto di giunzione rosso...Dettagli
Filtro grande per ambienti polverosi. Evita l'accumulo di impurità nel rFAS-ASD-FL Filtro grande per ambienti polverosi Evita laccumulo di impurit nel rivelatore riduce i falsi allarmi ed aumenta la durata del sistema di aspirazione...Dettagli
Netsoft for 51 ? 160 ASD?sNETSOFT160 Netsoft for 51 – 160 ASD’s...Dettagli
Netsoft for 161 - plusNETSOFTMAX Netsoft for 161 plus...Dettagli
Air flow sensor for ASD 531/532AFS32 Air flow sensor for ASD 531532...Dettagli