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

NOUVEAUTES HOMME | CENTRE COMMERCIAL

S | L

norse projects

t shirt esben mercerise navy

60,00 €

S | M | L

norse projects

t shirt esben mercerise ochre

60,00 €

norse projects

t shirt niels pocket moss

60,00 €

S | M | L | XL

norse projects

t shirt mc niels standard black

50,00 €

S

norse projects

t shirt mc niels standard light grey melange

50,00 €

S | M | L

norse projects

t shirt mc niels standard white

50,00 €

S | M | XL

norse projects

t shirt ml niels standard black

65,00 €

XS | S | M | L | XL

norse projects

t shirt ml niels standard light grey melange

65,00 €

XS | S | M | L | XL

norse projects

t shirt ml niels standard white

65,00 €

XS | S | M | L | XL

norse projects

sweatshirt vorm mercerise black

110,00 €

XS | S | L | XL

norse projects

sweatshirt vorm mercerise navy

110,00 €

S | M | L

norse projects

sweatshirt vorm mercerise ochre

110,00 €

S | M | L | XL

norse projects

sweatshirt ketel classic crew lichen

115,00 €

S | M | L | XL

norse projects

sweatshirt ketel classic crew light grey melange

115,00 €

S | M

norse projects

sweatshirt ketel laine navy

200,00 €

L | XL

norse projects

pull sigfred dried olive

125,00 €

S | M | L | XL

norse projects

pull sigfred navy

145,00 €

M | L | XL

norse projects

pull sigfred ochre

125,00 €

L

stutterheim

manteau de pluie arholma black

435,00 €

XS | S | L

stutterheim

manteau stockholm black

225,00 €

XXXS | XXS | XS

stutterheim

manteau stockholm burgundy

225,00 €

XS | S | M | L

stutterheim

manteau stockholm mole

225,00 €

XS | S | M | L

stutterheim

manteau stockholm navy

225,00 €

40 | 41 | 42 | 43 | 44 | 45

zespa

baskets zspgt apla navy

260,00 €

40 | 41 | 42 | 43 | 44 | 45

zespa

baskets zspgt apla off white

260,00 €

40 | 42 | 43 | 44 | 46

veja

baskets v10 black black

125,00 €

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

veja

baskets v10 extra white

125,00 €

40 | 41 | 42 | 43 | 44 | 46

veja

baskets v10 white black

125,00 €

40 | 41 | 42 | 43 | 44 | 46

veja

baskets v10 white grey blue

125,00 €

41 | 42 | 43 | 44 | 45 | 46

veja

baskets v10 white nautico pekin

125,00 €

S | M | L

a kind of guise

chemise ochiba off white

160,00 €

L

a kind of guise

chemise goromo rose

170,00 €

M | L

a kind of guise

pull onin crew neck blue melange

360,00 €

S | M

a kind of guise

sweat fukoka col v navy

290,00 €

48 | 50 | 52

a kind of guise

pantalon elastique ample black

195,00 €

50 | 52

a kind of guise

pantalon classy wide black

225,00 €

S | M | L | XL

a kind of guise

manteau okayama en laine navy

495,00 €

S | M | L

a kind of guise

parka okayama camouflage

460,00 €

f85vgigba2l5b0 - execution time: 0.766 sec.