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