SQl语句可以执行，HQL不行，为什么

[攻城尸]

多个表进行数据查询，传入一个参数作为条件，hql执行的结果一直为0，把打印出来的sql语句复制到数据库中，又能出结果，一直不明白，请问各位高手有什么解决方法。
下面是sql
select
count(*) as col_0_0_
from
TB_APPLIANCES applinaces0_ cross
join
TB_APPLIANCES_TYPE applinaces1_ cross
join
TB_APPLICANCES_APPLYFOR applinaces2_
where
applinaces0_.AP_TYPE_ID=applinaces1_.ID
and applinaces0_.ID=applinaces2_.AF_APPLICANCES_CODE
and applinaces2_.AF_DEFORMITY_CODE='83CA6AA3B2504DB4A5FF4B5435A09A93'
下面是hql
select a.id as applinacesId,a.apName as applinacesName,a.apPrice as applinacesPrice ,a.apYear as applinacesYear,t.afApplyforCount as applyForCount,ta.tpName as applinacesTypeName,t.afCreateDate as applyForCreateDate,t.information as DeformityCode from Applinaces a , ApplinacesType ta ,ApplinacesApplyFor t where a.appliancesType=ta.id and a.id=t.applinaces and t.information=:afDeformityCode order by t.afCreateDate desc