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 = '096 ' AND I.GRP = '09603 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '03 ' AND SBFAM = '096 ' AND GRP = '09603 ')) ORDER BY I.Seq OFFSET 0 ROWS FETCH NEXT 15 ROWS ONLY
Pulsante manuale antincendio via radio Rosso (60815.171.NC1)AJEN54FMCPR Pulsante manuale antincendio via radio Rosso...Dettagli
Pulsante manuale antincendio via radio Rosso (60815.171.NC1)
AJEN54FMCPR
Pulsante manuale antincendio via radio Rosso...
Dettagli
Videosorveglianza
Antintrusione
Antincendio
Rilevazione Gas
Diffusione sonora
Controllo accessi