$sth = $dbh->prepare('Select @rownum:=@rownum+1 rank, p.* from player p, (SELECT @rownum:=0) r order by score desc limit 10');