summaryrefslogtreecommitdiff
path: root/lib/VNWeb/Chars/List.pm
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2021-01-29 10:08:29 +0100
committerYorhel <git@yorhel.nl>2021-01-29 10:08:43 +0100
commit6e7e9ea7ef755e0017f363409b11353aee86b471 (patch)
treead65173c8a6740171710073cbd48a6ff056fbcb5 /lib/VNWeb/Chars/List.pm
parent623c9e011b2411869f20b2e41c0a025c18de5bf2 (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.pm2
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', $_, '