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 = '05 ' AND I.SBFAM = '080 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '05 ' AND SBFAM = '080 ')) ORDER BY I.Seq OFFSET 315 ROWS FETCH NEXT 15 ROWS ONLY
Porta finestra anteriore (rack 30 U)P5730 Porta finestra anteriore rack 30 U...Dettagli
Porta finestra anteriore (rack 36 U)P5736-L Porta finestra anteriore rack 36 U...Dettagli
Porta finestra anteriore (rack 40 U)P5740 Porta finestra anteriore rack 40 U...Dettagli
Sistema integrato di evacuazione vocale da parete, 6 amplificatori da 25PAW5506-V Sistema integrato di evacuazione vocale da parete 6 amplificatori da 250 W per un totale utilizzabile di 500 W 6 zone microfono emergenza lettore USBSD card 8 messaggi certificato EN 5416 e EN 544...Dettagli