diff options
Diffstat (limited to 'database/migrations')
| -rw-r--r-- | database/migrations/2020_07_23_185334_add_airing_status_to_view_anime.php | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/database/migrations/2020_07_23_185334_add_airing_status_to_view_anime.php b/database/migrations/2020_07_23_185334_add_airing_status_to_view_anime.php index aa99e08..67f46ab 100644 --- a/database/migrations/2020_07_23_185334_add_airing_status_to_view_anime.php +++ b/database/migrations/2020_07_23_185334_add_airing_status_to_view_anime.php @@ -25,10 +25,11 @@ class AddAiringStatusToViewAnime extends Migration a.created_at, a.updated_at, episodes, - is_airing, synopsis, hashtag, airing_status, + (SELECT season_name FROM stats as b WHERE b.mal_id = a.mal_id ORDER BY created_at ASC LIMIT 1) as season_name, + (SELECT season_year FROM stats as b WHERE b.mal_id = a.mal_id ORDER BY created_at ASC LIMIT 1) as season_year, (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 watching FROM stats as b WHERE b.mal_id = a.mal_id ORDER BY created_at DESC LIMIT 1) as watching, @@ -41,7 +42,7 @@ class AddAiringStatusToViewAnime extends Migration score IS NOT null ORDER BY abs(score_today-score_begin) DESC, - is_airing DESC + airing_status ASC ;" ); } |