关于 MYSQL 和HIBERNATE 的 语句问题

[zentaro]

那位大哥 有时间帮忙看一个这个MYSQL 的语句错在哪里了。是HIBERNATE 的。
select cg,b.jlhid from ContentGame as cg,(select t.jlhid,count(*) as c from ContentStat as t where t.jltype = 'game' and t.action = '0' group by t.jlhid order by t.c) as b where a.id = b.jlhid and cr.province = ? and cr.city = ? and cr.audited=1 limit 0,10