summaryrefslogtreecommitdiff
path: root/database.go
diff options
context:
space:
mode:
authorhorus2019-04-21 18:22:02 +0200
committerhorus2019-04-21 18:22:02 +0200
commit5902524fb85aaf760f3e6a6695b2390868a7bd06 (patch)
tree614ee1f49f23d943ce9bbf300b3f8466be1e3306 /database.go
parent3f5eaaaaedee0ef41719fa2f6a8e02446484d785 (diff)
downloadghrss-5902524fb85aaf760f3e6a6695b2390868a7bd06.tar.gz
Improves view.
Diffstat (limited to 'database.go')
-rw-r--r--database.go3
1 files changed, 3 insertions, 0 deletions
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;
`,
}