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.EnNouveaute=1) And 1

group by catalogue_vshop.BarCode, catalogue_vshop.Couleur
order by catalogue_vshop.OrdreTriVshop desc,catalogue_vshop.BarCode
limit 0, 40;

CENTRE COMMERCIAL KIDS

33/34 | 35/36

bobo choses

bottes de pluie

39,00 €

6/12M | 12/18M | 18/24M | 2/3A | 4/5A | 6/7A

bobo choses

veste reversible navy stripes

115,00 €

3/6M | 6/12M | 12/18M | 18/24M | 2/3A | 4/5A | 6/7A | 8/9A | 10/11A

bobo choses

sweatshirt calypso

49,00 €

2/3A | 4/5A | 6/7A | 8/9A | 10/11A

bobo choses

sweatshirt captain

65,00 €

2/3A | 4/5A | 6/7A | 8/9A | 10/11A

bobo choses

jumper intarsia tricote fish

96,00 €

2/3A | 4/5A | 6/7A | 8/9A | 10/11A

bobo choses

jumper intarsia tricote morning sea

96,00 €

3/6M | 6/12M | 12/18M | 18/24M | 2/3A | 4/5A | 6/7A | 10/11A

bobo choses

jumper alma sb

59,00 €

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

bobo choses

jumper blue

59,00 €

2/3A | 4/5A | 6/7A

bobo choses

jumper à boutons sea red wave

65,00 €

2/3A | 4/5A | 6/7A | 8/9A | 10/11A

bobo choses

jumper rouge blanc

89,00 €

6/7A

bobo choses

sweatshirt imprime dear

59,00 €

2/3A | 4/5A | 6/7A | 8/9A | 10/11A

bobo choses

sweatshirt imprime fish

59,00 €

2/3A | 4/5A

bobo choses

sweatshirt imprime loup

49,00 €

3/6M | 6/12M | 12/18M | 18/24M | 2/3A | 4/5A | 6/7A | 8/9A | 10/11A

bobo choses

sweatshirt imprime octopus

59,00 €

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

bobo choses

sweatshirt bebe loup de mer

49,00 €

2/3A | 4/5A | 6/7A

bobo choses

sweatshirt loup de mer

65,00 €

2/3A | 4/5A | 6/7A

bobo choses

jumper tricote crabe

89,00 €

2/3A | 6/7A | 8/9A | 10/11A

bobo choses

jumper à volants blue

79,00 €

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

bobo choses

cardigan octopus

79,00 €

3/6M | 6/12M | 12/18M | 18/24M | 2/3A | 4/5A | 6/7A | 8/9A | 10/11A

bobo choses

cardigan stripes

79,00 €

2/3A | 4/5A | 6/7A | 8/9A | 10/11A

bobo choses

chemise sails kaki

69,00 €

8/9A | 10/11A

bobo choses

tee shirt alma aop

33,00 €

2/3A | 4/5A | 6/7A | 8/9A

bobo choses

tee shirt alma sb

33,00 €

bobo choses

tee shirt crab

33,00 €

2/3A | 6/7A

bobo choses

tee shirt loup

33,00 €

12/18M

bobo choses

tee shirt crab

31,00 €

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

bobo choses

tee shirt crests

31,00 €

4/5A | 6/7A | 8/9A | 10/11A

bobo choses

tee shirt otarie

39,00 €

2/3A | 4/5A | 6/7A | 8/9A | 10/11A

bobo choses

blouse a boutons crabe aop

69,00 €

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

bobo choses

body alma

36,00 €

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

bobo choses

body crabe aop

36,00 €

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

bobo choses

combinaison bébé otarie

49,00 €

2/3A | 4/5A | 6/7A | 8/9A | 10/11A

bobo choses

salopette mer

85,00 €

2/3A | 4/5A | 6/7A | 8/9A | 10/11A

bobo choses

salopette vague

79,00 €

8/9A

bobo choses

robe longue stripes

85,00 €

4/5A | 6/7A | 8/9A

bobo choses

robe longue vichy

79,00 €

3/6M | 6/12M | 12/18M

bobo choses

robe a boutons crabe

69,00 €

tpnmex1dvk2j688 - execution time: 0.719 sec.