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 = '041 ' AND I.GRP = '041208 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '03 ' AND SBFAM = '041 ' AND GRP = '041208 ')) ORDER BY I.Seq OFFSET 135 ROWS FETCH NEXT 15 ROWS ONLY
Scheda Madre Fc520 - Ricambio -B055-2 Scheda Madre Fc520 Ricambio ...Dettagli
FC MAE - Software per il controllo remoto di centrali della serie FC500557.202.726 FC MAE Software per il controllo remoto di centrali della serie FC500...Dettagli
FC410DIM Modulo d'ingresso per rivelatori convenzionali555.800.712 FC410DIM Modulo dingresso per rivelatori convenzionali...Dettagli
FC410BDM Modulo per gestione sul loop dei rivelatori lineari di fumo555.800.766 Dettagli