relation = Project.
  joins(
    <<-SQL
      LEFT JOIN (
        SELECT
          bids.project_id,
          COUNT(bids.id) AS bid_count
        FROM bids
        GROUP BY bids.project_id
      ) bid_counts
        ON bid_counts.project_id = projects.id
    SQL
  ).
  order('bid_counts.bid_count').
  includes(:bids, :user).
  references(:users, :bids)

-- 
You received this message because you are subscribed to the Google Groups "Ruby 
on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rubyonrails-talk+unsubscr...@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rubyonrails-talk/0e187dcc-0285-4516-afef-1db14fb4f5e0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to