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 ' AND I.SBGRP = '01157111 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ' AND GRP = '01157 ' AND SBGRP = '01157111 ')) ORDER BY I.Seq OFFSET 75 ROWS FETCH NEXT 15 ROWS ONLY
Cavo F/UTP cat 5e, LSZH verde, Bobina da 305mBNFU5E-C-UW305 Cavo FUTP cat 5e LSZH verde Bobina da 305m...Dettagli
Cavo F/UTP cat 5e, LSZH verde, Bobina da 1000mBNFU5E-C-WR1000 Cavo FUTP cat 5e LSZH verde Bobina da 1000m...Dettagli
Cavo F/UTP cat 5e, LSZH blu, Bobina da 1000mBNFU5E-E-WR1000 Cavo FUTP cat 5e LSZH blu Bobina da 1000m...Dettagli
Cavo F/UTP cat 5e, LSZH blu, Bobina da 500mBNFU5E-E-WR500 Cavo FUTP cat 5e LSZH blu Bobina da 500m...Dettagli
Cavo F/UTP cat 6, LSZH verde, termoretratto da 100mBNFU6-C-SF100 Cavo FUTP cat 6 LSZH verde termoretratto da 100m...Dettagli
Cavo U/UTP cat 5e+2x0.75, LSZH blu, termoretratto da 100mBNUU5E07-E-SF100 Cavo UUTP cat 5e2x075 LSZH blu termoretratto da 100m...Dettagli
UTP5EFR-SF100 Cavo dati resistente al fuocoUTP5EFR-SF100 UTP5EFRSF100 DATAFIRE CAVI DATI FUTP5E RESISTENTI AL FUOCO PH120 Norme di riferimento CEI EN 50289416 PH120 CEI UNEL 36762 UNI 97952013 100m...Dettagli
Cavo Video HD 75Ohm C4 5mm Bobina 500mHD8035-WR500 Cavo coassiale per videosorveglianza Norme di riferimento CEI EN 50117 Formazione solo coax Diametro esterno mm500 Trasmissione segnale video analogico m 800 Trasmissione segnale video HDSDIm160 Bobina 500m...Dettagli