Basically an equivalent of this:

SELECT c.* FROM ConfigProperty_AUD c

INNER JOIN

(SELECT id, REVTYPE, MAX(REV) as latest from ConfigProperty_AUD WHERE REV<=8 GROUP BY id ) c1

ON c1.id=c.id AND c1.latest=c.REV AND c.REVTYPE!=2

I believe this solves it:

        AuditQuery query = reader.createQuery().forRevisionsOfEntity(ConfigProperty.class, false, false);

        query.add(AuditEntity.revisionNumber().maximize().add(AuditEntity.revisionNumber().le(rev)).computeAggregationInInstanceContext());