gistfile1.rb

  scope :errors,    -> { where(http_status: 404) }
  scope :archives,  -> { where(http_status: 410) }
  scope :redirects, -> { where(http_status: 301) }
  scope :other,     -> { where('http_status NOT IN (?)', [404, 410, 301]) }

  def self.aggregated
    scoped.select('hits.path, sum(hits.count) as count, hits.http_status, hits.host_id').group(:path_hash, :http_status)
  end