number of errors=15
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 13353704 Ōta City PPLA2 13353705 Setagaya City PPLA2 13353708 Suginami City PPLA2 13353709 Toshima City PPLA2 13353710 Kita City PPLA2 13353711 Arakawa City PPLA2 13353712 Itabashi City PPLA2 13353713 Nerima City PPLA2 13353715 Katsushika City PPLA2 13353716 Edogawa City PPLA2 13353701 Kōtō PPLA2 13353702 Shinagawa City PPLA2 13353706 Shibuya City PPLA2 13353714 Adachi City PPLA2 13353694 Chiyoda City PPLA2