Alright, computer science majors, help needed:

A simple clustering algorythm; objects have tags assigned to them. How do I figure out which tags are "relate", in other words, if given a tag, which other tags have been used to tag the same movies?

It needs to be efficient in MySQL, and the tables look like this:

objects (id, ...)
tags2objects (tagid, objectid)
tags (id, ...)

# Feb 10, 2005