SELECT r.localityId, ln.name, r.regionCode 
FROM Region AS r 
      LEFT JOIN r.localityNames AS ln 
WHERE ln.localeIndex = :localeIndex AND r.country.localityId = :countryId 
ORDER BY ln.name

select r.locality_id as id, ln.name as name, r.region_code as abbreviation
from region r 
    left join region_locality_names rln ON rln.region = r.locality_id " +
        left join locality_name ln on ln.locality_name_id = rln.locality_names and ln.locale_index = :localeIndex 
WHERE r.country = :countryId

select r.locality_id as id, ln.name as name, r.region_code as abbreviation
from region r 
    left join region_locality_names rln ON rln.region = r.locality_id " +
        left join locality_name ln on ln.locality_name_id = rln.locality_names  
WHERE r.country = :countryId and ln.locale_index = :localeIndex

@Entity
@Table(name = "region")
 public   class  Region  extends  Locality {

    @Column(name = "region_code", length =  2 )
     private  String regionCode;

    @OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY)
    List<LocalityName> localityNames =  new  ArrayList<LocalityName>();
....
....

@Entity
@Table(name = "locality_name")
 public   class  LocalityName {

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    @Column(name = "locality_name_id")
     private   long  localityNameId;

     private  String name;

    @Column(name = "locale_index")
     private   int  localeIndex;

....
....

SELECT r.localityId, ln.name, r.regionCode FROM Region AS r 
LEFT JOIN r.localityNames AS ln WITH ln.localeIndex = :localeIndex 
WHERE r.country.localityId = :countryId 
ORDER BY ln.name