gistfile1.sql

--- Available models:
---
--- ActsAsTaggableOn::Tag
--- ActsAsTaggableOn::Tagging

SELECT "tags"."name",
       COUNT(*),
       bool_or("taggings"."tagger_id" = $1)
FROM "tags"
INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id"
WHERE "taggings"."taggable_id" = $2
  AND "taggings"."taggable_type" = $3
  AND (taggings.context = ('classifications'))
GROUP BY name);