SELECT name
FROM pokemon AS this
WHERE EXISTS (
    SELECT DISTINCT pokemon_id
    FROM pokemon_moves
    JOIN pokemon ON pokemon_id = pokemon.id
    WHERE evolution_chain_id = this.evolution_chain_id
    AND canevolve =1
    AND pokemon.order <= this.order
    AND move_id =92
    LIMIT 1
);