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 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '03 ')) ORDER BY I.Seq OFFSET 1170 ROWS FETCH NEXT 15 ROWS ONLY
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
Protective Carrying / Storage Bag for Solo 365SOLO611 Protective Carrying Storage Bag for Solo 365...Dettagli
Loop I/F for Special Fire Detectors (SecuriLine eXtended)XLM35 Loop IF for Special Fire Detectors SecuriLine eXtended...Dettagli
Smoke Cartridge for Solo 365 (12 pcs)ES3VE12 Smoke Cartridge for Solo 365 12 pcs...Dettagli
Air cooler and water collector ABS/CuLK35-ABS Air cooler and water collector ABSCu...Dettagli
Lithium Ion Battery Pack for Solo 365SOLO370 Dettagli
Basic control board for advanced display of ASD 535-3 and -4ACB35 Basic control board for advanced display of ASD 5353 and 4...Dettagli
Automatic blow out device, Ø 25 mm, for one sampling pipeADB1000 Automatic blow out device 25 mm for one sampling pipe...Dettagli
Holder for Filter-Mat XHOLDERFILTER-MATX Holder for FilterMat X...Dettagli
Automatic blow out device, Ø 25 mm, for two sampling pipesADB2000 Automatic blow out device 25 mm for two sampling pipes...Dettagli