qiita
SELECT t.tag_name, COUNT(t.tag_name) AS count
FROM mt_tag AS t, mt_objecttag AS o
WHERE t.tag_id = o.objecttag_tag_id AND o.objecttag_object_datasource = "entry" AND o.objecttag_blog_id = 1
GROUP BY t.tag_name HAVING COUNT(t.tag_name) > 0
INTO OUTFILE "ファイル名.csv"
FIELDS TERMINATED BY ",";
参考URL
http://keywordsmemo.blogspot.jp/2011/02/movable-type.html
http://phpjavascriptroom.com/?t=mysql&p=join
http://sasuke.main.jp/sqlcsv.html
http://yoshiomemo.blog115.fc2.com/blog-entry-32.html
http://kawama.jp/archives/2009/11/mysql_7.html