如题,现在有一个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语句呢?求大神,整了一天的,一直报参数异常。