Listing latest revision of each entity with envers
===

I am trying to retrieve the latest revision of **all** entities, that have not been deleted. Doing this in SQL is very simple with an subselect:

    select * from article_aud aud1
    where rev in
     (select max(rev) from article_aud aud2
      where aud1.id = aud2.id)
    and revtype < 2

But I do not have a clue, how to implement this via the envers API. I started with AuditReader but did not find a way, to select distinct objects

	List<Object[]> results = (List<Object[]>) getJpaTemplate().execute(new AuditReaderCallback() {
		@Override
		public Object doInAuditReader(AuditReader auditReader) {
			return auditReader.createQuery().forRevisionsOfEntity(Article.class, false, false)
				// TODO select distinct on entities
		        .addOrder(new PropertyAuditOrder(new RevisionNumberPropertyName(), false))
				.getResultList();
		}
	});

**Important**: I want to do this in one or at least two queries, because I have got many articles (entities) with many revisions.

Thanks a lot!