diff options
author | Yorhel <git@yorhel.nl> | 2022-10-31 10:50:45 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2022-10-31 10:50:45 +0100 |
commit | aab523f8c663b22434f1e34167b204cd3cd8749b (patch) | |
tree | 3909928f788df34095c1cd12f5e3a9372a15868c | |
parent | 4cc3f229d21eb77eb7c93cab90e1b46ae2bd5378 (diff) |
User::Page: Fix rlists counting query
-rw-r--r-- | lib/VNWeb/User/Page.pm | 2 |
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'; |