CHEMISES OLD RIVER HIVER 2017 800X200

 

____________________________________________________________________________________________________

 

 

Aucun produit ne correspond à votre recherche
Drop temporary table if exists tmp__cvshop ; Create temporary table tmp__cvshop select BarCode, group_concat(DISTINCT Couleur order by Couleur) as Couleurs, group_concat(DISTINCT TailleLangue order by TailleLangue) as Tailles, group_concat(Stock order by stock desc) as Stocks, min(ordreCouleur) as Couleur_Min from catalogue_vshop Where (catalogue_vshop.Site = 'WEB') and (catalogue_vshop.langue='FR') and (catalogue_vshop.visiblecatalogue=1) And (catalogue_vshop.Niveau0='AUTOMNE HIVER 2017') and (catalogue_vshop.Niveau1 = 'CHEMISES' ) And 1 group by BarCode, Couleur; Create index ParCouleur_Min on tmp__cvshop (Couleur_Min); Create index ParBARCODE on tmp__cvshop (BARCODE); Select catalogue_vshop.Produit, c.BarCode, catalogue_vshop.Couleur, catalogue_vshop.CouleurLangue, Designation, Designation2, Marque, Theme, Prix, PrixRemise, Remise, Descriptif, Famille, c.Couleurs, c.Tailles, c.Stocks, catalogue_vshop.Niveau0, catalogue_vshop.Niveau1, catalogue_vshop.Niveau2, catalogue_vshop.URL from tmp__cvshop c , catalogue_vshop Where (catalogue_vshop.Site = 'WEB') and (catalogue_vshop.langue='FR') and (catalogue_vshop.visiblecatalogue=1) And (catalogue_vshop.Niveau0='AUTOMNE HIVER 2017') and (catalogue_vshop.Niveau1 = 'CHEMISES' ) And 1 And (c.barcode = catalogue_vshop.barcode) And (catalogue_vshop.ordrecouleur = c.Couleur_Min) group by catalogue_vshop.barcode, catalogue_vshop.Couleur order by catalogue_vshop.OrdreTriVshop desc, catalogue_vshop.Produit desc limit 0, 50;

f80jye1fef03jk - execution time: 1.016 sec.