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.Marque='MINI RODINI') and ( catalogue_vshop.Niveau1 <> Upper('outlet') ) And 1

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

MINI RODINI | ENFANT | CENTRE COMMERCIAL KIDS

6/12M | 12/36M

mini rodini

casquette alaska black

46,00 €

3/6M | 6/12M

mini rodini

combinaison insulator bebe rabbit aop

127,00 €

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

mini rodini

body ohlala dogs

52,00 €

12/36M

mini rodini

casquette orange coeur

58,00 €

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

mini rodini

doudoune blue

139,00 €

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

mini rodini

doudoune off white

139,00 €

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

mini rodini

veste fausse fourrure blue

127,00 €

4/5A

mini rodini

robe a col ohlala dogs

81,00 €

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

mini rodini

parka impermeable black

185,00 €

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

mini rodini

parka impermeable penguin

185,00 €

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

mini rodini

tee shirt ohlala dogs aop

64,00 €

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

mini rodini

tee shirt blockstripe

46,00 €

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

mini rodini

tee shirt butterflies

46,00 €

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

mini rodini

tee shirt green rabbit

35,00 €

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

mini rodini

tee shirt pink rabbit

35,00 €

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

mini rodini

tee shirt roses aop

35,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 €

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

mini rodini

body babies

35,00 €

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

mini rodini

body butterflies

38,00 €

6/12M | 18/24M

mini rodini

body red dogs

32,00 €

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

mini rodini

body roses

35,00 €

6/12M | 18/24M

mini rodini

body basic navy

30,00 €

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

mini rodini

sweatshirt dog navy

46,00 €

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

mini rodini

sweatshirt dog pink

46,00 €

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

mini rodini

sweatshirt flying bat

45,00 €

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

mini rodini

sweatshirt panther aop

55,00 €

3/6M | 6/12M

mini rodini

combinaison leopard

46,00 €

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

mini rodini

combinaison tassels

46,00 €

2/3A | 4/5A

mini rodini

sweatpant bats

46,00 €

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

mini rodini

sweatpant green panther

46,00 €

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

mini rodini

legging blockstripe

35,00 €

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

mini rodini

legging butterflies

35,00 €

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

mini rodini

legging leopard

32,00 €

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

mini rodini

legging roses

32,00 €

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

mini rodini

legging tassels

29,00 €

6/7A | 8/9A

mini rodini

impermeable pico black

105,00 €

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

mini rodini

impermeable pico burgundy

105,00 €

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

mini rodini

robe col claudine rabbit

69,00 €

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

mini rodini

robe fox family

52,00 €

f5hpocm6odx63k - execution time: 0.719 sec.