The retrieve query was SELECT * FROM recipe t1 LEFT JOIN usertable t2 ON t1.user_name = t2.user_name WHERE recipe_name = '' and the mysql error was
Error retrieving categories
The retrieve query was
SELECT ru.*,AVG(overall_factor) rating_value, count(*) num_ratings, urr.recipe_name sub_recipe_name,has_picture
FROM (
SELECT recipe_name,recipe_description,first_name,last_name,has_picture
FROM (SELECT DISTINCT t1.recipe_name,recipe_description,t1.user_name,has_picture FROM (
SELECT DISTINCT(r.recipe_name),recipe_description,recipe_directions,user_name,has_picture
FROM recipecategorization rc
LEFT JOIN recipe r
USING (recipe_name)
WHERE rc.category_name = '' AND r.recipe_name IS NOT NULL
AND (r.hidden_fl = 0)
) t1
LEFT JOIN recipeingredient t2
ON t1.recipe_name = t2.recipe_name
LEFT JOIN usertable t3
ON t1.user_name = t3.user_name
) r1
LEFT JOIN usertable ut1
USING (user_name)
) ru
LEFT JOIN userreciperating urr
USING (recipe_name)
GROUP BY ru.recipe_name
ORDER BY ru.recipe_name and the mysql error was
|