SELECT DISTINCT ingredient.product_ID FROM ingredient, recipe, xcart_products WHERE ingredient.recipe_ID = recipe.recipe_ID AND recipe.active = 'yes' AND ingredient.product_ID > 0 AND ingredient.product_ID = xcart_products.productid ORDER BY xcart_products.product ASC
LIST:Array
(
[0] => 721
)