diff options
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 ) |