Home Accessori e ricambi Accessori magazzino

Accessori magazzino

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

TipologiaASTTipologia_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

DiametroASTDiametro_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

ColoreASTColore_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

MaterialeASTMateriale-mag

Ordina per
Mostra per pagina

trovati: 14

Diametro
18"
Colore
Arancione
Materiale
Polietilene ecologico
7,56 €
Disponibile
Diametro
13"
Colore
Marrone
Materiale
Polietilene ecologico
6,46 €
Disponibile
Diametro
14"
Colore
Bianco
Materiale
Polietilene ecologico
6,46 €
Disponibile
Diametro
15"
Colore
Giallo
Materiale
Polietilene ecologico
6,46 €
Disponibile
Diametro
16"
Colore
Verde
Materiale
Polietilene ecologico
7,56 €
Disponibile
Diametro
17"
Colore
Blu
Materiale
Polietilene ecologico
7,56 €
Disponibile
Diametro
19"
Colore
Rosso
Materiale
Polietilene ecologico
9,39 €
Disponibile
Diametro
20"
Colore
Marrone
Materiale
Polietilene ecologico
9,39 €
Disponibile
Diametro
21"
Colore
Nero
Materiale
Polietilene ecologico
9,39 €
Disponibile

Carrello porta ruote

CM0821260000
Diametro
69 cm
Colore
Nero
Materiale
Plastica
84,17 €
Disponibile