tags.sql

select tags.name , tags.id , count(taggables.id) as tags_ranks from taggables
 join tags on taggables.tag_id = tags.id
 join  graphics on  taggables.taggable_id = graphics.id
 left outer join sub_categories on graphics.sub_category_id = sub_categories.id
  left outer join categories on sub_categories.category_id = categories.id
  where categories.id = 1 and taggables.taggable_type = 'Graphics'
   group by tags.id order by tags_ranks DESC