1*** : #40001Deadlock found when trying to get lock; try restarting transaction Drop temporary table if exists tmp__cvshop1 ; Create temporary table tmp__cvshop1 select BarCode, Couleur, TailleLangue, Stock, ordreCouleur, If (Stock > 0 , TailleLangue, '') as TailleDispo from catalogue_vshop Where (catalogue_vshop.Site = 'ATELIERDUS') and (catalogue_vshop.langue='FR') and (catalogue_vshop.visiblecatalogue=1) And (catalogue_vshop.Niveau0='FEMME') and (catalogue_vshop.Niveau1='CHAUSSURES') And 1 ; 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 TailleLangue) as Stocks, group_concat(DISTINCT TailleDispo order by TailleDispo separator ' | ') as taillesDispo, min(ordreCouleur) as Couleur_Min from tmp__cvshop1 group by Barcode ; 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, catalogue_vshop.enNouveaute,catalogue_vshop.EnPromotion, 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, c.taillesDispo, If (sum(stock) > 0 , 0, 1) as Epuise from tmp__cvshop c , catalogue_vshop Where (catalogue_vshop.Site = 'ATELIERDUS') and (catalogue_vshop.langue='FR') and (catalogue_vshop.visiblecatalogue=1) And (catalogue_vshop.Niveau0='FEMME') and (catalogue_vshop.Niveau1='CHAUSSURES') And 1 And (c.barcode = catalogue_vshop.barcode) And (c.couleurs = catalogue_vshop.couleur) And (catalogue_vshop.ordrecouleur = c.Couleur_Min) group by Barcode order by catalogue_vshop.OrdreTriVshop desc, catalogue_vshop.Produit desc limit 0, 50;
