i wish to obtain the following information from wordpress database connect with Tag

TagID TagName TagPostCount

Are anybody let me know and write a mysql command that provide me listing of this three detailed.

do not show me PHP code. i'm not actually want to learn about them and off-course i'm connect with PHP.

the way i can write a Mysql command who produce these three detailed.

It is a MYSQL query against a wordpress db with "wordpress_" table prefix (the default)

SELECT 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`