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

roseanna

brassiere maillot tie dye spritz

66,50 €

95,00 €

40/L

roseanna

culotte maillot flame tie dye spritz

73,50 €

105,00 €

40/L

roseanna

maillot de bain fatch falcon patch

190,00 €

40/L

roseanna

maillot de bain fresh pamela fleuri

185,00 €

roseanna

robe fresh mercy fleuri

269,50 €

385,00 €

38/M

roseanna

chemise fresh fool fleuri

210,00 €

300,00 €

40/L

roseanna

top hope bouvier ecru / bleu

192,50 €

275,00 €

36/S | 38/M | 40/L

roseanna

robe slow bouvier ecru/bleu

287,00 €

410,00 €

40/L

roseanna

chemise bouvier ecru/bleue

196,00 €

280,00 €

36/S | 38/M | 40/L

roseanna

robe a rayures anika blanc

238,00 €

340,00 €

36/S

roseanna

chemise fool rayee blanc

196,00 €

280,00 €

36/S | 38/M | 40/L

roseanna

robe tie and dye parrots 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

pantalon mint

238,00 €

340,00 €

36/S | 38/M

roseanna

teddy varsity sponger marine

252,00 €

360,00 €

36/S | 38/M | 40/L

roseanna

pull milos girly rouge

157,50 €

225,00 €

36/S | 38/M

roseanna

teddy camp fishing jaune

301,00 €

430,00 €

S | M

roseanna

pull round basic rouge

196,00 €

280,00 €

36/S

roseanna

pull sponge over marine

203,00 €

290,00 €

38/M | 40/L

roseanna

soutien gorge ora guipure soleil

84,00 €

120,00 €

38/M | 40/L

roseanna

culotte bless guipure soleil

66,50 €

95,00 €

38/M

roseanna

top napperon hope ecru

209,30 €

299,00 €

38/M

roseanna

top nappfast dentelle ecru

182,00 €

260,00 €

38/M | 40/L

roseanna

culotte maillot san giorgio noir

66,50 €

95,00 €

roseanna

t shirt jersey barry jaune

65,10 €

93,00 €

36/S | 38/M

roseanna

t shirt jackie barry raye

133,00 €

190,00 €

M

roseanna

chaussettes socky lurex bordeaux

40,00 €

M

roseanna

chaussettes soko jaune

45,00 €

M

roseanna

chaussettes soko orange

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

38/M

roseanna

chemise judy figari blanc

185,50 €

265,00 €

roseanna

robe davis figari blanc

276,50 €

395,00 €

36/S | 38/M

roseanna

top martial en dentelle charbon

217,00 €

310,00 €

38/M

roseanna

robe shake lace charbon

311,50 €

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

40/L

roseanna

top funk mini check check

139,50 €

155,00 €

f5ls1yr58so6hs - execution time: 0.391 sec.