Skip to content

Filters dont work, when WHERE in subselect #3

@hibo98

Description

@hibo98

Example Query:

SELECT ingredients.*,(SELECT COUNT(*) FROM recipeIngredients WHERE recipeIngredients.recipe = {$DB->escapeString($this->recipe)} AND recipeIngredients.ingredients = ingredients.id) AS included,provider.name AS providerName FROM ingredients LEFT JOIN provider ON provider.id = ingredients.provider

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions