Home Bolts & nuts Lug nuts

Lug nuts

select distinct a1 from [dbo].[nccat4_xcattab_bulloneria] 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_DADI' ORDER BY a1

TypeASTCategoriab

select distinct a2 from [dbo].[nccat4_xcattab_bulloneria] 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_DADI' ORDER BY a2

ThreadASTFilettoxpasso

select distinct cast(a4 as float) from [dbo].[nccat4_xcattab_bulloneria] 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(a4,'')<>'' and p.type=0 AND g.mnu='MENU2_DADI' ORDER BY cast(a4 as float)

Length (mm)ASTLunghezza

select distinct cast(a6 as float) from [dbo].[nccat4_xcattab_bulloneria] 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_DADI' ORDER BY cast(a6 as float)

KeyASTChiave

select distinct a8 from [dbo].[nccat4_xcattab_bulloneria] 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(a8,'')<>'' and p.type=0 AND g.mnu='MENU2_DADI' ORDER BY a8

FinishASTFinitura

select distinct cast(a9 as float) from [dbo].[nccat4_xcattab_bulloneria] 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(a9,'')<>'' and p.type=0 AND g.mnu='MENU2_DADI' ORDER BY cast(a9 as float)

Weight (gr)ASTPeso viti

Order by
Show per page

found: 58

Type
60° tapered lug nut
Thread
M12x1.5
Length (mm)
25
Key
19
Finish
White zinc
Weight (gr)
43
1,52 €
Available
Type
60° tapered lug nut
Thread
M12x1.5
Length (mm)
25
Key
19
Finish
Black zinc
Weight (gr)
43
2,07 €
Available
Type
60° tapered lug nut
Thread
M12x1.5
Length (mm)
25
Key
19
Finish
Coppered
Weight (gr)
43
3,78 €
Available
Type
60° tapered lug nut
Thread
M12x1.25
Length (mm)
25
Key
19
Finish
White zinc
Weight (gr)
43
1,52 €
Available
Type
60° tapered lug nut
Thread
M12x1.25
Length (mm)
25
Key
19
Finish
Black zinc
Weight (gr)
43
2,07 €
Available
Type
60° tapered lug nut
Thread
M12x1.25
Length (mm)
25
Key
19
Finish
Coppered
Weight (gr)
43
3,78 €
Available
Type
Flat lug nut
Thread
M16x1.5
Length (mm)
51.5
Key
27
Finish
White zinc
Weight (gr)
212
7,19 €
Available
Type
60° tapered lug nut
Thread
M12x1.25
Length (mm)
34
Key
19
Finish
White zinc
Weight (gr)
60
1,58 €
Available
Type
60° tapered lug nut
Thread
M12x1.25
Length (mm)
34
Key
19
Finish
Black zinc
Weight (gr)
60
2,13 €
Available
Type
60° tapered lug nut
Thread
M12x1.5
Length (mm)
34
Key
19
Finish
White zinc
Weight (gr)
60
1,58 €
Available