Anonymous

        String q = "select max(i.intressentid) from intressent i" +
                "left join intrintresseanmalan iia " +
                "on i.intressentid = iia.intressentid " +
                "where iia.intressentid is null";