SELECT l.code, (COALESCE(lt.iface_name -> $1, lt.iface_name -> 'rus'))::text || ' — ' || (COALESCE(lt.iface_name -> l.code, lt.iface_name -> 'eng'))::text AS name, l.locale FROM languages AS l LEFT JOIN language_taxonomy AS lt ON (l.taxonomy_id = lt.id) WHERE l.iface IS TRUE ORDER BY code;

SELECT l.code, lt.iface_name -> 'rus' AS name FROM languages AS l LEFT JOIN language_taxonomy AS lt ON (l.taxonomy_id = lt.id) WHERE l.corpus IS TRUE ORDER BY 2;
/corpora/login.php