[Vince]

I fail to see the problem. You're ordering by "ClanScore", but since all values are 0 MySQL is free to order it in whatever way it wants, which is apparently descending by id. The limit clause is the very last thing that gets applied and what "limit 0,1" actually means is: start with the 0th result in the result set and get the next 1 rows.