diff options
author | ubq323 <ubq323> | 2021-06-14 16:08:17 +0000 |
---|---|---|
committer | ubq323 <ubq323> | 2021-06-14 16:08:17 +0000 |
commit | 07fe2cd0b6d248a461aa5137ff416c3291eb88b7 (patch) | |
tree | 126b0e356ff065c58a75b6ee252b5c3dd3f45e1b /apioforum/forum.py | |
parent | 25353f2b7da79dc47c22f154b84e3fe92763ebfb (diff) |
last activity by
Diffstat (limited to 'apioforum/forum.py')
-rw-r--r-- | apioforum/forum.py | 2 |
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 |