My first rails (1.1.6) model

zine.rb

class Zine < ActiveRecord::Base
  validates_presence_of :title, :downloads
  has_many :tag

  def self.latest
    find(:first,
         :select => "id",
         :order  => "id DESC")    
  end
  
  def self.recent(limit = 5)
    find(:all,
         :select => "id, title, subtitle, author",
         :limit => limit,
         :order  => "id DESC")
  end

  def self.tagged_zine_list(tag)
    find(:all,
         :select => "DISTINCT tags.zine_id, tags.tag, zines.id, zines.title", 
         :conditions => ["tags.tag = ?", tag],
         :joins => "INNER JOIN tags ON zine_id = zines.id")
  end  
end