The easiest way to weed out duplicates is to log current Member of the day into a seperate table by MEMBERID, DATE then delete anything older than X months.

Just an idea :)

>Either there is something wrong with the SELECT statement logic or the mechanism for logging the last date that a user was featured, or Michel was playing with it and debugging it the first few days, and has now "started over" with the final version.

>I expect that we won't see duplications much longer