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 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ')) ORDER BY I.Seq OFFSET 5280 ROWS FETCH NEXT 15 ROWS ONLY
Cavo F/UTP cat 5e, LSZH verde, Bobina da 305mBNFU5ECNH-UW305 Cavo FUTP cat 5e LSZH verde Bobina da 305m...Dettagli
Cavo per sistemi IP e PoE ad alte prestazioni, conf. BB 500 mHDIP3220ENH-WR500 Cavo per sistemi IP e PoE ad alte prestazioni conf BB 500 m...Dettagli
Forbice per il taglio dell?armatura in Kevlar delle fibre ottiche PZ 1JIC186 Forbice per il taglio dell’armatura in Kevlar delle fibre ottiche PZ 1...Dettagli
Stripper per rivestimento da 125/900 micron PZ 1JIC375 Stripper per rivestimento da 125900 micron 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