SELECT PneuProd.ProdId, PneuProd.Categorie_Id, PneuProd.Marque_Id, PneuProd.Largeur, PneuProd.Serie, PneuProd.Jante, PneuProd.IndVitesse, PneuProd.InfoComplementaire, PneuProd.STRUCTURE, PneuProd.Dimension, PneuProd.IndCharge, PneuProd.Modele, PneuProd.Description, PneuProd.PrixAchat, PneuProd.Quantite,  PneuProd.PrixAchat+PneuMarque.Marge AS Prix, PneuProd.Ete, PneuProd.Hiver, PneuProd.Runflat, PneuProd.Renforce, PneuProd.Districash, CONCAT(PneuImageDistricash.Gamme, '.', PneuImageDistricash.Extension) AS UrlVignette, CONCAT(PneuImageDistricash.Gamme, '.', PneuImageDistricash.Extension) AS UrlImage
FROM PneuProd, PneuMarque
LEFT JOIN PneuImageDistricash ON PneuImageDistricash.Marque_Id=PneuProd.Marque_Id AND PneuImageDistricash.Categorie_Id = PneuProd.Categorie_Id AND PneuImageDistricash.Profile = PneuProd.Particularite
WHERE PneuProd.Active='y'
AND PneuProd.Districash=1
AND PneuMarque.Marque_Id=PneuProd.Marque_Id
AND PneuProd.Categorie_Id = '1'