# How to change a query "objective"

**URL:** <https://www.ruby-forum.com/t/how-to-change-a-query-objective/191043>\
**Category:** Rails\
**Created:** [July 3, 2010, 12:13pm UTC](https://www.ruby-forum.com/t/how-to-change-a-query-objective/191043 "2010-07-03T12:13:02Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![steffoz](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/2bfe46/32.png) [@steffoz](https://www.ruby-forum.com/u/steffoz)\
**Post date:** [July 3, 2010, 12:13pm UTC](https://www.ruby-forum.com/t/how-to-change-a-query-objective/191043/1 "2010-07-03T12:13:02Z")

</div>

Quick question:

> > Group.first.resources.joins(:tags).group(“tags.id”).select(“tags.id, count(\*)”)  
> > =\> [#\<Resource id: 1\>, #\<Resource id: 2\>, #\<Resource id: 3\>,  
> > #\<Resource id: 4\>, #\<Resource id: 5\>]

This results in the following (correct) query:

“SELECT tags.id, count(\*) FROM “resources” INNER JOIN “taggings” ON  
“resources”.“id” = “taggings”.“resource\_id” INNER JOIN “tags” ON  
“tags”.“id” = “taggings”.“tag\_id” INNER JOIN “group\_resources” ON  
“resources”.id = “group\_resources”.resource\_id WHERE  
((“group\_resources”.group\_id = 1)) GROUP BY tags.id”

I don’t want the Resources, I want the damn Tags. Any clues?