summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2022-10-31 10:50:45 +0100
committerYorhel <git@yorhel.nl>2022-10-31 10:50:45 +0100
commitaab523f8c663b22434f1e34167b204cd3cd8749b (patch)
tree3909928f788df34095c1cd12f5e3a9372a15868c
parent4cc3f229d21eb77eb7c93cab90e1b46ae2bd5378 (diff)
User::Page: Fix rlists counting query
-rw-r--r--lib/VNWeb/User/Page.pm2
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/VNWeb/User/Page.pm b/lib/VNWeb/User/Page.pm
index 64edb7b6..0815ebdc 100644
--- a/lib/VNWeb/User/Page.pm
+++ b/lib/VNWeb/User/Page.pm
@@ -69,7 +69,7 @@ sub _info_table_ {
WHERE NOT (labels && ARRAY[', \5, ',', \6, ']::smallint[]) AND uid =', \$u->{id}, $own ? () : 'AND NOT c_private'
)||0;
my $privrel = $own ? '1=1' : 'EXISTS(
- SELECT 1 FROM releases_vn rv JOIN ulist_vns uv ON uv.vid = rv.vid WHERE rv.id = r.rid AND NOT uv.c_private
+ SELECT 1 FROM releases_vn rv JOIN ulist_vns uv ON uv.vid = rv.vid WHERE uv.uid = r.uid AND rv.id = r.rid AND NOT uv.c_private
)';
my $rel = tuwf->dbVali('SELECT COUNT(*) FROM rlists r WHERE', $privrel, 'AND r.uid =', \$u->{id})||0;
td_ 'List stats';