public class AccountCntCom {
    private Long id_user;
    private String username;
    protected Long cntCom;

    public AccountCntCom() { }
    
    public AccountCntCom(Long id_user, String username, Long cntCom) {
        this.id_user = id_user;
        this.username = username;
        this.cntCom = cntCom;
    }
    
    public Long getId_user() {
        return id_user;
    }

    public void setId_user(Long id_user) {
        this.id_user = id_user;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }
    
    public Long getCntCom() {
        return cntCom;
    }

    public void setCntCom(Long cntCom) {
        this.cntCom = cntCom;
    }
}

    @Override
    @Transactional
    public List<AccountCntCom> getAllUserCntCom(Integer FirstR, Integer MaxR) {

        String sqlQuery = "select ac.id_user, ac.username from Account ac";
        
        List list = sessionFactory.getCurrentSession().createQuery(sqlQuery)
            .setResultTransformer( Transformers.aliasToBean(AccountCntCom.class))
            .list();

        return list; 
    }

String sqlQuery = "select ac.id_user as id_user, ac.username as username from Account ac";

String sqlQuery = "select ac.id_user as id_user, ac.username as username, (select count(*) from Comment cm where cm.id_user = ac.id_user) as cntCom from Account ac";

    @ManyToOne(cascade = CascadeType.REFRESH, fetch = FetchType.LAZY)
        @JoinColumn(name = "id_user")
        private Account account;

        Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Category.class);
        criteria.add(Restrictions.eq("id_categ", id_categ));
        criteria.setFetchMode("articles", FetchMode.JOIN);

    select
        this_.id_categ as id1_3_1_,
        this_.catName as catName3_1_,
        this_.catTitle as catTitle3_1_,
        this_.id_par as id4_3_1_,
        articles2_.id_categ as id2_3_,
        article3_.id_article as id1_3_,
        article3_.id_article as id1_2_0_,
        article3_.artAutor as artAutor2_0_,
        article3_.artDescription as artDescr3_2_0_,
        article3_.artName as artName2_0_,
        article3_.artReyting as artReyting2_0_,
        article3_.artText as artText2_0_,
        article3_.artViews as artViews2_0_,
        article3_.coverPath as coverPath2_0_,
        article3_.dateUpload as dateUpload2_0_,
        article3_.enabled as enabled2_0_,
        article3_.id_user as id11_2_0_ 
    from
        category this_ 
    left outer join
        art_categ articles2_ 
            on this_.id_categ=articles2_.id_categ 
    left outer join
        article article3_ 
            on articles2_.id_article=article3_.id_article 
    where
        this_.id_categ=?

        Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Category.class);
        criteria.add(Restrictions.eq("id_categ", id_categ));
        criteria.setFetchMode("articles", FetchMode.JOIN);
        criteria.add( Expression.sql("article3_.enabled = 1"));