原始sql语句转换成jpql语句

[qq_29906709]

如题，现在有一个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;

[qq_29906709]

fs_gulib，fs_star是实体表，fs_gulib_member是fs_gulib和fs_member的多对多关联表

[qq_29906709]

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

[jamesge2010]

引用 楼主 qq_29906709 的回复:

如题，现在有一个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;

group by t1.gulib?? 不是t2.id??