ReggieB

Jeff,

The problem does occur within a simpler SQL query. However, it only seems to become an ActiveRecord issue if there is a join involved. For example

Articl...

The last SQL is:

SELECT count(*) FROM (
  SELECT  *
  FROM `articles`
  INNER JOIN `articles_categories` ON `articles`.id =
`articles_categories`.article_id
 ...

It's easiest to use an example to explain the problem:

class Articles
  has_and_belongs_to_many categories
end

class Category
  has_and_belongs_to_many articl...