Recipes Similar to
RecipeDAO::__construct .No db handleRecipeDAO::getIngredientListSELECT AL2.amount, AL2.notes, AL1.ingredient_id, AL2.unit_id, AL2.unit_qualifier FROM ingredient AL1, ingredient_recipe AL2 WHERE (AL1.ingredient_id=AL2.ingredient_id) AND (AL2.recipe_id='') order by AL2.display_order asc
SQL: SELECT AL1.recipe_id, AL4.description, AL3.recipe_name, AL2.recipe_id as child, AL4.recipe_name, count(AL2.ingredient_id) as c, AL4.number_of_servings FROM ingredient_recipe AL1, ingredient_recipe AL2, recipe AL3, recipe AL4 WHERE (AL1.ingredient_id=AL2.ingredient_id AND AL1.recipe_id=AL3.recipe_id AND AL4.recipe_id=AL2.recipe_id) AND (AL1.recipe_id='' AND AL4.recipe_category_id=) group by AL1.recipe_id, AL3.recipe_name, AL2.recipe_id, AL4.recipe_name having ((count(AL2.ingredient_id)/0)*100) >= 40 order by c desc LIMIT 25
SQL: SELECT AL1.recipe_id, AL4.description, AL3.recipe_name, AL2.recipe_id as child, AL4.recipe_name, count(AL2.ingredient_id) as c, AL4.number_of_servings FROM ingredient_recipe AL1, ingredient_recipe AL2, recipe AL3, recipe AL4 WHERE (AL1.ingredient_id=AL2.ingredient_id AND AL1.recipe_id=AL3.recipe_id AND AL4.recipe_id=AL2.recipe_id) AND (AL1.recipe_id='' AND AL4.recipe_category_id=) group by AL1.recipe_id, AL3.recipe_name, AL2.recipe_id, AL4.recipe_name having ((count(AL2.ingredient_id)/0)*100) >= 40 order by c desc LIMIT 25
