SQL to get all recipes that contain all ingredients the user has

gistfile1.sql

CREATE VIEW view_recipe_by_ingredient AS
  SELECT R.*, RI.liquorID                            -- Replace R.* with columns in recipes table
    FROM recipes R
    JOIN recipeIngredients RI ON RI.recipeID = R.id;

CREATE VIEW view_recipes_in_cabinet AS
  SELECT L.userID, RbI.id, COUNT( RbI.liquorID ) as LiquorCount, RbI.* -- Replace RbI.* with remaining columns in view_recipe_by_ingredient
    FROM view_recipe_by_ingredient RbI
    LEFT JOIN liquorCabinet L USING( liquorID );

CREATE VIEW view_cabinet_count AS
  SELECT userId, COUNT( liquorId ) as total
    FROM liquorCabinet;

CREATE VIEW view_recipes_in_cabinet_using_all_ingredients AS
  SELECT RiC.name
    FROM view_recipes_in_cabinet RiC
    LEFT JOIN view_cabinet_count CC USING( userID )
  WHERE RiC.LiquorCount = CC.total;


-- Select recipes in user's cabinet, ordered by number of ingredients DESC
SELECT *
  FROM view_recipes_in_cabinet
WHERE userID = ?
ORDER BY LiquorCount DESC;

-- Select recipes in user's cabinet that use all ingredients in cabinet
SELECT *
  FROM view_recipes_in_cabinet_using_all_ingredients
WHERE userID = ?;