select
@r:=@r+1 as rank, name, votes
from
votes,
(select @r:=0) t
order by votes desc;