diff options
| author | lonkaars <loek@pipeframe.xyz> | 2023-07-11 00:46:07 +0200 |
|---|---|---|
| committer | lonkaars <loek@pipeframe.xyz> | 2023-07-11 00:46:07 +0200 |
| commit | 479836dbf3c7cc6e5940abe698ccc5e1d7b440c7 (patch) | |
| tree | b799e4f584ea893e9c4f642dcbfb97c095104a8f /db | |
| parent | 659f5acfd161d91dc8a9d0101535dcee585455ad (diff) | |
fix http client/server and irregular suru/kuru readings for api/word.ts
Diffstat (limited to 'db')
| -rw-r--r-- | db/find.sql | 4 |
1 files changed, 2 insertions, 2 deletions
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 ) |