summaryrefslogtreecommitdiffhomepage
path: root/apioforum/forum.py
diff options
context:
space:
mode:
authorubq323 <ubq323>2021-06-14 16:08:17 +0000
committerubq323 <ubq323>2021-06-14 16:08:17 +0000
commit07fe2cd0b6d248a461aa5137ff416c3291eb88b7 (patch)
tree126b0e356ff065c58a75b6ee252b5c3dd3f45e1b /apioforum/forum.py
parent25353f2b7da79dc47c22f154b84e3fe92763ebfb (diff)
last activity by
Diffstat (limited to 'apioforum/forum.py')
-rw-r--r--apioforum/forum.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/apioforum/forum.py b/apioforum/forum.py
index e5d91f9..83362fc 100644
--- a/apioforum/forum.py
+++ b/apioforum/forum.py
@@ -14,7 +14,7 @@ def view_forum():
db = get_db()
threads = db.execute(
"""SELECT threads.id, threads.title, threads.creator, threads.created,
- threads.updated, count(posts.id) as num_replies
+ threads.updated, count(posts.id) as num_replies, max(posts.id), posts.author as last_user
FROM threads
INNER JOIN posts ON posts.thread = threads.id
GROUP BY threads.id