select a.*,b.EngineTypeCode,c.Description as systeme ,d.FuelTypeCode as fuel from `products` a LEFT JOIN fuelsystems c ON a.FuelSystemID = c.FuelSystemID LEFT JOIN fueltypes d ON a.FuelTypeID = d.FuelTypeID LEFT JOIN enginetypes b ON a.EngineTypeID=b.EngineTypeID where a.`ProductID` = '974' LIMIT 1