rails + mysql5.7で"Mysql2::Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'テーブル名.カラム名' which is not in SELECT list " - Qiita

ActionView::Template::Error: Mysql2::Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'portfolio1_test.users.name' which is not in SELECT list; this is incompatible with DISTINCT: SELECT DISTINCT `communities`.* FROM `communities` LEFT OUTER JOIN `community_users` ON `community_users`.`community_id` = `communities`.`id` LEFT OUTER JOIN `users` ON `users`.`id` = `com