diff options
| author | horus | 2019-04-21 18:22:02 +0200 |
|---|---|---|
| committer | horus | 2019-04-21 18:22:02 +0200 |
| commit | 5902524fb85aaf760f3e6a6695b2390868a7bd06 (patch) | |
| tree | 614ee1f49f23d943ce9bbf300b3f8466be1e3306 | |
| parent | 3f5eaaaaedee0ef41719fa2f6a8e02446484d785 (diff) | |
| download | ghrss-5902524fb85aaf760f3e6a6695b2390868a7bd06.tar.gz | |
Improves view.
| -rw-r--r-- | database.go | 3 |
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; `, } |
