Bugfix + seasons.

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
 		    ;"
 	    );
     }