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 (catalogue_vshop.Niveau1 = 'CATEGORIES' ) and (catalogue_vshop.Niveau2 = 'CHAUSSURES' ) 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;

CHAUSSURES 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 €

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 €

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 €

36 | 37 | 38 | 39

veja

v10 x flaneurz white nautico pekin

475,00 €

40 | 41

veja

baskets v10 bastille mat sable

72,50 €

145,00 €

36 | 37 | 39

avril gau

sandales a talons cat desert

108,00 €

270,00 €

36 | 37 | 38

avril gau

sandales cacid desert

118,00 €

295,00 €

36 | 40

avril gau

sandales cacid noir

118,00 €

295,00 €

36

avril gau

sandales a talons coquille desert

98,00 €

245,00 €

37

avril gau

mules caris cognac

157,50 €

225,00 €

36 | 37 | 38 | 39 | 40

veja

3 lock glitter white neon pierre

110,00 €

37 | 38 | 39 | 40 | 41

veja

esplar 3 lock metal gold pierre

110,00 €

36 | 37 | 39 | 40 | 41

veja

basket 3 lock black black

110,00 €

36 | 37 | 38 | 39 | 40

veja

basket 3 lock extra white

110,00 €

40 | 41

veja

baskets wata black pierre

75,00 €

37 | 38 | 39 | 40 | 41

veja

baskets wata marsala pierre

75,00 €

36 | 37 | 38 | 40 | 41

veja

baskets wata natural pierre

75,00 €

36 | 37 | 38 | 40 | 41

veja

baskets wata white pierre

75,00 €

36 | 39

michel vivien

sandales trapani nero

192,00 €

480,00 €

36 | 37 | 38 | 39 | 40 | 41

veja

baskets esplar soie gold

87,00 €

145,00 €

36 | 37 | 38 | 40

veja

baskets esplar soie quartz

87,00 €

145,00 €

36 | 39 | 40 | 41

veja

baskets holiday soie gold

87,00 €

145,00 €

36 | 37 | 38 | 39 | 40

veja

baskets holiday soie quartz

87,00 €

145,00 €

36 | 37

veja

holiday bastille perf virgin

101,50 €

145,00 €

41

birkenstock

arizona metallic copper

80,00 €

100,00 €

35 | 37 | 41

birkenstock

arizona metallic silver

80,00 €

100,00 €

35 | 36 | 37 | 38

birkenstock

sandales arizona birko noir

64,00 €

80,00 €

36 | 37 | 38

birkenstock

sandale arizona velours velours taupe

76,00 €

95,00 €

36 | 37 | 37.5 | 38 | 38.5 | 39 | 39.5

michel vivien

boots karluz noir

665,00 €

36 | 37 | 37.5 | 38 | 38.5 | 39

michel vivien

boots karluz petalo

665,00 €

6ejtb51ai5jz7hc - execution time: 1.062 sec.