SELECT tag_id, count(tag_id) FROM posts_tags GROUP BY tag_id

does not work, I get the highest number of each tag but I need just the global highest number.