From 14ffa8c832cf69fde25d1ea3641b179ac2d77c03 Mon Sep 17 00:00:00 2001 From: horus Date: Sun, 26 Jul 2020 19:53:04 +0200 Subject: Bugfix + seasons. --- .../migrations/2020_07_23_185334_add_airing_status_to_view_anime.php | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'database/migrations') 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 ;" ); } -- cgit v1.2.3