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 = '040101 ' AND I.SBGRP = '040101157 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '03 ' AND SBFAM = '040 ' AND GRP = '040101 ' AND SBGRP = '040101157 ')) ORDER BY I.Seq OFFSET 30 ROWS FETCH NEXT 15 ROWS ONLY
Base con buzzer per rivelatori convenzionali ed indirizzatiEB0060 Base con buzzer per rivelatori convenzionali IRIS ed indirizzati ENEA...Dettagli