New general search query with category division

[falkirks]

No description provided.

[kevindhir]

SELECT itemName 
FROM itemHas 
WHERE NOT EXISTS
((SELECT categoryName From itemHas)
EXCEPT
(SELECT queryCategory From query WHERE queryCategory = categoryName))

[falkirks]

@kevindhir I am not sure how to move forward with implementing that query. What params does it take? Does it require some table or view called query?

[falkirks]

SELECT *
FROM food_items fi
WHERE NOT EXISTS
  (SELECT C.name FROM categories C WHERE (C.name = 'Fast food' OR C.name = 'Vegetarian') AND NOT EXISTS
    (SELECT ih.itemName
        FROM itemHas ih
        WHERE C.name = ih.categoryName
        AND ih.itemName=fi.name));