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
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
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