Home Accessories and spare parts Warehouse accessories

Warehouse accessories

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

TypeASTTipologia_mag

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

DiameterASTDiametro_mag

select distinct a3 from [dbo].[nccat4_xcattab_accmagazzino] 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_GAR' ORDER BY a3

ColorASTColore_mag

select distinct a4 from [dbo].[nccat4_xcattab_accmagazzino] 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_GAR' ORDER BY a4

MaterialASTMateriale-mag

Order by
Show per page

found: 10

Diameter
18"
Color
Orange
Material
Ecological polyethylene
5,61 €
Available
Diameter
13"
Color
Brown
Material
Ecological polyethylene
4,75 €
Available
Diameter
14"
Color
White
Material
Ecological polyethylene
4,75 €
Available
Diameter
15"
Color
Yellow
Material
Ecological polyethylene
4,75 €
Available
Diameter
16"
Color
Green
Material
Ecological polyethylene
5,61 €
Available
Diameter
17"
Color
Blue
Material
Ecological polyethylene
5,61 €
Available
Diameter
19"
Color
Red
Material
Ecological polyethylene
7,19 €
Available
Diameter
20"
Color
Brown
Material
Ecological polyethylene
7,19 €
Available
Diameter
21"
Color
Black
Material
Ecological polyethylene
7,19 €
Available

Tire trolley

CM0821260000
Diameter
69 cm
Color
Black
Material
Plastic
71,98 €
Available