How to Optimize Rank Data in MySQL
Subject:   Great writeup.
Date:   2007-10-18 17:17:59
From:   mwadhera
Thanks for sharing your knowledge about ranked tables in mysql. This is a very informative article.

It seems there is a small bug in the example you show on Page 4:

least(0, @game := game)),
pos_in_game = @pos

I believe pos_in_game should be rank_in_game...