Fix TagsForResource query

The query confused resource_types with resource_tags
and mentioned the r_types table a few times.
Since there is no need to join the r_types table
at all, this commit removes it altogether.