This is the query:

NativeQuery query = entityManager.createNativeQuery("select

" +
"from CONFANCESTORS ancestors, CONTENT

.CONTENTID = ancestors.DESCENDENTID " +
"and ancestors.ANCESTORID = ? " +
"order by

.CONTENTID", "confpage", Page.class);
query.setCacheable(true);
query.setLong(1, page.getId());
return query.list();