-
- has_many :comments, :class_name => "DiaryComment",
- :include => :user,
- :order => "diary_comments.id"
- has_many :visible_comments, :class_name => "DiaryComment",
- :include => :user,
- :conditions => {
- :users => { :status => ["active", "confirmed" ] },
- :visible => true
- },
- :order => "diary_comments.id"
+
+ has_many :comments, -> { order(:id).preload(:user) }, :class_name => "DiaryComment"
+ has_many :visible_comments, -> { joins(:user).where(:visible => true, :users => { :status => ["active", "confirmed"] }).order(:id) }, :class_name => "DiaryComment"
+
+ scope :visible, -> { where(:visible => true) }