From 8cfba341fff5ea48e8ae6556c4f40a8019bd4fb0 Mon Sep 17 00:00:00 2001 From: horus Date: Tue, 21 Apr 2020 11:41:58 +0200 Subject: Displays more data. --- database/migrations/2020_04_08_022413_add_view_anime_index.php | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'database/migrations') diff --git a/database/migrations/2020_04_08_022413_add_view_anime_index.php b/database/migrations/2020_04_08_022413_add_view_anime_index.php index 0ef516e..0d90043 100644 --- a/database/migrations/2020_04_08_022413_add_view_anime_index.php +++ b/database/migrations/2020_04_08_022413_add_view_anime_index.php @@ -29,7 +29,9 @@ class AddViewAnimeIndex extends Migration synopsis, hashtag, (SELECT score FROM stats as b WHERE b.mal_id = a.mal_id ORDER BY created_at ASC LIMIT 1) as score_begin, - (SELECT score FROM stats as b WHERE b.mal_id = a.mal_id ORDER BY created_at DESC LIMIT 1) as score_today + (SELECT score FROM stats as b WHERE b.mal_id = a.mal_id ORDER BY created_at DESC LIMIT 1) as score_today, + (SELECT watching FROM stats as b WHERE b.mal_id = a.mal_id ORDER BY created_at DESC LIMIT 1) as watching, + (SELECT members FROM stats as b WHERE b.mal_id = a.mal_id ORDER BY created_at DESC LIMIT 1) as members FROM anime as a JOIN -- cgit v1.2.3