请教一下这个hql语句有什么问题，怎么修改

from Shopping where pfl = 2 and pname=any(select pname from (select pname from Shopping order by pworkoff desc) where rownum<7)