diff options
| author | horus | 2026-03-29 22:15:13 +0200 |
|---|---|---|
| committer | horus | 2026-03-29 22:15:13 +0200 |
| commit | 0fe83c7f76b2fd6ce79541a71cdde5ec0b12becf (patch) | |
| tree | 7d652e6a1941cc18dfd624af4491fd14fb4a08c2 /app/Http | |
| parent | dc317981311d42664375484e777b20e81f41e841 (diff) | |
| download | curious-0fe83c7f76b2fd6ce79541a71cdde5ec0b12becf.tar.gz | |
Diffstat (limited to 'app/Http')
| -rw-r--r-- | app/Http/Controllers/FeedController.php | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/app/Http/Controllers/FeedController.php b/app/Http/Controllers/FeedController.php index 6dadf8f..9d20fce 100644 --- a/app/Http/Controllers/FeedController.php +++ b/app/Http/Controllers/FeedController.php @@ -18,6 +18,7 @@ class FeedController extends Controller $articles = Article::join('discussion', 'discussion.article_id', '=', 'view_article.id') ->select('view_article.id', 'view_article.article_id', 'view_article.url', 'view_article.title', 'view_article.excerpt_html', 'view_article.impact', 'view_article.upvotes', 'view_article.comments', 'view_article.repost') ->groupBy('view_article.id', 'view_article.article_id', 'view_article.url', 'view_article.title', 'view_article.excerpt_html', 'view_article.impact', 'view_article.upvotes', 'view_article.comments', 'view_article.repost') + ->where('view_article.created_at', '<', now()->subMinutes(30)) ->orderByRaw('MAX(discussion.posted_on) DESC') ->take(20) ->get(); @@ -30,6 +31,7 @@ class FeedController extends Controller $articles = Article::join('discussion', 'discussion.article_id', '=', 'view_article.id') ->select('view_article.id', 'view_article.article_id', 'view_article.url', 'view_article.title', 'view_article.excerpt_html', 'view_article.impact', 'view_article.upvotes', 'view_article.comments', 'view_article.repost') ->groupBy('view_article.id', 'view_article.article_id', 'view_article.url', 'view_article.title', 'view_article.excerpt_html', 'view_article.impact', 'view_article.upvotes', 'view_article.comments', 'view_article.repost') + ->where('view_article.created_at', '<', now()->subMinutes(30)) ->orderByRaw('MAX(discussion.posted_on) DESC') ->take(20) ->get(); @@ -40,6 +42,7 @@ class FeedController extends Controller $articles = Article::join('discussion', 'discussion.article_id', '=', 'view_article.id') ->select('view_article.id', 'view_article.article_id', 'view_article.url', 'view_article.title', 'view_article.excerpt_html', 'view_article.impact', 'view_article.upvotes', 'view_article.comments', 'view_article.repost') ->groupBy('view_article.id', 'view_article.article_id', 'view_article.url', 'view_article.title', 'view_article.excerpt_html', 'view_article.impact', 'view_article.upvotes', 'view_article.comments', 'view_article.repost') + ->where('view_article.created_at', '<', now()->subMinutes(30)) ->orderByRaw('MAX(discussion.posted_on) DESC') ->take(20) ->get(); |