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 270 ROWS FETCH NEXT 15 ROWS ONLY
Porta finestra anteriore (rack 12 U)P5712 Porta finestra anteriore rack 12 U...Dettagli
Porta finestra anteriore (rack 16 U)P5716 Porta finestra anteriore rack 16 U...Dettagli
Porta finestra anteriore (rack 20 U)P5720 Porta finestra anteriore rack 20 U...Dettagli
Porta finestra anteriore (rack 24 U)P5724 Porta finestra anteriore rack 24 U...Dettagli
Porta finestra anteriore (rack 28 U)P5728-L Porta finestra anteriore rack 28 U...Dettagli
Colonna sonora da 120 W, IP55, nera, certificato EN 54-24C6120N-EN Colonna sonora da 120 W IP55 nera certificato EN 5424...Dettagli
Colonna sonora in alluminio da 100 W (6 Wf + 4 Tw), EN 54-24C7200-EN Colonna sonora in alluminio da 100 W 6 Wf 4 Tw EN 5424...Dettagli
Proiettore bi-direzionale, alluminio, 10+10 W, IP65, EN 54-24C86/20-2EN Proiettore bidirezionale alluminio 1010 W IP65 EN 5424...Dettagli