diff options
Diffstat (limited to 'site/app')
| -rw-r--r-- | site/app/Http/Controllers/PageFeedController.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/site/app/Http/Controllers/PageFeedController.php b/site/app/Http/Controllers/PageFeedController.php index ee4f3ec..0dd1b95 100644 --- a/site/app/Http/Controllers/PageFeedController.php +++ b/site/app/Http/Controllers/PageFeedController.php @@ -22,7 +22,7 @@ class PageFeedController extends Controller { if ($query != "") { $query .= " UNION "; } - $query .= "(SELECT spirit_type as name, image_url, spirit_type, spirit_type AS url, spirit_type AS feedname, '' AS linktext FROM ". $view ."_view WHERE original_price > 19.98 ORDER BY created_at DESC LIMIT 1)"; + $query .= "(SELECT spirit_type as name, image_url, spirit_type, spirit_type AS url, CONCAT(spirit_type,'-Feed') AS feedname, CONCAT('Zum ', spirit_type, '-Feed') AS linktext FROM ". $view ."_view WHERE original_price > 19.98 ORDER BY created_at DESC LIMIT 1)"; } # query mit festen parametern |