From 5902524fb85aaf760f3e6a6695b2390868a7bd06 Mon Sep 17 00:00:00 2001 From: horus Date: Sun, 21 Apr 2019 18:22:02 +0200 Subject: Improves view. --- database.go | 3 +++ 1 file changed, 3 insertions(+) diff --git a/database.go b/database.go index 99fa2a7..c455d87 100644 --- a/database.go +++ b/database.go @@ -65,6 +65,7 @@ SELECT CONCAT( platform.url, entry.url) AS url, language.name AS language, stars, + update_period.name as update_period, created_at FROM entry JOIN owner ON @@ -73,6 +74,8 @@ JOIN platform on entry.platform = platform.id JOIN language ON entry.language = language.id +JOIN update_period + ON entry.update_period = update_period.id ORDER BY created_at DESC; `, } -- cgit v1.2.3