Home Bolts & nuts Lug bolts

Lug bolts

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_VITI' 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_VITI' ORDER BY a2

ThreadASTFilettoxpasso

select distinct a3 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(a3,'')<>'' and p.type=0 AND g.mnu='MENU2_VITI' ORDER BY a3

Root threadASTFilettoxpasso_rad

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_VITI' ORDER BY cast(a4 as float)

Length (mm)ASTLunghezza

select distinct a5 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(a5,'')<>'' and p.type=0 AND g.mnu='MENU2_VITI' ORDER BY a5

Dimensione 2ASTDimensione 2

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_VITI' ORDER BY cast(a6 as float)

KeyASTChiave

select distinct cast(a7 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(a7,'')<>'' and p.type=0 AND g.mnu='MENU2_VITI' ORDER BY cast(a7 as float)

Knurl diameter (mm)ASTDametro_zigr

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_VITI' 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_VITI' ORDER BY cast(a9 as float)

Weight (gr)ASTPeso viti

select distinct a10 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(a10,'')<>'' and p.type=0 AND g.mnu='MENU2_VITI' ORDER BY a10

NoteASTNote

Order by
Show per page

found: 22

Type
Lug bolt
Thread
M14x1.5
Root thread
[ASTFilettoxpasso_rad] value= title lang not found
Length (mm)
30
Dimensione 2
54 (totale)
Key
19
Knurl diameter (mm)
Finish
White zinc
Weight (gr)
80
Note
0,00 €
Available
Type
Lug bolt
Thread
M12x1.5
Root thread
[ASTFilettoxpasso_rad] value= title lang not found
Length (mm)
30
Dimensione 2
55,5 (totale)
Key
17
Knurl diameter (mm)
Finish
White zinc
Weight (gr)
70
Note
0,00 €
Available
Type
Lug bolt
Thread
M12x1.5
Root thread
[ASTFilettoxpasso_rad] value= title lang not found
Length (mm)
30
Dimensione 2
55,5 (totale)
Key
17
Knurl diameter (mm)
Finish
White zinc
Weight (gr)
70
Note
0,00 €
Available
Type
Lug bolt
Thread
M12x1.25
Root thread
[ASTFilettoxpasso_rad] value= title lang not found
Length (mm)
32
Dimensione 2
57 (totale)
Key
19
Knurl diameter (mm)
Finish
White zinc
Weight (gr)
70
Note
0,00 €
Available
Type
Lug bolt
Thread
M12x1.25
Root thread
[ASTFilettoxpasso_rad] value= title lang not found
Length (mm)
30
Dimensione 2
54 (totale)
Key
17
Knurl diameter (mm)
Finish
White zinc
Weight (gr)
75
Note
0,00 €
Available
Type
Lug bolt
Thread
M12x1.25
Root thread
[ASTFilettoxpasso_rad] value= title lang not found
Length (mm)
30
Dimensione 2
54 (totale)
Key
17
Knurl diameter (mm)
Finish
Black zinc
Weight (gr)
75
Note
0,00 €
Available
Type
Lug bolt
Thread
M14x1.5
Root thread
[ASTFilettoxpasso_rad] value= title lang not found
Length (mm)
30
Dimensione 2
53,5 (totale)
Key
17
Knurl diameter (mm)
Finish
White zinc
Weight (gr)
75
Note
0,00 €
Available
Type
Lug bolt
Thread
M14x1.5
Root thread
[ASTFilettoxpasso_rad] value= title lang not found
Length (mm)
30
Dimensione 2
53,5 (totale)
Key
17
Knurl diameter (mm)
Finish
Black zinc
Weight (gr)
75
Note
0,00 €
Available
Type
Lug bolt
Thread
M14x1.25
Root thread
[ASTFilettoxpasso_rad] value= title lang not found
Length (mm)
27
Dimensione 2
51 (totale)
Key
17
Knurl diameter (mm)
Finish
White zinc
Weight (gr)
75
Note
0,00 €
Available
Type
Lug bolt
Thread
M14x1.25
Root thread
[ASTFilettoxpasso_rad] value= title lang not found
Length (mm)
27
Dimensione 2
51 (totale)
Key
17
Knurl diameter (mm)
Finish
Black zinc
Weight (gr)
75
Note
0,00 €
Available