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='EN') and (catalogue_vshop.visiblecatalogue=1) And (catalogue_vshop.Niveau0='WOMEN') 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 | WOMEN | CENTRE COMMERCIAL

roseanna

flume swim top tie dye spritz

66,50 €

95,00 €

40/L

roseanna

flame tie dye swimsuit bottoms spritz

73,50 €

105,00 €

40/L

roseanna

patch falcon swimsuit patch

190,00 €

40/L

roseanna

fresh pamela swimsuit fleuri

185,00 €

roseanna

fresh mercy dress fleuri

269,50 €

385,00 €

38/M

roseanna

fresh fool shirt fleuri

210,00 €

300,00 €

40/L

roseanna

hope top bouvier ecru / bleu

192,50 €

275,00 €

36/S | 38/M | 40/L

roseanna

slow dress bouvier ecru/bleu

287,00 €

410,00 €

40/L

roseanna

bouvier shirt ecru/bleue

196,00 €

280,00 €

36/S | 38/M | 40/L

roseanna

striped anika dress blanc

238,00 €

340,00 €

36/S

roseanna

striped fool shirt blanc

196,00 €

280,00 €

36/S | 38/M | 40/L

roseanna

tie and dye parrots dress creme

332,50 €

475,00 €

36/S | 38/M

roseanna

t shirt jersey trash barry blanc

133,00 €

190,00 €

36/S | 38/M

roseanna

t shirt jersey trash barry charbon

133,00 €

190,00 €

38/M | 40/L

roseanna

trousers mint

238,00 €

340,00 €

36/S | 38/M

roseanna

sponger varsity jacket marine

252,00 €

360,00 €

36/S | 38/M | 40/L

roseanna

milos girly sweater rouge

157,50 €

225,00 €

36/S | 38/M

roseanna

camp fishing varsity jacket jaune

301,00 €

430,00 €

S | M

roseanna

round basic sweater rouge

196,00 €

280,00 €

36/S

roseanna

sponge over sweatshirt marine

203,00 €

290,00 €

38/M | 40/L

roseanna

ora bra guipure soleil

84,00 €

120,00 €

38/M | 40/L

roseanna

bless briefs guipure soleil

66,50 €

95,00 €

38/M

roseanna

hope doily blouse ecru

209,30 €

299,00 €

38/M

roseanna

nappfast lace top ecru

182,00 €

260,00 €

38/M | 40/L

roseanna

san giorgio swim briefs noir

66,50 €

95,00 €

roseanna

jersey barry t shirt jaune

65,10 €

93,00 €

36/S | 38/M

roseanna

barry jackie t shirt raye

133,00 €

190,00 €

M

roseanna

socky lurex socks bordeaux

40,00 €

M

roseanna

soko socks jaune

45,00 €

M

roseanna

soko socks orange

45,00 €

38/M | 40/L

roseanna

swimsuit top pound brune multi

120,00 €

36/S | 40/L

roseanna

wind brune swimsuit bottoms multi

95,00 €

38/M

roseanna

judy figari shirt blanc

185,50 €

265,00 €

roseanna

davis figari dress blanc

276,50 €

395,00 €

36/S | 38/M

roseanna

martial lace blouse charbon

217,00 €

310,00 €

38/M

roseanna

shake lace dress charbon

311,50 €

445,00 €

S | M

roseanna

socky ecosse socks jaune

45,00 €

S | M

roseanna

socky ecosse socks myrtille

45,00 €

S | M

roseanna

socky ecosse socks orange

45,00 €

M

roseanna

socky lurex or

40,00 €

f5ls1yr43zh6hs - execution time: 0.875 sec.