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.Prix asc
limit 0, 40;

CENTRE COMMERCIAL KIDS

250ML

minois

eau legere

20,00 €

500ML

minois

gel delicat

22,00 €

100ML

minois

creme douce

24,00 €

12/18M | 18/24M | 6/7A

petit gang

tee shirt jaune

25,00 €

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

petit gang

tee shirt rouge

25,00 €

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

petit gang

legging corail

28,00 €

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

petit gang

legging jaune

28,00 €

3M | 6M | 12M | 2A

arsene et les pipelettes

sarouel molleton brouillard

35,00 €

KID

bobo choses

bonnet wimamp blue

35,00 €

2A | 3A | 4A | 6A | 8A | 10A | 12A

hundred pieces

tee shirt mister t

35,00 €

2A | 3A | 4A | 6A | 8A | 10A | 12A

hundred pieces

tee shirt rocky

35,00 €

18M | 2A

arsene et les pipelettes

sweat à capuche brouillard

38,00 €

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

bobo choses

tee shirt dear world

39,00 €

18M | 2A

arsene et les pipelettes

robe molleton gris chine

42,50 €

3M | 6M | 12M | 18M | 2A

arsene et les pipelettes

sweatshirt molleton indigo raye

45,00 €

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

petit gang

sweatshirt motif mains

45,00 €

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

petit gang

sweatshirt rayures jaune

45,00 €

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

petit gang

sweatshirt rayures rouge

45,00 €

6/12M | 12/36M

mini rodini

casquette alaska black

46,00 €

6M | 12M | 18M | 2A

arsene et les pipelettes

combinaison molleton indigo

48,00 €

6A | 10A | 12A

emile et ida

sweatshirt ocre vegetal

48,00 €

18/24M | 4/5A | 6/7A

petit gang

robe salopette jean

49,00 €

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

mini rodini

body ohlala dogs

52,00 €

2A | 10A | 8A

emile et ida

blouse rose

55,00 €

12/36M

mini rodini

casquette orange coeur

58,00 €

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

mini rodini

pantalon velours burgundy

58,00 €

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

mini rodini

pantalon velours dark green

58,00 €

8A | 10A | 12A

emile et ida

sweatshirt prune patchs

59,00 €

22 | 23 | 24 | 25 | 26 | 28 | 31 | 33 | 35

veja

arcade velcro bmesh grafite silver

60,00 €

22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 34 | 35

veja

arcade velcro marsala white

60,00 €

23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 33 | 34 | 35

veja

arcade velcro nautico grafite

60,00 €

6A | 8A | 10A | 12A | 14A | 16A

hundred pieces

jupe denim denim

62,00 €

2A | 3A | 4A | 6A | 8A

hundred pieces

sweatshirt cats

62,00 €

2A | 3A | 4A | 6A | 8A | 10A | 12A

hundred pieces

sweat velours rouge

62,00 €

2A | 4A | 6A | 8A | 10A

emile et ida

pantalon slim marine

62,50 €

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

mini rodini

tee shirt ohlala dogs aop

64,00 €

2A | 6A | 8A

emile et ida

jupe rayure

65,00 €

3A | 4A | 6A | 8A | 10A | 12A

hundred pieces

sweatshirt awesome f

65,00 €

f5hpoclyu733r0 - execution time: 0.813 sec.