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 2715 ROWS FETCH NEXT 15 ROWS ONLY
Penna ottica per la verifica della fibra ottica per connettori FC, SC, LVFL150 Penna ottica per la verifica della fibra ottica per connettori FC SC LC e ST PZ 1...Dettagli
Cavo U/UTP cat 6 LSZH blu, Bobina da 1000mBNUU6SLENH-WR1000 Cavo UUTP cat 6 LSZH blu Bobina da 1000m...Dettagli
Cavo U/UTP cat 6 LSZH blu, Bobina da 500mBNUU6SLENH-WR500 Cavo UUTP cat 6 LSZH blu Bobina da 500m...Dettagli