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
Aspirating Smoke Detector, 2 sampling pipe, Heavy Duty versionASD535-4HD Aspirating Smoke Detector 2 sampling pipe Heavy Duty version...Dettagli
Sampling point with heating ABS (Set) Ø 4,0 mm greenHEAT4.0ABS Sampling point with heating ABS Set 40 mm green...Dettagli
Memory card module for ASD 535,with memory cardMCM35 Memory card module for ASD 535with memory card...Dettagli
Sampling point with heating ABS (Set) Ø 4,5 mm blackHEAT4.5ABS Sampling point with heating ABS Set 45 mm black...Dettagli
Serial I/F Module for RS 485 networking of Special Fire DetectorsSIM35 Serial IF Module for RS 485 networking of Special Fire Detectors...Dettagli
Electronic Smoke Detector (incl. battery, smoke generator and charger)SOLO365 Electronic Smoke Detector incl battery smoke generator and charger...Dettagli
Universal module support for Special Fire DetectorsUMS35 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
Flex tube 21,2mm PA black 50m, FT 21 PAFT21PA Flex tube 212mm PA black 50m FT 21 PA...Dettagli
Screw-junction piece d=25mm, ABS red (10pcs)SJ25ABSRED Screwjunction piece d25mm ABS red 10pcs...Dettagli