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 |