回答編集履歴
1
訂正
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
|
-
(
|
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
|
-
=> [
|
15
|
+
=> [980190962, 102]
|
16
16
|
|
17
17
|
```
|
18
18
|
|