---

SELECT *, IF(LENGTH(`country_name_de`), `country_name_de`, `country_name_ru`) AS country_name FROM SC_countries ORDER BY country_name