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 = '048 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '03 ' AND SBFAM = '048 ')) ORDER BY I.Seq OFFSET 105 ROWS FETCH NEXT 15 ROWS ONLY
Smoke sensor for ASD 531, 0.02 - 10%/m (main alarm threshold)SSD31 Smoke sensor for ASD 531 002 10m main alarm threshold...Dettagli
Magnetic filter system 25, MFS 25MFS25 Magnetic filter system 25 MFS 25...Dettagli
Aspirating fan unit for ASD 531/532AFU32 Aspirating fan unit for ASD 531532...Dettagli
Adapter M20, ABS, to self sealing coupling (10 pcs.)AD20ABS Adapter M20 ABS to self sealing coupling 10 pcs...Dettagli