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='FEMME') and (catalogue_vshop.Marque='ROSEANNA') 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;

ROSEANNA | FEMME | CENTRE COMMERCIAL

36/S | 38/M | 40/L

roseanna

soutien gorge pound ecru

105,00 €

36/S | 38/M | 40/L

roseanna

culotte marquise brooklyn ecru

95,00 €

36/S | 38/M | 40/L

roseanna

soutien gorge georgia n elliot ecru

120,00 €

36/S | 38/M | 40/L

roseanna

culotte georgia motel ecru

90,00 €

36 | 37 | 38 | 39

roseanna

santiags tucson khaki

440,00 €

36 | 38

roseanna

chemise oscar klin ecru

430,00 €

36 | 38

roseanna

robe oscar franklin ecru

585,00 €

38

roseanna

manteau chicago conrad fushia

795,00 €

36 | 38

roseanna

robe longue marquise mercy ecru

520,00 €

36 | 38 | 40

roseanna

top marquise drake ecru

310,00 €

S | M

roseanna

pull mohair iver malabar

265,00 €

S | M

roseanna

pull mohair iver spritz

265,00 €

S | M

roseanna

pull mohair tyler malabar

235,00 €

S | M

roseanna

pull mohair tyler spritz

235,00 €

36 | 38 | 40

roseanna

chemise harvard avril vert marine

310,00 €

36 | 38

roseanna

robe longue harvard hello vert marine

495,00 €

36 | 38

roseanna

top georgia martial ecru

220,00 €

36 | 38

roseanna

top georgia galvin ecru

305,00 €

36/S | 38/M

roseanna

pull col roule basic turtle soleil

285,00 €

36 | 38

roseanna

pantalon archive charles nuts

340,00 €

40/L

roseanna

maillot de bain fresh pamela fleuri

185,00 €

40/L

roseanna

maillot de bain fatch falcon patch

190,00 €

38/M | 40/L

roseanna

haut de maillot pound brune multi

120,00 €

36/S | 40/L

roseanna

bas de maillot wind brune multi

95,00 €

M

roseanna

chaussettes socky lurex bordeaux

40,00 €

M

roseanna

chaussettes soko jaune

45,00 €

M

roseanna

chaussettes soko orange

45,00 €

S | M

roseanna

chaussettes socky ecosse jaune

45,00 €

S | M

roseanna

chaussettes socky ecosse myrtille

45,00 €

S | M

roseanna

chaussettes socky ecosse orange

45,00 €

M

roseanna

socky lurex or

40,00 €

M

roseanna

socky lurex vert

40,00 €

tpnmex1dvns75k8 - execution time: 0.312 sec.