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 165 ROWS FETCH NEXT 15 ROWS ONLY
O-Ring for AFS 35 (50pcs)O-RINGVE50 ORing for AFS 35 50pcs...Dettagli
Sampling point T-piece, Ø 32 mm, set, for concrete insertSP32CT Sampling point Tpiece 32 mm set for concrete insert...Dettagli
Compressed-air connection, Ø 25 mm, ABSCC25ABS Compressedair connection 25 mm ABS...Dettagli
Repl filter mat 5pcs, FBL 25 PC EFMFBL25PCEFM Repl filter mat 5pcs FBL 25 PC EFM...Dettagli
Heat resistor for RAS 52B, Heat ResistorHEATRESISTOR Heat resistor for RAS 52B Heat Resistor...Dettagli
Serial Master Module for RS 485 networking of Special Fire DetectorsSMM535 Dettagli
Cable Connection Fitting Ø 25 mm, ABS (Set)CCF25ABS Cable Connection Fitting 25 mm ABS Set...Dettagli
Main board for ASD 535-4 HD coatedAMB35-2CP Main board for ASD 5354 HD coated...Dettagli
M20 Cable Screw Union 10pcs in bagM20VE10 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
M25 Cable Screw Union 10pcs in bagM25VE10 Dettagli
Dongle for Securiton Applications (without license) Pack of 10ULM-DP10 Dongle for Securiton Applications without license Pack of 10...Dettagli
Dongle for Securiton Applications (without license) Pack of 5ULM-DP5 Dongle for Securiton Applications without license Pack of 5...Dettagli
Sampling point with heating ABS (Set) Ø 3,0 mm redHEAT3.0ABS Sampling point with heating ABS Set 30 mm red...Dettagli