0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for administrators and users of the CiviCRM Constituent Relationship Management software

SELECT 
    Tags.TagName,
    COUNT(PostTags.PostId)
FROM
    Tags
    INNER JOIN PostTags ON Tags.Id = PostTags.TagId
    INNER JOIN Posts ON Posts.Id = PostTags.PostId
WHERE
    Posts.PostTypeId = 1 -- Only consider questions
GROUP BY 
    Tags.TagName;

fork query

edited aug 14

created aug 14 anonymous