more_associations.rb

  has_and_belongs_to_many :normal_events, 
                          :join_table => 'events_practices', 
                          :conditions => "type = 'NormalEvent' AND status_id = #{Status[:published].id}",
                          :association_foreign_key => "event_id",
                          :order => 'starts_on ASC'
  has_and_belongs_to_many :normal_events_future, 
                          :class_name => 'NormalEvent', 
                          :join_table => 'events_practices', 
                          :conditions => "type = 'NormalEvent' AND status_id = #{Status[:published].id} AND starts_on >= '#{0.days.ago.to_s(:db)}'",
                          :association_foreign_key => "event_id",
                          :order => 'starts_on ASC'
  has_and_belongs_to_many :normal_events_past, 
                          :class_name => 'NormalEvent', 
                          :join_table => 'events_practices', 
                          :conditions => "type = 'NormalEvent' AND status_id = #{Status[:published].id} AND starts_on < '#{0.days.ago.to_s(:db)}'",
                          :association_foreign_key => "event_id",
                          :order => 'starts_on DESC' 
  has_and_belongs_to_many :campus_interviews, 
                          :join_table => 'events_practices', 
                          :conditions => "type = 'CampusInterview' AND status_id = #{Status[:published].id}",
                          :association_foreign_key => "event_id",
                          :order => 'starts_on ASC' 
  has_and_belongs_to_many :campus_interviews_future, 
                          :class_name => 'CampusInterview', 
                          :join_table => 'events_practices', 
                          :conditions => "type = 'CampusInterview' AND status_id = #{Status[:published].id} AND starts_on >= '#{0.days.ago.to_s(:db)}'",
                          :association_foreign_key => "event_id" ,
                          :order => 'starts_on ASC'
  has_and_belongs_to_many :campus_interviews_past, 
                          :class_name => 'CampusInterview', 
                          :join_table => 'events_practices', 
                          :conditions => "type = 'CampusInterview' AND status_id = #{Status[:published].id} AND starts_on < '#{0.days.ago.to_s(:db)}'",
                          :association_foreign_key => "event_id" ,
                          :order => 'starts_on DESC'