Tire valves

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

TypeASTTipo_valv

select distinct a5 from [dbo].[nccat4_xcattab_accvalvole] 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_VALV' ORDER BY a5

MaterialASTMateriale_valv

select distinct a6 from [dbo].[nccat4_xcattab_accvalvole] 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_VALV' ORDER BY a6

ColorASTColore_valv

Order by
Show per page

found: 12

Material
Nickel plated brass
Color
Silver
20,13 €
Available
Material
Aluminum
Color
Silver
7,62 €
Available
Material
EPDM rubber
Color
Black
1,52 €
Available
Material
EPDM rubber
Color
Black
1,89 €
Available
Material
Nickel plated brass
Color
Silver
3,04 €
Available
Material
Nickel plated brass
Color
Black
3,04 €
Available
Material
Anodized aluminum
Color
Gold
0,60 €
Available
Material
Anodized aluminum
Color
Silver
0,60 €
Available
Material
Anodized aluminum
Color
Red
0,60 €
Available
Material
Anodized aluminum
Color
Black
0,60 €
Available