aboutsummaryrefslogtreecommitdiffhomepage
diff options
context:
space:
mode:
-rw-r--r--apioforum/admin.py2
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)