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
Rivelatore ACETATO DI VINILE, 4-20 mA, 0-100% LFLS2155AV-LD Rivelatore ACETATO DI VINILE 420 mA 0100 LFL...Dettagli
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 R1234yf soglie di allarme impostate a 1000 & 2000 ppmS3857R1234YF Rivelatore R1234yf soglie di allarme impostate a 1000 2000 ppm...Dettagli
Rivelatore R454A soglie di allarme impostate a 5% & 10% LFLS4680R454A Rivelatore R454A soglie di allarme impostate a 5 10 LFL...Dettagli