alternate name in Japanese for relevant Japanese features

number of errors=0
number of warnings=0
Group=JP
Group=ckgGrpName

select geonameid,name,featurecode from geoname where countrycode='JP' and not exists (select 1 from alternatename where alternatename.geonameid=geoname.geonameid and namelocale='ja') and (featurecode in ('ADM1','ADM2','PPLA','PPLA2') or relevance>20)

geonameid	name	featurecode