diff options
| author | horus | 2020-04-21 11:41:58 +0200 |
|---|---|---|
| committer | horus | 2020-04-21 11:41:58 +0200 |
| commit | 8cfba341fff5ea48e8ae6556c4f40a8019bd4fb0 (patch) | |
| tree | 5eed9cd50d9899144f9eb6d7d3aba00ea9997a28 /database/migrations | |
| parent | d6505098b79c8b891cc8a1f6a798cc3ff11253bd (diff) | |
| download | senpai-8cfba341fff5ea48e8ae6556c4f40a8019bd4fb0.tar.gz | |
Displays more data.
Diffstat (limited to 'database/migrations')
| -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 |