select catalogue_vshop.Produit,
catalogue_vshop.BarCode,
catalogue_vshop.Couleur,
catalogue_vshop.CouleurLangue,
catalogue_vshop.Designation,
catalogue_vshop.Marque,
catalogue_vshop.Prix,
catalogue_vshop.PrixRemise,
catalogue_vshop.Remise,
catalogue_vshop.Descriptif,
group_concat( replace(catalogue_vshop.TailleLangue, ',','.') order by catalogue_vshop.TailleLangue) as Tailles,
group_concat(catalogue_vshop.Stock order by catalogue_vshop.TailleLangue) as Stocks,
catalogue_vshop.Niveau0,
catalogue_vshop.Niveau1,
catalogue_vshop.Niveau2,
catalogue_vshop.URL
from catalogue_vshop
left outer join web_tridesmarques wt on ( UPPER(wt.Niveau0) = catalogue_vshop.Niveau0 and UPPER(wt.categories) = catalogue_vshop.Niveau2 )
Where (catalogue_vshop.Site = 'VEJA3') and (catalogue_vshop.langue='FR') and (catalogue_vshop.visiblecatalogue=1) And (catalogue_vshop.Niveau0='HOMME') and (catalogue_vshop.Niveau1 = 'CATEGORIES' ) and (catalogue_vshop.Niveau2 = 'CHEMISES' ) And 1

group by catalogue_vshop.BarCode, catalogue_vshop.Couleur
order by catalogue_vshop.OrdreTriVshop desc, catalogue_vshop.marque, catalogue_vshop.BarCode, catalogue_vshop.CouleurLangue
limit 0, 40;

CHEMISES HOMME | CENTRE COMMERCIAL

S | M | L | XL

ymc

chemise curtis black

120,00 €

S | M | L | XL

ymc

chemise curtis olive

120,00 €

S | M | L | XL

ymc

chemise beach black

175,00 €

M | L

ymc

chemise beach olive

175,00 €

M | L

ymc

chemise doc savage navy

205,00 €

S | M

coltesse

chemise hydrus black

160,00 €

S | M | L

coltesse

chemise hydrus black and white

160,00 €

XS | S | M | L | XL

drapeau noir

chemise denim slub navy

130,00 €

S | M | L | XL

drapeau noir

chemise japanese denim denim blue

170,00 €

XS | S | M | L | XL

drapeau noir

chemise tokyo brush gold

120,00 €

XS | S | M | L

drapeau noir

chemise vintage wash dark olive

120,00 €

XS | S | M | L | XL

drapeau noir

chemise vintage wash gold

120,00 €

XS | S | M | L | XL

drapeau noir

chemise flannelle beige

120,00 €

XS | S | M | L

drapeau noir

chemise oxford brush blue

130,00 €

XS | S | M | L | XL

drapeau noir

chemise reverse indigo

130,00 €

39 | 40 | 41

ami, alexandre mattiussi

chemise patch 'a' jaune

185,00 €

XS | M | L

ami, alexandre mattiussi

chemise col boutonne indigo

215,00 €

48 | 50

tres bien

chemise button down corduroy beige

180,00 €

48 | 50

tres bien

chemise button down corduroy wine

180,00 €

S | M | L | XL

naked and famous

chemise regular corduroy white

130,00 €

S | M | L | XL

naked and famous

chemise regular shadow brushed red

150,00 €

S | M | XL

officine generale

chemise lipp stitch brush tw faded olive

165,00 €

L

officine generale

chemise lipp stitch brush tw woodrose

165,00 €

S | M | L | XL

officine generale

chemise antime black

195,00 €

S | M | L | XL

officine generale

chemise antime ecru

195,00 €

S | L | XL

officine generale

chemise antime grey

195,00 €

XS | S | M | L | XL

norse projects

chemise hans mouline dried olive

130,00 €

XS | S | L | XL

norse projects

chemise anton carreaux light grey melange

120,00 €

M | L

knowledge cotton apparel

chemise twill col mao 1148 raw cotton

95,00 €

XS | S | M | L | XL

knowledge cotton apparel

chemise twill raw 1148 raw cotton

95,00 €

XS | S | M | L | XL

knowledge cotton apparel

chemise flanelle 1073 dark grey melan

95,00 €

XS | S | M | L | XL

knowledge cotton apparel

chemise flanelle 1104 madder brown

95,00 €

XS | M | L | XL

knowledge cotton apparel

chemise flanelle 1207 green gables

95,00 €

S | M | L

a kind of guise

chemise ochiba off white

160,00 €

L

a kind of guise

chemise goromo rose

170,00 €

M

bleu de paname

chemise fatigue indigo

140,00 €

S | M | L

knowledge cotton apparel

chemise baby cord peacoat

95,00 €

L | XL

knowledge cotton apparel

chemise longue bright white

80,00 €

M | L | XL

norse projects

chemise anton chambray light indigo

130,00 €

XS | S | L | XL

bleu de paname

chemise standard denim indigo

105,00 €

f85vgigbqmi530 - execution time: 0.547 sec.