From 479836dbf3c7cc6e5940abe698ccc5e1d7b440c7 Mon Sep 17 00:00:00 2001 From: lonkaars Date: Tue, 11 Jul 2023 00:46:07 +0200 Subject: fix http client/server and irregular suru/kuru readings for api/word.ts --- db/find.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'db') diff --git a/db/find.sql b/db/find.sql index 6c8a80e..1d31217 100644 --- a/db/find.sql +++ b/db/find.sql @@ -63,8 +63,8 @@ with results(id, expression, reading, tags, depth, rules, original, deinflected) deinflections.term from deinflections inner join term on (term.expression = deinflections.term) or (term.reading = deinflections.term) - inner join term_tag on term_tag.term_id = term.id - inner join tag on term_tag.tag_id = tag.id + left join term_tag on term_tag.term_id = term.id + left join tag on term_tag.tag_id = tag.id group by term.id, deinflections.original, deinflections.rules having term.id is not null ) -- cgit v1.2.3