Grab the query that shows the information you want, but too much of it (about halfway down where we join recipes and ingredients to display the ingredients names).

select as recipe_id,, ri.ingredient_id, i.item
from recipes r
join recipe_ingredients ri on ( = ri.recipe_id)
join ingredients i on (ri.ingredient_id =;

This gives all the ingredients for all the recipes, and you can then go on and filter it by adding `where io.item = "apple"`. Hope that helps!