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 = '06 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '06 ')) ORDER BY I.Seq OFFSET 1140 ROWS FETCH NEXT 15 ROWS ONLY
Trasmettitore 4-20mA pellistor IP65 per vapori di benzinaTS282PB Trasmettitore 420mA pellistor IP65 per vapori di benzina...Dettagli
Valvola con flussometro per cartucce monousoPCVALVOLA Dettagli
Videosorveglianza
Antintrusione
Antincendio
Rilevazione Gas
Diffusione sonora
Controllo accessi