diff options
| author | rebecca <ubq323@ubq323.website> | 2026-10-30 23:40:43 +0000 |
|---|---|---|
| committer | rebecca <ubq323@ubq323.website> | 2026-10-30 23:40:43 +0000 |
| commit | 73296144f951a9a1fad1707bf9e17a602c93b246 (patch) | |
| tree | bb28024f29b059366af3b1b10c1b4109ccd4cb2c | |
| parent | ccba971d6786379d334aa75beef3068b9db81c48 (diff) | |
fix sql join
| -rw-r--r-- | apioforum/admin.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/apioforum/admin.py b/apioforum/admin.py index 58690b9..e42de54 100644 --- a/apioforum/admin.py +++ b/apioforum/admin.py @@ -18,7 +18,7 @@ def admin_page(): def user_list(): db = get_db() users = db.execute("""select *, count(*) as n_posts from users - join posts on posts.author = users.username + left outer join posts on posts.author = users.username group by users.username order by users.joined desc;""").fetchall() return render_template("admin/users.html",users=users) |