StringBuffer sb = new StringBuffer();

        sb.append("select g.CGD_ID from em_circle_apply_info a join em_circle_group_def g on a.CAI_CGD_ID = g.CGD_ID ");

        if (size != null) {

            sb.append(" where rownum < " + (size+1));

        }

        sb.append(" group by a.CAI_CGD_ID order by count(a.CAI_CGD_ID) desc ");

        Query query = this.getSession().createSQLQuery(sb.toString()).addScalar("CGD_ID", StandardBasicTypes.LONG);

　　　　 StringBuffer sb = new StringBuffer();
　　　　 sb.append("select t.caiCgdId.cgdId from EmCircleApplyInfo t ");

        if (size != null) {

            sb.append(" where rownum < " + (size+1));

        }

        sb.append(" group by t.caiCgdId.cgdId order by count(t.caiCgdId) desc");

        Query query = this.getSession().createQuery(sb.toString()).setCacheable(true);

        List<BigDecimal> idList = query.list();

        List<Long> ids = new ArrayList<Long>();

        List<Long> ids = query.list();