public List<Object[]> getHistogram(Long limit)
    {       
        return (List<Object[]>) session.createQuery
                ("select type, count(name)" +
                 " from " + (select" + (limit == null ? "" : " limit 0 " + limit) + " *" +                 
                 " from " + PLAYER_TABLE_NAME +
                 " order by acres desc" + ")" +
                 " group by type" +
                 " order by count(name) desc").list();
    }