diff options
Diffstat (limited to 'database.go')
| -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; `, } |
