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

gistfile1.sql

CREATE VIEW view_recipe_by_ingredient AS
  SELECT R.id, R.name, RI.liquorID
    FROM recipes R
    JOIN recipeIngredients RI ON RI.recipeID = R.id;

CREATE VIEW view_recipes_in_cabinet AS
	SELECT L.userID, RbI.name, RbI.id, COUNT( RbI.liquorID ) as LiquorCount
		FROM view_recipe_by_ingredient RbI
		LEFT JOIN liquorCabinet L USING (liquorID)
	GROUP BY RbI.name;

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, RiC.id, userID
    FROM view_recipes_in_cabinet RiC
    LEFT JOIN view_cabinet_count CC USING( userID )
  WHERE RiC.LiquorCount = CC.total;