问SQL到JPQL，如何查询嵌套JPQL

EN

select
    c.*
from
    cheat c
    left join (select * from cheat_vote where val = 1) v on c.cheat_seq = v.cheat_fk
group by
    c.cheat_seq
having
    count(*) < 10
limit 5

public class Cheat implements Serializable{

    private static final long serialVersionUID = 1L;

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "cheat_seq", length = 10)
    private Long cheatSeq;

    @Column(name = "question", unique = true, nullable = false)
    private String question;

    @Column(name = "answer", unique = true, nullable = false)
    private String answer;

    @Column(name = "writer_ip", nullable = false)
    private String writerIP;

    @Temporal(TemporalType.TIMESTAMP)
    @Column(name = "reg_date", nullable = false)
    private Date regDate;

    @Transient
    private String regDateText;

    @OneToMany(mappedBy = "cheat", fetch=FetchType.LAZY)
    private Set<CheatVote> vote;

    @Override
    public String toString() {
        return "Cheat [cheatSeq=" + cheatSeq + "]";
    }


}

public class CheatVote implements Serializable{

    private static final long serialVersionUID = 1L;

    @GeneratedValue(strategy=GenerationType.IDENTITY)
    @Id
    @Column(name="seq", nullable=false)
    private Long seq;

    @Column(name="val", nullable=false)
    @NonNull
    private Integer value;

    @Column(name="ip_address", nullable=false)
    @NonNull
    private String ipAddress;

    @JoinColumn(name="cheat_fk", referencedColumnName="cheat_seq")
    @ManyToOne(cascade=CascadeType.ALL, fetch=FetchType.LAZY)
    @NonNull
    private Cheat cheat;

    @Override
    public String toString() {
        return "CheatVote [seq=" + seq + "]";
    }


}