I submitted a patch last week to solve the problem that limited eager-loaded find statements will usually drop any explicit joins. For instance…
Article.find(:all, :include => :author, :limit => 10, :joins => ‘INNER JOIN comments ON comments.article_id = articles.id’)
…is currently broken because the joins are not included on the prequery.
Test and Fix patches are ready to go. Should be a no-brainer to apply, just need a few +1