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)) ORDER BY I.Seq OFFSET 17145 ROWS FETCH NEXT 15 ROWS ONLY
Cavo Coax 4019+2x1,50 10,80 mm Armato antiroditore WR1000HD4215FPEARM-WR1000 Cavo Coax 40192x150 1080 mm Armato antiroditore WR1000...Dettagli
Cavo Coax 4019+2x1,50 10,80 mm Armato antiroditore WR500HD4215FPEARM-WR500 Cavo Coax 40192x150 1080 mm Armato antiroditore WR500...Dettagli
Cavo KNX Armato PE 2x2x0,80+T+S SF100KNX2280FPEARM-SF100 Cavo KNX Armato PE 2x2x080TS SF100 950mm...Dettagli
Cavo KNX Armato PE 2x2x0,80+T+S WR1000KNX2280FPEARM-WR1000 Cavo KNX Armato PE 2x2x080TS WR1000 950mm...Dettagli
Cavo KNX Armato PE 2x2x0,80+T+S WR500KNX2280FPEARM-WR500 Cavo KNX Armato PE 2x2x080TS WR500 950mm...Dettagli
Cavo U/UTP cat 5e armato antiroditore , LSZH PE nero, Bobina da 1000mBNUU5E-F-ARM-WR1000 Cavo U/UTP cat 5e armato antiroditore , LSZH PE nero, Bobina da 1000m ...Dettagli
2 X 1,50 11,00 mm Duraflam
LSZH Rosso B2ca s1a d1 a1 bobina da mt. 500FRHRR2150BNHARM-WR500 2 X 1,50 11,00 mm Duraflam
LSZH Rosso B2ca s1a d1 a1 bobina da mt. 500 ...Dettagli
2 X 2,50 12,50 mm Duraflam LSZH Rosso B2ca s1a d1 a1 termoretratto da mt. 100FRHRR2250BNHARM-SF100 2 X 2,50 12,50 mm Duraflam LSZH Rosso B2ca s1a d1 a1 termoretratto da mt. 100 ...Dettagli
2 X 2,50 12,50 mm Duraflam LSZH Rosso B2ca s1a d1 a1 bobina da mt. 500FRHRR2250BNHARM-WR500 2 X 2,50 12,50 mm Duraflam LSZH Rosso B2ca s1a d1 a1 bobina da mt. 500 ...Dettagli