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.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 HOMME | CENTRE COMMERCIAL

40 | 41 | 42 | 43 | 44 | 45

veja

v10 x flaneurz white nautico pekin

475,00 €

40 | 41 | 42 | 43 | 44 | 45 | 46

veja

baskets v10 black black

120,00 €

40 | 41 | 42 | 43 | 44 | 45 | 46

veja

baskets v10 extra white

120,00 €

41 | 42 | 43 | 44 | 45 | 46

veja

baskets v10 white black

120,00 €

40 | 41 | 42 | 43 | 44 | 45 | 46

veja

baskets v10 white nautico pekin

120,00 €

S | M | L | XL

norse projects

surchemise jens garment dyed navy

200,00 €

S | M | L

norse projects

chemise mc anton popeline forest green

115,00 €

M | L

norse projects

chemise mc anton popeline navy

115,00 €

XS | S | M | L | XL

bleu de paname

chemise standard denim indigo

105,00 €

XS | S | M | L | XL

bleu de paname

chemise standard denim stoned

105,00 €

29/32 | 30/32 | 34/34

stan ray

pantalon taper fatigue ripstop navy

95,00 €

29/32 | 30/32 | 31/32 | 32/32 | 33/32 | 34/32

stan ray

pantalon taper fatigue ripstop olive

95,00 €

29 | 31 | 32 | 33 | 34

stan ray

short 4 poches olive

90,00 €

31 | 32

stan ray

short ripstop 4 poches navy

90,00 €

41 | 43 | 44

veja

sdu b mesh nautico grafite blac

99,00 €

40 | 41 | 43

veja

holiday b mesh nautico grafite blac

87,20 €

109,00 €

40 | 41 | 42 | 43 | 44 | 45 | 46

veja

holiday b mesh nautico steel oxford

87,20 €

109,00 €

40 | 41 | 43 | 44 | 45 | 46

veja

holiday bastille perforees extra white suede

145,00 €

28/32 | 29/32 | 30/32 | 31/32 | 32/32 | 33/32 | 33/34 | 34/32 | 34/34 | 38/34

knowledge cotton apparel

twisted twill total eclipse

110,00 €

32/32

knowledge cotton apparel

twisted twill 1010 bright white

110,00 €

26/32 | 28/32 | 29/32 | 30/32 | 31/32 | 32/32 | 33/32 | 33/34 | 34/32 | 34/34 | 36/34

knowledge cotton apparel

twisted twill tuffet

110,00 €

28/32 | 29/32 | 30/32 | 31/32 | 32/32 | 33/32 | 33/34 | 34/32 | 34/34

knowledge cotton apparel

twisted twill burned olive

110,00 €

28/32 | 29/32 | 30/32 | 31/32 | 32/32 | 33/34 | 34/32 | 34/34

knowledge cotton apparel

twisted twill 1165 greige

110,00 €

28/32 | 29/32 | 30/32 | 31/32 | 32/32 | 33/32 | 33/34 | 34/32 | 34/34 | 36/32 | 36/34

knowledge cotton apparel

twisted twill 1167 phantom

110,00 €

S | M | L | XL

norse projects

veste svend nylon forest green

415,00 €

S | M | L

norse projects

veste svend nylon polymer blue

415,00 €

XS | L | XL

armor lux

mariniere heritage ml nature/ciclone

55,00 €

XS | S | L | XL

armor lux

mariniere heritage ml nature/epona

55,00 €

XS | S | M | L | XL

armor lux

mariniere heritage ml nature/marte

55,00 €

XS | M | L | XL

armor lux

mariniere heritage ml oceano/nature

55,00 €

40 | 41 | 42 | 44 | 45

birkenstock

sandale arizona naturel habana

95,00 €

39 | 40 | 41 | 42 | 43 | 44 | 45

birkenstock

sandale arizona noir

95,00 €

40 | 43

birkenstock

sandale arizona tabacco

95,00 €

41 | 42 | 43 | 44 | 45

birkenstock

sandales arizona eva black

40,00 €

f5ls1yr4rxw6s0 - execution time: 0.375 sec.