I did something like this yesterday. The only problem is that I spent all night dreaming of SQL statements to implement the solution. YMMV if you have trouble

I did something like this yesterday. The only problem is that I spent all night dreaming of SQL statements to implement the solution. YMMV if you have trouble turning your brain off it seems.