As explained in this thread http://forums.oscommerce.com/topic/3...order-by-rand/ we can further decrease processing times using

and rand()>0.9 order by rand() desc limit 10

No files included here

More...