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
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
Wiring Connection Unit 25, WCU 535 PCWCU535PC Wiring Connection Unit 25 WCU 535 PC...Dettagli
ASD Config Networking to configure and visualizeLICASDNET Dettagli
Pipe clamp grey 100pcs, PC 25 PVCPC25PVC Pipe clamp grey 100pcs PC 25 PVC...Dettagli
T-piece, Ø 22 mm, stainless steelTP22STSTEEL Tpiece 22 mm stainless steel...Dettagli
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 533, 0.02% Obs./m (main alrm thresh.)SSD533 Smoke Sensing Device for ASD 533 002 Obsm main alrm thresh...Dettagli
Bend 90°, Ø 22 mm, stainless steelBE22STSTEEL Bend 90 22 mm stainless steel...Dettagli
Power supply 24V/1A EN54, STX2401-C-SECSTX2401-C-SEC Power supply 24V1A EN54 STX2401CSEC...Dettagli
Smoke Sensing Device for REK 511, 0.3% Obs./mSSD515-3S Smoke Sensing Device for REK 511 03 Obsm...Dettagli
Smoke Sensing Device for REK 511, 1.2% Obs./mSSD515-1S Smoke Sensing Device for REK 511 12 Obsm...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