def self.find_for(options = {})
    scope = scoped
    scope = scope.where(:hook => options[:hook].to_s)  if options[:hook]
...

# link_categories has_many links
create_table "link_categories", :force => true do |t|
  t.string   "name"
...

Clip.find_by_sql(["select * from clips where not exists
        (select 'clip_id' from histories where histories.clip_id = clips.id
        and histories.user_id = ?) ORDER BY clips.created_at DESC LIMIT 20", user.id])

class Item < ActiveRecord::Base
  ALL_VOTES = "all_votes"
  SCORE = "score"
...

#players = select distinct(player) from actions;
    players = repository(:default).adapter.query('select distinct(player) from actions')

...