Gnarly Rails scope of the day

gnarly_rails_scope.rb

  # Projects a user has access to either through ProjectAssignment, or as an "account manager"
  named_scope :user_has_access_to, lambda{|user|
    {
      :select => 'DISTINCT projects.*',
      :joins => %q\
        LEFT JOIN project_assignments 
          ON (
            projects.id = project_assignments.project_id 
            AND project_assignments.has_access = 1
          )
        LEFT JOIN account_manager_memberships 
          ON (
            projects.client_id = account_manager_memberships.client_id 
            AND projects.client_type = account_manager_memberships.client_type
          )
      \,
      :conditions => [
        %q\
          (project_assignments.person_id = ?) 
          OR (account_manager_memberships.person_id = ?)
        \,
        user.id, user.id
      ]
    }
  }