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='ENFANT') and (catalogue_vshop.Niveau1 = 'VETEMENTS' ) and (catalogue_vshop.Niveau2 = 'BONNETS ET ECHARPES' ) 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;

CENTRE COMMERCIAL

12/36M

mini rodini

casquette orange coeur

58,00 €

KID

bobo choses

bonnet wimamp blue

35,00 €

0/3M | 3/6M | 9/12M | 18/24M

poudre organic

béguin côtelé beige

26,00 €

18/24M | 6/8A | 10A

poudre organic

bonnet côtelé beige

29,00 €

0/6M | 6/12M | 12/18M

oeuf nyc

bonnet animal bambi

60,00 €

0/6M | 6/12M | 12/18M

oeuf nyc

bonnet animal licorne

60,00 €

0/3M

oeuf nyc

bonnet bebe pink cherries

25,00 €

0/3M

oeuf nyc

bonnet bebe rainbow cats

25,00 €

BABY | KID

bobo choses

bonnet cousteau rouge

29,00 €

T. UNIQUE

bobo choses

tour de cou alma aop

35,00 €

T. UNIQUE

bobo choses

tour de cou crests

35,00 €

T. UNIQUE

bobo choses

tour de cou stripes

35,00 €

KIDS

tinycottons

tour de cou lama marron

40,00 €

T. UNIQUE

the animals observatory

bonnet pony navy blue

45,00 €

T. UNIQUE

the animals observatory

bonnet pony red

45,00 €

BABY | KID

bobo choses

bonnet tricote stripe

35,00 €

T. UNIQUE

saint james

bonnet surcouf ecru marine

19,50 €

T. UNIQUE

saint james

bonnet surcouf marine ecru

19,50 €

ENFANT

saint james

echarpe adam ecru marine

22,50 €

ENFANT

saint james

echarpe adam marine ecru

22,50 €

KIDS

kalinka

tour de cou camellia rosy red

21,00 €

6/9M

benber

bonnet bebe naturelle

19,00 €

0-6M | 6-12M

misha and puff

bonnet beach walk ink

32,00 €

0/6M

oeuf nyc

bonnet bambi

60,00 €

f5hpocm27645ok - execution time: 0.532 sec.