X-Git-Url: http://git.cyclocoop.org/?p=cavote.git;a=blobdiff_plain;f=main.py;h=d7bb5e9fab28735177f20e97d846b2a31a7e3195;hp=3effbb2a410fd3c0dc2f25652e75940e8cdafad0;hb=7f235db921ed9e01ae8c8057bc35f6796284808d;hpb=136c353bf4a1c864d8efd90609732f2ba886b7e0

diff --git a/main.py b/main.py
index 3effbb2..d7bb5e9 100755
--- a/main.py
+++ b/main.py
@@ -287,7 +287,7 @@ def admin_user_add():
 def admin_groups():
     if not session.get('user').get('is_admin'):
         abort(401)
-    groups = query_db('select * from groups')
+    groups = query_db('select groups.*, count(user_group.id_user) as nb_users from (select groups.*, count(votes.id) as nb_votes from groups left join votes on votes.id_group = groups.id group by groups.id) as groups left join user_group on user_group.id_group = groups.id group by groups.id')
     return render_template('admin_groups.html', groups=groups)
 
 @app.route('/admin/groups/add', methods=['POST'])