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 135 ROWS FETCH NEXT 15 ROWS ONLY
Fastener plate to cover a smoke sensor chamber (50 pcs.)ASD535VERSCHL Fastener plate to cover a smoke sensor chamber 50 pcs...Dettagli
Socket, Ø 22 mm, stainless steelSO22STSTEEL Socket 22 mm stainless steel...Dettagli
Smoke Sensing Device for ASD 535, 0.02% Obs./m (main alrm thresh.) coateSSD535-3CP Smoke Sensing Device for ASD 535 002 Obsm main alrm thresh coate...Dettagli
Sampling point with heating ABS (Set) Ø 3,5 mm blueHEAT3.5ABS Sampling point with heating ABS Set 35 mm blue...Dettagli
Silicon litz wire 0,5 mm2, black (roll with 100m)SLW0.5BK Silicon litz wire 05 mm2 black roll with 100m...Dettagli
Main board for ASD 535-3 HD coatedAMB35-1CP Main board for ASD 5353 HD coated...Dettagli
Aspirating Smoke Detector, 1 sampling pipe, Heavy Duty versionASD535-3HD Aspirating Smoke Detector 1 sampling pipe Heavy Duty version...Dettagli