title: Rails scope overriding select
body: <p>I have a model with a has_many relationship, and a scope to determine whether or not it has any children, such as:</p>
  
  <pre><code>  scope :with_nomination, :include =&gt; [:nomination], :conditions =&gt; "nominations.service_id IS NOT NULL"
  </code></pre>
  
  <p>Using this, I can do something like <code>Service.with_nomination</code> and receive a list of all services with nomination children.</p>
  
  <p>The problem is that when I do something like <code>Service.select("id, firstName, lastName").with_nomination</code> ActiveRecord in essense does a <code>SELECT * FROM services</code> which is very bad and does not utilize the indexes I so painstakingly set up.</p>
  
  <p>How can I either rephrase my query or modify my scopes to work with the .select() command?</p>