diff options
author | Yorhel <git@yorhel.nl> | 2021-01-29 10:08:29 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2021-01-29 10:08:43 +0100 |
commit | 6e7e9ea7ef755e0017f363409b11353aee86b471 (patch) | |
tree | ad65173c8a6740171710073cbd48a6ff056fbcb5 /lib/VNWeb/Chars/List.pm | |
parent | 623c9e011b2411869f20b2e41c0a025c18de5bf2 (diff) |
Chars::List: Fix duplicate listing of VNs
Fixes the second part of https://vndb.org/t2520.538
Diffstat (limited to 'lib/VNWeb/Chars/List.pm')
-rw-r--r-- | lib/VNWeb/Chars/List.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/VNWeb/Chars/List.pm b/lib/VNWeb/Chars/List.pm index f35e1d3e..2f944156 100644 --- a/lib/VNWeb/Chars/List.pm +++ b/lib/VNWeb/Chars/List.pm @@ -32,7 +32,7 @@ sub listing_ { # Also used by VNWeb::TT::TraitPage sub enrich_listing { enrich vn => id => cid => sub { sql ' - SELECT cv.id AS cid, v.id, v.title, v.original + SELECT DISTINCT cv.id AS cid, v.id, v.title, v.original FROM chars_vns cv JOIN vn v ON v.id = cv.vid WHERE NOT v.hidden AND cv.id IN', $_, ' |