spotlight.rb

  named_scope :magic, lambda { 
    { 
      :joins => "INNER JOIN airings ON airings.id=spotlights.object_id INNER JOIN episodes ON episodes.id=airings.episode_id",
      :conditions => ["object_type='Airing' AND airings.ends_at < ? AND episodes.video IS NOT NULL", DateTime.now.utc],
      :order => "airings.ends_at DESC",
      :group => "airings.id"
    } 
  }