Simon Willison’s Weblog
A word cloud of all of the tags I've used across my blog entries, blogmarks and quotations.
Owned by simonw, visibility: Public
select "tag" as wordcloud_word, count(*) as wordcloud_count from (select blog_tag.tag from blog_entry_tags join blog_tag on blog_entry_tags.tag_id = blog_tag.id union all select blog_tag.tag from blog_blogmark_tags join blog_tag on blog_blogmark_tags.tag_id = blog_tag.id union all select blog_tag.tag from blog_quotation_tags join blog_tag on blog_quotation_tags.tag_id = blog_tag.id) as results where tag != 'quora' group by "tag" order by wordcloud_count desc