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 count, frequency FROM evn.mv_normalised_wordform_frequencies WHERE wordform = $1;

Частотность: 0,000% ( употреблений)


SELECT l.wordform, count(l.wordform) AS quantity FROM evn.t_normalised_wordforms AS m LEFT JOIN evn.t_normalised_wordforms AS l USING (sentence) WHERE m.wordform = $1 AND m.position = l.position + 1 GROUP BY m.wordform, l.wordform ORDER BY quantity DESC, l.wordform ASC LIMIT 12;

Наиболее частые левые соседи: нет


SELECT r.wordform, count(r.wordform) AS quantity FROM evn.t_normalised_wordforms AS m LEFT JOIN evn.t_normalised_wordforms AS r USING (sentence) WHERE m.wordform = $1 AND m.position = r.position - 1 GROUP BY m.wordform, r.wordform ORDER BY quantity DESC, r.wordform ASC LIMIT 12;

Наиболее частые правые соседи: нет

Варианты морфологического разбора


SELECT analysis, lemma FROM evn.t_analysis WHERE wordform = $1;

Графическое представление соседства (скрыть)


WITH a AS (SELECT sentence FROM evn.mv_normalised_wordforms WHERE wordform = lower($1)) SELECT normalised FROM evn.sentences, a WHERE id = a.sentence ORDER BY random() LIMIT 7;

Примеры в контексте (скрыть)


SELECT text, b.name_short || ' (' || date_part('year', b.recorded_date) || ')', count(text) FROM evn.t_normalised_wordforms AS a LEFT OUTER JOIN evn.texts AS b ON (text = id) WHERE wordform = $1 GROUP BY wordform, b.name_short, b.recorded_date, text ORDER BY 2;

Форма бирэн встречается в 0 текстах:

ТекстКоличество употреблений
Итого0