Forum d'entraide PHPFrance

SELECT DISTINCT cds_prod.ProdID, CatID, ImgID, MfPN, cds_mktfr.Description AS description_produit, Text, cds_stdnfr.Description AS motsclef_produit, cds_Catalog.StatusCode, cds_Catalog.Timestamp, prix_achat, prix_public, code_barre, quantite_disponible, quantite_commande, date_arrive, reference_ingram
FROM cds_prod
LEFT JOIN cds_mktfr ON cds_prod.MktID = cds_mktfr.MktID
LEFT JOIN cds_stdnfr ON cds_prod.ProdID = cds_stdnfr.ProdID
LEFT JOIN cds_Catalog ON cds_prod.ProdID = cds_Catalog.ProdID
LEFT JOIN cds_vocfr ON cds_prod.MfID = cds_vocfr.ID
LEFT JOIN ingram_price ON reference_fabricant = MfPN
LEFT JOIN ingram_titfrhrl ON reference_fab = MfPN
WHERE CatID = 'ab'
limit20