SELECT DISTINCT it.name as Item, I.name as Ingredient
FROM madewith as mw, ingredients as i, items as it
WHERE (mw.itemid = it.itemid)
AND (mw.ingredientid = i.ingredientid)
AND ((quantity*3) > inventory)