问在Android和SQLite中只获取一组特定有序记录的一行

EN

public List<MenuItem> findMenus(Long menuItem) throws Exception {
        if(menuItem == null) menuItem = -1l;

        SQLiteQueryBuilder _QB = new SQLiteQueryBuilder();
        _QB.setTables("MenuItem m INNER JOIN Language l ON m.languageCode=l.code");

        String[] rows = _fields.keySet().toArray(new String[0]);
        for(int i = 0; i < rows.length; i++){
            rows[i] = "m." + rows[i];
        }
        Cursor cursor = _QB.query(_db, rows, "m.parentId=? AND m.published=? AND l.enabled='1'", new String[] {String.valueOf(menuItem), String.valueOf(1)}, null, null, "m.level, l.level", null);

        List<MenuItem> list = new ArrayList<MenuItem>(cursor.getCount());
        if (cursor.moveToFirst()) {
            do {
                MenuItem item = getObject(cursor);
                list.add(item);
            } while (cursor.moveToNext());
        }
        cursor.close();
        return list;
    }

ID  CommonId  Level Lang
------------------------
1   6         1     EN
2   6         1     DE
3   6         1     IT
4   21        2     DE
5   21        2     IT
6   8         3     EN
7   4         4     EN
8   4         4     IT

What I would like as a result is
ID  CommonId  Level Lang
------------------------
1   6         1     EN
4   21        2     DE
6   8         3     EN
7   4         4     EN


This would be the result if the language would have the following order
Lang  Level
----------
EN    1
DE    2
IT    3