# how to sort joined tables?

**URL:** <https://discuss.rubyonrails.org/t/how-to-sort-joined-tables/70804>\
**Category:** rubyonrails-talk\
**Created:** [June 25, 2015, 10:56am UTC](https://discuss.rubyonrails.org/t/how-to-sort-joined-tables/70804 "2015-06-25T10:56:41Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![11155](https://avatars.discourse-cdn.com/v4/letter/1/d26b3c/32.png) [@11155](https://discuss.rubyonrails.org/u/11155)\
**Post date:** [June 25, 2015, 10:56am UTC](https://discuss.rubyonrails.org/t/how-to-sort-joined-tables/70804/1 "2015-06-25T10:56:41Z")

</div>

help please write orm-request.

tables: users: id: integer name: varchar

posts: id: integer title: varchar user\_id: integer views: integer

models: User: class User \< ActiveRecord::Base &nbsp;&nbsp;has\_many :posts, dependent: :destroy end

Posts: class Post \< ActiveRecord::Base &nbsp;&nbsp;belongs\_to :user end

controller: def popular\_diary &nbsp;&nbsp;@users = User.joins(:posts).group\_by(:user\_id).order('SUM(posts.views)') end

html: &nbsp;&nbsp;\<% @users.each do |user| %\> &nbsp;&nbsp;&nbsp;&nbsp;\<div class="row"\> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<%= link\_to user\_posts\_url(user.id) do %\> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<div\>\<%= user.name %\>\</div\> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<% end %\> &nbsp;&nbsp;&nbsp;&nbsp;\</div\> &nbsp;&nbsp;\<% end %\>

I need that all users hatched in a certain order. order ('SUM (posts.views)

The problem is that the screen displays the following error message: wrong number of arguments (0 for 1)

---

<div class="post-metadata">

**Author:** ![Tamara\_Temple](https://avatars.discourse-cdn.com/v4/letter/t/c37758/32.png) [@Tamara\_Temple](https://discuss.rubyonrails.org/u/Tamara_Temple)\
**Post date:** [June 25, 2015, 11:01am UTC](https://discuss.rubyonrails.org/t/how-to-sort-joined-tables/70804/2 "2015-06-25T11:01:30Z")

</div>

Look near the error message it will show you what line the error occurred at.

---

<div class="post-metadata">

**Author:** ![11155](https://avatars.discourse-cdn.com/v4/letter/1/d26b3c/32.png) [@11155](https://discuss.rubyonrails.org/u/11155)\
**Post date:** [June 25, 2015, 11:06am UTC](https://discuss.rubyonrails.org/t/how-to-sort-joined-tables/70804/3 "2015-06-25T11:06:32Z")

</div>

tamouse m. wrote in post #1175655:

> Look near the error message it will show you what line the error occurred at.

[http://joxi.ru/1A5RvGah55YwrE](http://joxi.ru/1A5RvGah55YwrE)

---

<div class="post-metadata">

**Author:** ![11155](https://avatars.discourse-cdn.com/v4/letter/1/d26b3c/32.png) [@11155](https://discuss.rubyonrails.org/u/11155)\
**Post date:** [June 25, 2015, 11:30am UTC](https://discuss.rubyonrails.org/t/how-to-sort-joined-tables/70804/4 "2015-06-25T11:30:21Z")

</div>

sorry. i replace 'group\_by' on 'group' and it worked)