diff options
Diffstat (limited to 'apioforum/admin.py')
| -rw-r--r-- | apioforum/admin.py | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/apioforum/admin.py b/apioforum/admin.py index e591a79..58690b9 100644 --- a/apioforum/admin.py +++ b/apioforum/admin.py @@ -17,5 +17,8 @@ def admin_page(): @admin_required def user_list(): db = get_db() - users = db.execute("select * from users order by joined desc;").fetchall() + users = db.execute("""select *, count(*) as n_posts from users + 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) |