pepineitor

SELECT id, name, level, rang
FROM
(SELECT id, name, level, @num := @num +1 AS rang
FROM
(SELECT player.id, player.name, player.level, @num :=0
FROM player.player
LEFT JOIN player.player_index ON player_index.id = player.account_id
INNER JOIN account.account ON account.id=player.account_id
WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK'
ORDER BY player.level DESC
) AS t1
) AS t2
WHERE name LIKE '$VAR_NAME_EN_TU_FORMULARIO' LIMIT 1;