How to retrieve ADMIN exonym and synonym names from RDF

This is a list of ADMIN country names in all languages (exonyms) and all synonyms, currently available in raw data.

Use his query retrieve quickly the ADMIN exonym and synonym names for all ADMIN level. It works within SQL Developer environment.

Synonyms in the result list will be seen (filter) as NAME_TYPE = S.

NAME_TYPE = B (Base)

SQL Query:

SELECT ahr.ISO_COUNTRY_CODE,
ahr.ADMIN_ORDER,
fnsExo.IS_EXONYM,
fnsExo.NAME_TYPE,
fneExo.LANGUAGE_CODE,
fneExo.NAME,
fntExo.NAME AS NAME1,
fne.NAME AS Native
FROM RDF_ADMIN_HIERARCHY ahr
INNER JOIN RDF_FEATURE_NAMES fnsExo
ON ahr.ADMIN_PLACE_ID = fnsExo.FEATURE_ID
AND 'A' = fnsExo.OWNER
AND ((fnsExo.NAME_TYPE = 'B'
AND fnsExo.IS_EXONYM = 'Y')
OR fnsExo.NAME_TYPE = 'S')
INNER JOIN RDF_FEATURE_NAME fneExo
ON fnsExo.NAME_ID = fneExo.NAME_ID
LEFT JOIN RDF_FEATURE_NAME_TRANS fntExo
ON fneExo.NAME_ID = fntExo.NAME_ID
INNER JOIN RDF_FEATURE_NAMES fns
ON ahr.ADMIN_PLACE_ID = fns.FEATURE_ID
AND 'A' = fns.OWNER
AND 'N' = fns.IS_EXONYM
AND 'B' = fns.NAME_TYPE
INNER JOIN RDF_FEATURE_NAME fne
ON fns.NAME_ID = fne.NAME_ID
LEFT JOIN RDF_FEATURE_NAME_TRANS fnt
ON fne.NAME_ID = fnt.NAME_ID