1 files changed, 6 insertions, 6 deletions
diff --git a/synapse/storage/roommember.py b/synapse/storage/roommember.py
index cd9eefbd9f..41c939efb1 100644
--- a/synapse/storage/roommember.py
+++ b/synapse/storage/roommember.py
@@ -142,12 +142,12 @@ class RoomMemberStore(SQLBaseStore):
sql = (
"SELECT m.room_id, m.sender, m.membership, m.event_id, e.stream_ordering"
- " FROM room_memberships as m"
- " INNER JOIN current_state_events as c"
- " ON e.event_id = c.event_id "
- " INNER JOIN events as e "
- " ON m.event_id = c.event_id "
- " AND m.room_id = c.room_id "
+ " FROM current_state_events as c"
+ " INNER JOIN room_memberships as m"
+ " ON m.event_id = c.event_id"
+ " INNER JOIN events as e"
+ " ON e.event_id = c.event_id"
+ " AND m.room_id = c.room_id"
" AND m.user_id = c.state_key"
" WHERE %s"
) % (where_clause,)
|