select distinct * from ingredient where ingredient id in (
select ingredient_id from reing where recipe_id in (
selected_recipe_id, selected_recipe_id2, ...
)
);