Countries

SELECT
    siteCountry as opt_key,
    siteCountry as opt_value,
    siteCountryName as opt_text
FROM [IED].[DB_VERSION].[Browse2_MapPOPUP]
GROUP BY siteCountry, siteCountryName
ORDER BY opt_text