Jan Prachař
--- a/mo/web/org.py
+++ b/mo/web/org.py
+
+    contests = []
+    for role in roles:
+        q = (sess.query(db.Contest, db.UserRole.role, db.Round)
+                .select_from(db.Contest)
+                .filter_by(place_id=role.place_id)
+                .join(db.UserRole, db.UserRole.user_role_id == role.user_role_id)
+                .join(db.Round))
+        if role.year:
+            q = q.filter(db.Round.year == role.year)
+        if role.category:
+            q = q.filter(db.Round.category == role.category)
+        if role.seq:
+            q = q.filter(db.Round.seq == role.seq)
+        contests += q.options(joinedload(db.Contest.place)).all()
+