SQL Query (ruby)

1
2
3
4
5
SELECT t.name, tt.count
  FROM wp_terms t
 INNER JOIN wp_term_taxonomy tt ON t.term_id = tt.term_id
 WHERE tt.taxonomy = 'post_tag'
   AND tt.count > 0;

The Raw Results (plain_text)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
debug	1                           
firebug	1
flow	1
praise	1
appreciation	1
txting	1
firefox	1
new	1
haml	1
ruby	11
textmate	1
rr	5
gem	1
hoe	1
mac	2
free	7
apps	2
software	1
mgrep	1
regex	6
unix	4
shell	6
examples	1
greasemonkey	2
js	3
find	1
replace	1
news	9
intro	1
clicky	1

The Filter [shell-unix-generic]

1
ruby -ne "a=split;puts (a[0]+' ') * a[1].to_i"

Now What? (plain_text)

1
2
Now paste the result into Wordle:
http://wordle.net/create