How to list the most used labels in Confluence
Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.
As an administrator, I'd like to have the precise number of times each label has been added to a content.
The following query produces a list with the label name and the number of pages or attachments containing that label:
SELECT count(*) AS label_count, l.name AS label_name FROM label l JOIN content_label c_l ON l.labelid = c_l.labelid JOIN content c ON c.contentid = c_l.contentid WHERE l.namespace = 'global' GROUP BY label_name ORDER BY label_count DESC;