I need to do something like this please:
category.name AS Category,
count(category.name) as Count
ON category.name = recipe.category
GROUP BY category.name;
Or at least i think i do
Lemme try and put it in words: I have a table recipes and a table categories. I want to display the category and the number of recipes in that category on the app. I guess that would have been easier if i had a single category per recipe, BUT (I had to do this in HARD mode from the get-go) i use “This field is a List” as a category field per recipe. I have absolutely no idea how to count an array
Also, is this the best way to do it? Since these counts will be performed REGULARLY on page-display. If it would be less performance intense i would gladly use another storage method.
All help appreciated!!