SELECT aa.* FROM a_user aa WHERE version = ( SELECT max(version) FROM a_user WHERE type = aa.type ) ORDER BY aa.type desc