double JOIN and GROUP on hasMany associations

double JOIN and GROUP on hasMany associations

References

Reference NO 1

http://stackoverflow.com/questions/15191986/double-join-and-group-on-hasmany-associations

Reference NO 2

http://stackoverflow.com/questions/5835696/rails-has-many-through-associations-find-with-and-condition-not-or-conditio

Reference NO 3

http://book.cakephp.org/2.0/en/models/associations-linking-models-together.html

Reference NO 4

http://apidock.com/rails/ActiveRecord/Base/find/class

Reference NO 5

http://apidock.com/rails/ActiveRecord/Associations/ClassMethods

Reference NO 6

http://geoff.evason.name/2010/04/23/nested-has_many-through-in-rails-or-how-to-do-a-3-table-join

Reference NO 7

http://dev.mysql.com/doc/en/select.html

Reference NO 8

http://www.phpactiverecord.org/projects/main/wiki/Finders