summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2021-07-31 07:45:06 +0200
committerYorhel <git@yorhel.nl>2021-07-31 07:45:06 +0200
commit05f2c0127f65bdcad0cd04af4570016288d797f1 (patch)
tree7164bd2441caa1f046e1a3fba7465771951037dd
parent45df2ef26b7df9d43093655f56e345d717a737a3 (diff)
Filters: Fix conversion of old tag name filters
-rw-r--r--lib/VNWeb/Filters.pm2
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/VNWeb/Filters.pm b/lib/VNWeb/Filters.pm
index 93776392..fa4181b7 100644
--- a/lib/VNWeb/Filters.pm
+++ b/lib/VNWeb/Filters.pm
@@ -102,7 +102,7 @@ sub filter_vn_compat {
next if !$l;
$l = [ map lc($_), ref $l ? @$l : $l ];
$fil->{ s/^tag/tag_/rg } ||= [ map $_->{id}, tuwf->dbAlli(
- 'SELECT DISTINCT id FROM tags LEFT JOIN tags_aliases ON id = tag WHERE searchable AND lower(name) IN', $l, 'OR lower(alias) IN', $l
+ 'SELECT DISTINCT id FROM tags WHERE searchable AND lower(name) IN', $l
)->@* ];
$mod++;
}