Selecting the lowest difference between values per user between two tables...

What do Gawker media uses as timestamp format?...

How exactly does "timestamp analysis" deter spam?...