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 90 ROWS FETCH NEXT 15 ROWS ONLY
Cavo Video HD 75Ohm coax+2x2.50, C4, LSZH Blu, Bobina 500mHD4225-WR500 Cavo coassiale ibrido per videosorveglianza Norme di riferimento CEI EN 50117 Formazione coax2x250mmq Diametro esterno mm850 Trasmissione segnale video analogico m 400 Trasmissione segnale video HDSDIm70 Bobina 500m...Dettagli
Cavo Allarme schermato LSZH Blu 14x0.22+2x0.50+T+S Bobina 500mSIC-EL214-WR500 Cavo per impianto antintrusione con guaina in LSZH Norme di riferimento CEI UNEL 36762 Formazione 14x0222x050TS mmq Diametro esterno mm 630 Materiale Guaina Duraflam LSZH Bobina 500m...Dettagli
MONOMODALE 24 FIBRE LSZH Cca s1b d1 a1 WR2000L-OS2-024C-WR2000 MONOMODALE 24 FIBRE LSZH Cca s1b d1 a1 WR2000 OFCLOS2024CWR2000...Dettagli