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 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ')) ORDER BY I.Seq OFFSET 6255 ROWS FETCH NEXT 15 ROWS ONLY
Cavo Allarme schermato LSZH Blu 2x0.22+2x0.50+T+S Termoretratto BB500mSIC22ENH-WR500 Cavo per impianto antintrusione con guaina in LSZH Norme di riferimento CEI UNEL 36762 Formazione 2x0222x050TS mmq Diametro esterno mm 420 Materiale Guaina Duraflam LSZH BB500m...Dettagli
Cavo Coassiale 75 Ohm per segnale TV. Guaina LSZH nera. Cl. Cca.Ter.100mTRI6CNH-SF100 Cavo Coassiale 75 Ohm per segnale TV Guaina LSZH nera Cl CcaTer100m...Dettagli
Cavo Coassiale 75 Ohm per segnale TV. Guaina LSZH nera. Cl. Cca.Ter.250mTRI6CNH-SF250 Cavo Coassiale 75 Ohm per segnale TV Guaina LSZH nera Cl CcaTer250m...Dettagli
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