diff options
Diffstat (limited to 'app/Http/Controllers/FeedController.php')
| -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(); |