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 ' AND I.SBFAM = '052 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '06 ' AND SBFAM = '052 ')) ORDER BY I.Seq OFFSET 525 ROWS FETCH NEXT 15 ROWS ONLY
Adattatore da condotta (sez. rettangolare). Per riv.con testa ?corpo 3?STGAD.COND Adattatore da condotta sez rettangolare Per rivcon testa “corpo 3”...Dettagli
Rivelatore GPL 4-20 mA, 0-100%LFLS4590GP Rivelatore GPL 420 mA 0100LFL...Dettagli
Rivelatore R1234ZE soglie di allarme impostate a 1000 & 2000 ppmS4673R1234ZE Rivelatore R1234ZE soglie di allarme impostate a 1000 2000 ppm...Dettagli
Rivelatore BUTANO 4-20 mA, 0-100%LFLS4590BU Rivelatore BUTANO 420 mA 0100LFL...Dettagli
Rivelatore R454A soglie di allarme impostate a 5% & 10% LFLS4680R454A Rivelatore R454A soglie di allarme impostate a 5 10 LFL...Dettagli