Rails 3 ActiveRecord: Order by count on association

by

Using named scopes:

class Song
  has_many :listens
  scope :top5,
    select("songs.id, OTHER_ATTRS_YOU_NEED, count(listens.id) AS listens_count").
    joins(:listens).
    group("songs.id").
    order("listens_count DESC").
    limit(5)

Song.top5 # top 5 most listened songs

More Related Contents:

  1. how to use DISTINCT ON with mysql using ActiveRecord
  2. Error installing mysql2: Failed to build gem native extension
  3. Library not loaded: libmysqlclient.16.dylib error when trying to run ‘rails server’ on OS X 10.6 with mysql2 gem
  4. Eager load polymorphic
  5. Mysql::Error: Specified key was too long; max key length is 1000 bytes
  6. Rails, MySQL and Snow Leopard
  7. Rails order by results count of has_many association
  8. How to chain scope queries with OR instead of AND?
  9. When to use a “has_many :through” relation in Rails?
  10. Rails 3: Get Random Record
  11. Setting session timeout in Rails 3
  12. Alias for column names in Rails
  13. Rails 3 devise, current_user is not accessible in a Model ?
  14. Ruby on Rails 3 Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ on OSX
  15. MySQL Install: ERROR: Failed to build gem native extension
  16. Rails 3 – select with Include?
  17. belongs_to through associations
  18. Check if record exists from controller in Rails
  19. How to delete duplicate records in mysql database?
  20. Validate uniqueness of multiple columns
  21. rails + MySQL on OSX: Library not loaded: libmysqlclient.18.dylib
  22. Find all records which have a count of an association greater than zero
  23. What the difference between mysql and mysql2 gem
  24. PGError: ERROR: aggregates not allowed in WHERE clause on a AR query of an object and its has_many objects
  25. uninitialized constant MysqlCompat::MysqlRes (using mms2r gem)
  26. Rails select random record
  27. Ruby on Rails – cannot load such file — mysql2/2.2/mysql2 (LoadError)
  28. undefined method `eq’ for nil:NilClass with rails 3 and ruby enterprise on ubuntu hardy
  29. Specifying column name in a “references” migration
  30. Rails: Order with nulls last

Leave a Comment