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 40, 40;

NOUVEAUTES HOMME | CENTRE COMMERCIAL

S | M | L

ami, alexandre mattiussi

blouson zippé kaki

665,00 €

S | M | L

ami, alexandre mattiussi

blouson zippé marine

665,00 €

S | M | L

ami, alexandre mattiussi

blouson zippé marine

520,00 €

M | L

ami, alexandre mattiussi

blouson a pressions noir

405,00 €

XS | S | M | L | XL

ami, alexandre mattiussi

pantalon large fit kaki

220,00 €

XS | S | M | L | XL

ami, alexandre mattiussi

pantalon large fit tabac

220,00 €

XS | S | M | L

ami, alexandre mattiussi

pantalon chino noir

180,00 €

S | M | L

ami, alexandre mattiussi

pantalon chino tabac

180,00 €

S | M | L

ami, alexandre mattiussi

gilet zippe cote anglaise kaki

330,00 €

M | L

ami, alexandre mattiussi

gilet zippe cote anglaise noir

330,00 €

XS | S | M | L

ami, alexandre mattiussi

pantalon jogging gris/violet

230,00 €

XS | S | M | L

ami, alexandre mattiussi

pantalon jogging kaki/noir

230,00 €

S | M | L

ami, alexandre mattiussi

sweatshirt lettres ami rouge

175,00 €

S | M | L

ami, alexandre mattiussi

sweatshirt ami de coeur noir

170,00 €

S | M | L

ami, alexandre mattiussi

veste denim noir

270,00 €

30 | 31 | 32 | 33

ami, alexandre mattiussi

jeans 5 poches indigo rince

145,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

short trench parka beige

375,00 €

46 | 48 | 50

tres bien

short trench parka black

375,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

tres bien

half zip sweatshirt espresso

180,00 €

M | L

tres bien

half zip sweatshirt off white

180,00 €

S | M | L

tres bien

army sweatshirt espresso

130,00 €

S | M | L

tres bien

army sweatshirt grape

130,00 €

S | M

tres bien

army sweatshirt off white

130,00 €

M | S | L

ami, alexandre mattiussi

tee-shirt family blanc

85,00 €

S | M | L

ami, alexandre mattiussi

tee-shirt petit ami gris chine

80,00 €

41.5 | 42.5

new balance

1500 fa grey/navy

170,00 €

40.5 | 41.5 | 42 | 42.5 | 43 | 44 | 45

new balance

998 nj black

210,00 €

40.5 | 41.5 | 42 | 43 | 44

new balance

991 fa navy/grey

200,00 €

41.5 | 42 | 42.5 | 43 | 44

new balance

770 fa grey

200,00 €

S | M | XL

toka toka

tee shirt tom navy

55,00 €

S | M | L

toka toka

tee shirt tom white

55,00 €

S | M | L

toka toka

sweat bruce black

90,00 €

S | M | L

toka toka

sweat bruce grey

90,00 €

M

toka toka

sweat bruce navy

90,00 €

29 | 30 | 31 | 32 | 33 | 34

naked and famous

easy guy okayama spirit 3 indigo

195,00 €

f85vgigbie2560 - execution time: 0.828 sec.