diff options
Diffstat (limited to 'database')
| -rw-r--r-- | database/migrations/2020_04_08_022413_add_view_anime_index.php | 4 |
1 files changed, 3 insertions, 1 deletions
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 |