}
List queryResults = query.getResultList();
List results = new ArrayList();
for (Iterator iter = queryResults.iterator(); iter.hasNext();) {
Object[] row = (Object[]) iter.next();
StatCount sc = new StatCount(
(String)row[1], // website id
(String)row[2], // website handle
(String)row[3], // website name
"statCount.weblogCommentCountType", // stat type
((Long)row[0]).longValue()); // # comments
sc.setWeblogHandle((String)row[2]);
results.add(sc);
}
// Original query ordered by desc # comments.
// JPA QL doesn't allow queries to be ordered by agregates; do it in memory
Collections.sort(results, statCountCountReverseComparator);