diff options
| -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 e42de54..7ad1d39 100644 --- a/apioforum/admin.py +++ b/apioforum/admin.py @@ -17,7 +17,7 @@ def admin_page(): @admin_required def user_list(): db = get_db() - users = db.execute("""select *, count(*) as n_posts from users + users = db.execute("""select *, count(posts.id) as n_posts from users left outer join posts on posts.author = users.username group by users.username order by users.joined desc;""").fetchall() |