If you want to display a complete list of the tags used in a wordpress blog, you can retrive this from phpmyadmin using the following query with “wp_” table prefix (the default)
[php]
ELECT wp_terms.`term_id` AS TagID, wp_terms.`name` AS TagName, SUM( tax.`count` ) AS TagPostCount
FROM `wp_terms`
INNER JOIN wp_term_taxonomy tax ON tax.term_id = wp_terms.term_id
GROUP BY wp_terms.`term_id`
[/php]
Leave a Reply