ingredients.sql

select ingredient._id, ingredient.name,
  CASE WHEN EXISTS(
             SELECT 1 from ingredient as ingredient2   
               join meal_ingredient on ingredient2._id= meal_ingredient.ingredient_id    
               join meal on meal._id= meal_ingredient.meal_id    
               where ingredient2._id = ingredient._id and meal._id = ?
        ) THEN 1
        ELSE 0 
    END as checked 
from ingredient