More readable SQL query.

1 files changed, 7 insertions, 3 deletions

diff --git a/app/finders/members_finder.rb b/app/finders/members_finder.rb
index 2ec6cc456af..4734d97b8c7 100644
--- a/app/finders/members_finder.rb
+++ b/app/finders/members_finder.rb
@@ -38,9 +38,13 @@ class MembersFinder
       <<~SQL
           SELECT DISTINCT ON (user_id, invite_email) member_union.*
           FROM (#{union.to_sql}) AS member_union
-          ORDER BY
-            user_id, invite_email,
-            CASE WHEN type = 'ProjectMember' THEN 1 WHEN type = 'GroupMember' THEN 2 ELSE 3 END
+          ORDER BY user_id,
+            invite_email,
+            CASE
+              WHEN type = 'ProjectMember' THEN 1
+              WHEN type = 'GroupMember' THEN 2
+              ELSE 3
+            END
       SQL
     else
       # Older versions of MySQL do not support window functions (and DISTINCT ON is postgres-specific).