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

PANTALONS ET SHORTS HOMME | CENTRE COMMERCIAL

31/32 | 32/32 | 33/32 | 34/32

knowledge cotton apparel

pantalon worker bob total eclipse

48,00 €

120,00 €

29 | 33

norse projects

chino aros twill leger dried olive

130,00 €

30 | 31

norse projects

chino aros twill leger ecru

130,00 €

28 | 31 | 32 | 33

norse projects

chino aros twill leger khaki

130,00 €

28 | 29 | 33

norse projects

chino aros twill leger navy

130,00 €

31

bleu de paname

pant suedois bleu paname

52,00 €

130,00 €

31

bleu de paname

pant suedois olive

52,00 €

130,00 €

29/32

stan ray

pantalon taper fatigue ripstop navy

95,00 €

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

stan ray

pantalon taper fatigue ripstop olive

95,00 €

29 | 32 | 33 | 34

stan ray

short 4 poches olive

90,00 €

31 | 32

stan ray

short ripstop 4 poches navy

90,00 €

28/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 €

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/32 | 33/34 | 34/32 | 38/34

knowledge cotton apparel

twisted twill total eclipse

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 €

30 | 31 | 32

mews

pantalon gynza off white

44,00 €

110,00 €

50

a kind of guise

pantalon classy tailored warm grey

96,00 €

240,00 €

29

knowledge cotton apparel

bermuda twisted twill burned olive

80,00 €

knowledge cotton apparel

bermuda twisted twill greige

80,00 €

L

patagonia

short leger baggies big sur blue

50,00 €

S | L

patagonia

short leger baggies fire

50,00 €

S

patagonia

short leger baggies sporty orange

50,00 €

48 | 50

officine generale

pantalon paul en laine fresco navy

92,00 €

230,00 €

30 | 32 | 34

ymc

jean 7/8 ecru

76,00 €

190,00 €

36

bleu de paname

pantalon kungfu kaki

72,00 €

120,00 €

42

ami, alexandre mattiussi

pantalon coupe carotte marine

92,00 €

230,00 €

36 | 38

ami, alexandre mattiussi

pantalon coupe droite marine

110,00 €

220,00 €

34

coltesse

pantalon sudden bleached denim

68,00 €

170,00 €

50

etudes

pantalon archives stone

67,60 €

169,00 €

29 | 33

naked and famous

super skinny noir

175,00 €

31 | 33

naked and famous

weird guy bleu blanc rouge indigo

185,00 €

32

bleu de paname

pantalon civile mastic

78,00 €

130,00 €

29 | 30

norse projects

pantalon sten coton panama navy

85,00 €

170,00 €

31/32 | 32/32

knowledge cotton apparel

pantalon chino twill epais peacoat

120,00 €

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

stan ray

pantalon taper fatigue black

95,00 €

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

stan ray

pantalon taper fatigue khaki

95,00 €

28 | 29 | 30 | 31 | 32 | 33

naked and famous

easy guy left hand twill

155,00 €

32 | 33

norse projects

chino epais aros black

130,00 €

33

norse projects

chino epais aros dark navy

130,00 €

f75h5nkkint58w - execution time: 0.469 sec.