Apparel

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

SizeASTTaglia_abb

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

ColorASTColore_abb

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

ModelASTModello_abb

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

Item of clothingASTTipologia_abb

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

GenderASTGenere_abb

Order by
Show per page

found: 38

Size
XL
Color
White
Model
Cambridge
Item of clothing
Polo-shirt
Gender
Man
25,00 € -20%
20,00 €
Sold out
Size
M
Color
Grey
Model
Melbourne
Item of clothing
Sweatshirt
Gender
Lady
47,57 €
Available
Size
S
Color
Grey
Model
Melbourne
Item of clothing
Sweatshirt
Gender
Lady
47,57 €
Available
Size
M
Color
Black
Model
Memphis
Item of clothing
Polo-shirt
Gender
Lady
25,00 €
Available
Size
M
Color
Blue
Model
Memphis
Item of clothing
Polo-shirt
Gender
Lady
25,00 €
Available
Size
S
Color
Black
Model
Memphis
Item of clothing
Polo-shirt
Gender
Lady
25,00 €
Available
Size
S
Color
Blue
Model
Memphis
Item of clothing
Polo-shirt
Gender
Lady
25,00 €
Available
Size
L
Color
Black
Model
Memphis
Item of clothing
Polo-shirt
Gender
Man
25,00 €
Available
Size
M
Color
Black
Model
Memphis
Item of clothing
Polo-shirt
Gender
Man
25,00 €
Available
Size
XL
Color
Black
Model
Memphis
Item of clothing
Polo-shirt
Gender
Man
25,00 €
Sold out