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