Jacques, you can add WHERE clauses after the JOINs, so like if you only wanted it for the “Pudding” category, you’d do something like this in the last example ( I don’t know what the id for pudding is):

…
INNER JOIN categories c ON (r.category_id = c.id)
WHERE c.id = 2;

This will give you just the recipe info in that category.