原始sql语句转换成jpql语句

Question

如题，现在有一个sql语句：

SELECT c.* FROM fs_gulib a, fs_star c,(SELECT t2.id,COUNT(*) FROM fs_gulib_member t1 LEFT JOIN fs_gulib t2 ON t1.gulib = t2.id
GROUP BY t1.gulib ORDER BY COUNT(*) DESC) n WHERE a.id=c.gulib_id AND a.id=n.id;

如何转成jpql语句呢？求大神，整了一天的，一直报参数异常。

Answer 1

http://bbs.csdn.net/topics/391941983