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='FEMME') 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;

VETEMENTS ET ACCESSOIRES FEMME | CENTRE COMMERCIAL

40 | 41

veja

v12 bmesh white emeraude nat s

110,00 €

36 | 38 | 39 | 40 | 41

veja

v12 pixel burgundy

110,00 €

36 | 37 | 38 | 39 | 40 | 41

veja

v12 bastille white marsala nautic

160,00 €

36 | 37 | 38 | 39 | 40 | 41

veja

v10 glitter neon magenta

125,00 €

38

roseanna

manteau chicago conrad fushia

795,00 €

36 | 38

roseanna

robe longue marquise mercy ecru

520,00 €

36 | 38 | 40

roseanna

top marquise drake ecru

310,00 €

S | M

roseanna

pull mohair tyler malabar

235,00 €

S | M

roseanna

pull mohair tyler spritz

235,00 €

36 | 38 | 40

roseanna

chemise harvard avril vert marine

310,00 €

36 | 38

roseanna

robe longue harvard hello vert marine

495,00 €

36 | 38

roseanna

top georgia martial ecru

220,00 €

38

roseanna

top georgia galvin ecru

305,00 €

36/S | 38/M

roseanna

pull col roule basic turtle soleil

285,00 €

36 | 37 | 38 | 39 | 40 | 41

veja

bastille natural sole black nat sole

160,00 €

36 | 37 | 38 | 39 | 40 | 41

veja

bastille natural sole white nat so

160,00 €

10/38 | 12/40

sunspel

t shirt boy fit col rond black

80,00 €

8/36 | 10/38 | 12/40

sunspel

t shirt boy fit col rond grey melange

80,00 €

10/38 | 12/40

sunspel

t shirt boy fit col rond white

80,00 €

10/38

sunspel

t shirt cotele coton et soie black

88,00 €

220,00 €

8/36 | 10/38 | 12/40

sunspel

top sans manches jersey pique navy

68,00 €

170,00 €

12/40

sunspel

top sans manches jersey pique off white

68,00 €

170,00 €

24/30 | 25/30 | 26/30 | 27/30 | 28/30 | 29/30 | 30/30 | 31/30

kings of indigo

jean juno black rinse

99,00 €

S | M

kings of indigo

veste eric mid marble

150,00 €

36

norse projects

pantalon disa black

86,00 €

215,00 €

34 | 36

norse projects

blouse anna en denim pale blue melange

86,00 €

215,00 €

M

maska

pull angela en coton black

140,00 €

XS | M

maska

pull angela en coton white

140,00 €

XS

maska

pull saga lemon

46,00 €

115,00 €

XS

maska

pull saga mint

46,00 €

115,00 €

36 | 37 | 38 | 39 | 40 | 41

veja

baskets v10 suede moonrock

125,00 €

36 | 37 | 40 | 41

veja

baskets v10 suede natural

72,00 €

120,00 €

36 | 37 | 38 | 39 | 40 | 41

veja

baskets v10 black black

125,00 €

36 | 37 | 38 | 39 | 40 | 41

veja

baskets v10 extra white

125,00 €

36 | 37 | 38 | 39 | 40 | 41

veja

baskets v10 silver

125,00 €

36 | 37 | 38 | 39 | 40

veja

baskets v10 white black

125,00 €

36 | 37 | 38 | 39 | 40

veja

baskets v10 white nautico pekin

125,00 €

38

roseanna

pantalon archive charles nuts

340,00 €

f85aws8208i2h8 - execution time: 1.828 sec.