回答編集履歴

1

訂正

2017/02/04 09:54

投稿

katoy
katoy

スコア22324

test CHANGED
@@ -8,11 +8,11 @@
8
8
 
9
9
  ```
10
10
 
11
- > idea_ids = Idea.joins(:comments).group('ideas.id').order('count_ideas_id').limit(10).count('ideas.id').keys
11
+ > idea_ids = Idea.joins(:comments).group('ideas.id').order('count_ideas_id desc').limit(10).count('ideas.id').keys
12
12
 
13
- (0.3ms) SELECT COUNT(ideas.id) AS count_ideas_id, ideas.id AS ideas_id FROM "ideas" INNER JOIN "comments" ON "comments"."idea_id" = "ideas"."id" GROUP BY ideas.id ORDER BY count_ideas_id LIMIT ? [["LIMIT", 10]]
13
+ (4.6ms) SELECT COUNT(ideas.id) AS count_ideas_id, ideas.id AS ideas_id FROM "ideas" INNER JOIN "comments" ON "comments"."idea_id" = "ideas"."id" GROUP BY ideas.id ORDER BY count_ideas_id desc LIMIT ? [["LIMIT", 10]]
14
14
 
15
- => [102, 980190962]
15
+ => [980190962, 102]
16
16
 
17
17
  ```
18
18