@Entity
public class T {
    @Id 
    @Column(name="K1")
    private String key ;
    
    @Column(updatable=false)
    private String k2 = " ";

    private String a1 = " ";
    private String a2 = " ";
    private String a3 = " ";
    // ... 125 a columns
    private String a125 = " ";
    
    private double n1;
    private double n2;
    private double n3;
    // ... 95 n columns
    private double n95;
}

@Entity
public class X {
    @EmbeddedId     
    private PrimaryKeyPair key;

    private String a1;
    private String a2;
    private String a3;
    private String a4;
    private String a5;

    private double n1;
    private double n2;
    private double n3;
}

SELECT t FROM T t, X x 
WHERE t.key = x.a1 
  AND x.key.k1 = :partial 
  AND x.key.k2 LIKE :partialX 
ORDER BY x.key.k2"),