Home Bolts & nuts Hub centric rings

Hub centric rings

select distinct cast(a1 as float) from [dbo].[nccat4_xcattab_accessori] x inner join [dbo].[nccat4_Product] p on p.code=x.code inner join [dbo].[nccat4_xcattab_global] g on g.code=p.code left outer join nccat4_stock s on s.code=p.code where isnull(a1,'')<>'' and p.type=0 AND g.mnu='MENU2_RING' ORDER BY cast(a1 as float)

External diameter (mm)ASTDiam_est

select distinct cast(a2 as float) from [dbo].[nccat4_xcattab_accessori] x inner join [dbo].[nccat4_Product] p on p.code=x.code inner join [dbo].[nccat4_xcattab_global] g on g.code=p.code left outer join nccat4_stock s on s.code=p.code where isnull(a2,'')<>'' and p.type=0 AND g.mnu='MENU2_RING' ORDER BY cast(a2 as float)

Internal diameter (mm)ASTDiam_int

select distinct a3 from [dbo].[nccat4_xcattab_accessori] x inner join [dbo].[nccat4_Product] p on p.code=x.code inner join [dbo].[nccat4_xcattab_global] g on g.code=p.code left outer join nccat4_stock s on s.code=p.code where isnull(a3,'')<>'' and p.type=0 AND g.mnu='MENU2_RING' ORDER BY a3

MaterialASTMateriale_an_centr

select distinct a6 from [dbo].[nccat4_xcattab_accessori] x inner join [dbo].[nccat4_Product] p on p.code=x.code inner join [dbo].[nccat4_xcattab_global] g on g.code=p.code left outer join nccat4_stock s on s.code=p.code where isnull(a6,'')<>'' and p.type=0 AND g.mnu='MENU2_RING' ORDER BY a6

Compatible car manufacturersASTMarche_compat

Order by
Show per page

found: 44

External diameter (mm)
75
Internal diameter (mm)
54.1
Material
Aluminum
Compatible car manufacturers
Toyota, Opel, Suzuki, Kia, Hyundai
4,02 €
Available
External diameter (mm)
75
Internal diameter (mm)
56.1
Material
Anodized aluminum
Compatible car manufacturers
Mini, Honda, Subaru, Mitsubishi, Opel
4,02 €
Available
External diameter (mm)
75
Internal diameter (mm)
56.6
Material
Aluminum
Compatible car manufacturers
Opel, Fiat, Daewoo
4,02 €
Available
External diameter (mm)
75
Internal diameter (mm)
57.1
Material
Anodized aluminum
Compatible car manufacturers
Audi, Volkswagen, Chrysler, BMW, Bentley, Smart
4,02 €
Available
External diameter (mm)
75
Internal diameter (mm)
58.1
Material
Anodized aluminum
Compatible car manufacturers
Alfa Romeo, Lancia, Fiat, Lada Seat
4,02 €
Available
External diameter (mm)
75
Internal diameter (mm)
60.1
Material
Anodized aluminum
Compatible car manufacturers
Renault, Dacia, Toyota, Suzuki, Nissan
4,02 €
Available
External diameter (mm)
75
Internal diameter (mm)
64.1
Material
Anodized aluminum
Compatible car manufacturers
Honda, Rover
4,02 €
Available
External diameter (mm)
75
Internal diameter (mm)
65.1
Material
Anodized aluminum
Compatible car manufacturers
Peugeot, Citroen, Opel, Ford, Volkswagen, Volvo
4,02 €
Available
External diameter (mm)
75
Internal diameter (mm)
67.1
Material
Anodized aluminum
Compatible car manufacturers
Hyundai, Kia, Mitsubishi, Mazda
4,02 €
Available
External diameter (mm)
75
Internal diameter (mm)
63.4
Material
Anodized aluminum
Compatible car manufacturers
Ford, Jaguar, Volvo, Mazda
4,02 €
Available