VIEW v_username_validado

 CREATE VIEW v_username_validado AS

SELECT idUsername, username

FROM status_username JOIN username USING(idUsername)

WHERE idStatusUsername

IN(SELECT MAX(idStatusUsername)

FROM status_username

WHERE status_username = 2 GROUP BY idUsername);