MySQL > Select5

SELECT vchTitreRecette FROM recettes_adresse_public
      LEFT JOIN recettes USING(idRecette)
      LEFT JOIN public_cible USING(idPublic)
      LEFT JOIN recettes_contient_ingredients USING(idRecette)
      LEFT JOIN ingredients USING(idIngredient)
      LEFT JOIN plats USING(idPlat)
      WHERE vchNomPublic="citadin stressé" AND vchNomPlat="accompagnements" AND vchNomIngredient="fenouil" AND booVegetarien = 1