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.EnNouveaute=1) And 1

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

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

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 €

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 €

40 | 41

veja

baskets v10 bastille mat sable

72,50 €

145,00 €

XS | S | M | L

maison labiche

t shirt amour blanc

55,00 €

XS | M

maison labiche

t shirt follow me blanc

55,00 €

L

maison labiche

t shirt follow me gris chine

55,00 €

M | L

maison labiche

sweatshirt boys don t cry neige

38,00 €

95,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 €

f85aws80szo2ms - execution time: 0.375 sec.