class Document < ActiveRecord::Base
  has_many :editions

  def self.published
    where %{
      EXISTS (
        SELECT 1 FROM editions AS published_editions
        WHERE published_editions.document_id = documents.id
        AND published_editions.state = 'published'
      )
    }
  end

  def published_edition
    editions.published.first
  end
end
class Document < ActiveRecord::Base
  has_many :editions
  has_one :published_edition, class_name: 'Edition', conditions: { state: 'published' }

  def self.published
    joins(:published_edition)
  end
end
Replace handcrafted sql with a defined association
Replace handcrafted sql with a defined association
