#!/clair/bklimt/bin/python2.4
import pg

label_map = {}

conn = pg.connect('blog')
rs = conn.query('select * from blog_photo where deleted is null')
photos = rs.dictresult()
for photo in photos:
	#print '%s\t%s' % (photo['url'],photo['keywords'])
	keywords = photo['keywords'].split()
	for keyword in keywords:
		if keyword not in label_map:
			label_map[keyword] = []
		label_map[keyword] = label_map[keyword] + [photo['url']]
conn.close()

labels = [(len(label_map[k]),k) for k in label_map]
labels.sort()
labels = [label[1] for label in labels[::-1]]
labels = [(len(label_map[label]),label,label_map[label])[0:2] for label in labels]
labels = '\n'.join(['\t'.join([str(x) for x in row]) for row in labels])
print labels