Pastie Support Pastie or read my Pastie << self blog

class Product < ActiveRecord::Base

  named_scope :online, :conditions => {:status => 1}, :include => [:variants, :catalogue_images, :categories]
  named_scope :from_category_ids, lambda { |cat_ids| {:conditions => "categories_products.category_id IN (#{cat_ids})", :include => :categories }}

end

class CatalogueController < RaidBase

  def category
    @products = Product.from_category_ids(@category.leaf_ids).online.paginate :page => params[:page], :per_page => params[:per_page]
  end
end