dummy.rb

Site.joins(:user).select('sites.user_id, count(*) as count').group('sites.user_id')

<Site user_id: 1> #should have a count of 2

# returns only the user_id. If I cheat and name the 'count' column the same name as another column on my model it returned. 

Site.joins(:user).select('sites.user_id, count(*) as id').group('sites.user_id') #BAD!

<Site id: 2, user_id: 1> #id == count in this result

Each returned object should have a count attribute with the count assigned.

Testing locally:

User.joins(:favourites).select('users.id, count(*) as count').group('users.id').first.count
"3"

Hi Kevin,

That was the trick.

Thanks