Number of categories differs between the GUI and the API

Description

The total count of categories presented in the GUI significantly varies when compared to what is available through the API.

Reproduction
Steps to reproduce the behavior:

1. Add many recipes
2. Compare the numbers

Expected behavior
The numbers should be the same.

Actual behavior
The numbers are different. The numbers shown in the GUI are correct. The API numbers are wrong.

Screenshots

API

[
    {
        "name": "Asia",
        "recipe_count": 18
    },
    {
        "name": "Beilagen",
        "recipe_count": 12
    },
    {
        "name": "Braten",
        "recipe_count": 2
    },
    {
        "name": "Brotzeit",
        "recipe_count": 6
    },
    {
        "name": "Cocktails",
        "recipe_count": 2
    },
    {
        "name": "Dessert",
        "recipe_count": 42
    },
    {
        "name": "Dünsten",
        "recipe_count": 2
    },
    {
        "name": "Eis",
        "recipe_count": 8
    },
    {
        "name": "Fisch",
        "recipe_count": 26
    },
    {
        "name": "Fleisch",
        "recipe_count": 28
    },
    {
        "name": "Gebäck",
        "recipe_count": 12
    },
    {
        "name": "Gemüse",
        "recipe_count": 2
    },
    {
        "name": "Getränke",
        "recipe_count": 6
    },
    {
        "name": "Grillen",
        "recipe_count": 24
    },
    {
        "name": "Hauptgericht",
        "recipe_count": 40
    },
    {
        "name": "Kuchen",
        "recipe_count": 55
    },
    {
        "name": "Muffins",
        "recipe_count": 14
    },
    {
        "name": "Salate",
        "recipe_count": 20
    },
    {
        "name": "Schnelle Küche",
        "recipe_count": 2
    },
    {
        "name": "Soße",
        "recipe_count": 2
    },
    {
        "name": "Suppe",
        "recipe_count": 8
    },
    {
        "name": "Torten",
        "recipe_count": 38
    },
    {
        "name": "Veggie",
        "recipe_count": 14
    },
    {
        "name": "Vorspeise",
        "recipe_count": 12
    },
    {
        "name": "*",
        "recipe_count": 1
    }
]

GUI

Browser
Chrome 123.0

Versions
Nextcloud server version: 28.0.3
Cookbook version: 0.11.0
Database system: MariaDB

Reproduce the discrepancy by adding many recipes, then compare the category totals shown in the GUI with the API response using the reported Nextcloud 28.0.3, Cookbook 0.11.0, and MariaDB setup. Trace how each side calculates category counts; the work is done when both sources report the same numbers.