Rails - Apr 2006 - How to rubify this query

Hi guys,

i spent about 5 hours now of finding out how to rubify/railify this 
query!
Maybe someone of you can help me ;)

class Menu < ActiveRecord::Base
  validates_uniqueness_of :handle
  validates_presence_of :name, :sequence, :accesslevel, :defaultpage, 
:handle

  belongs_to :cmodule
  belongs_to :creator, :class_name => ''User'', :foreign_key
=>
''created_by''
  belongs_to :updater, :class_name => ''User'', :foreign_key
=>
''updated_by''
end

Now this is my query:
@menu = Menu.find_by_sql "SELECT self.* FROM menus self, menus remote
                           WHERE self.parent_id = remote.id
                            AND remote.handle = ''#{parent}''
                            AND self.accesslevel <= 
#{session[:user][:accesslevel]}
                           ORDER BY self.sequence"

Any ideas? thanks! ;)

-- 
Posted via http://www.ruby-forum.com/.