[Dkozikowski+]

Here is a quick solution without getting too crazy with MySQL joins:

http://pastie.textmate.org/private/j...oo2diqpsuzmj1w