On Aug 17, 2007, at 2:16 AM, [EMAIL PROTECTED] wrote: > Yep, now I give 100$ US to anybody with a score a 20 on the pool > system > at the time the current message was written ;-)
That will cost you 11000 USD. :-) mysql> select count(distinct server_id) from log_scores where ts between '2007-08-17 10:00:00' and '2007-08-18 12:00:00' and score = 20; +---------------------------+ | count(distinct server_id) | +---------------------------+ | 128 | +---------------------------+ 1 row in set (0.57 sec) Just be thankful you didn't offer $100 to everyone with a score over 15; that'd have cost you about $80000. ;-) - ask -- http://develooper.com/ - http://askask.com/ _______________________________________________ timekeepers mailing list [email protected] https://fortytwo.ch/mailman/cgi-bin/listinfo/timekeepers
