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 = '03 ' AND I.SBFAM = '040 ' AND I.GRP = '040206 ' AND I.SBGRP = '040206205 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '03 ' AND SBFAM = '040 ' AND GRP = '040206 ' AND SBGRP = '040206205 ')) ORDER BY I.Seq OFFSET 15 ROWS FETCH NEXT 15 ROWS ONLY
Pulsante di allarme convenzionale con elemento in vetro (senza scatola p2501012 Pulsante di allarme convenzionale con elemento in vetro senza scatola posteriore...Dettagli
Pulsante di allarme convenzionale con elemento in vetro (senza scatola p2501013 Pulsante di allarme convenzionale con elemento in vetro senza scatola posteriore...Dettagli