summaryrefslogtreecommitdiff
path: root/database.go
diff options
context:
space:
mode:
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;
`,
}