added DISTINCT to get*Result queries.
new entity listings.