Tag cloud

select "tag" as wordcloud_word, count(*) as wordcloud_count from (select * from blog_entry_tags join blog_tag on blog_tag.id = blog_entry_tags.tag_id) as results group by "tag" order by wordcloud_count desc