Entity
@IdClass(WebSiteModule.PK.class)
@Table(name = "websiteModule")
public class WebSiteModule implements Serializable {

    @Id
    private String name;

    @Id
    @ManyToOne 
    private WebSite site;

    public static class PK implements Serializable{
        private String name;
        private Integer site;

        public PK() {

        }

        public PK(String name, Integer site) {
            this.name = name;
            this.site = site;
        }
        
    }
}

select websitemod0_.id_name as id_name1_20_, websitemod0_.id_site_id as id_site_5_20_, websitemod0_._identifierMapper_name as _identif2_20_, websitemod0_._identifierMapper_site_id as _identif6_20_ 
from websiteModule websitemod0_ 
where websitemod0_._identifierMapper_site_id=?