summaryrefslogtreecommitdiff
path: root/lib/VNDB
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2020-04-06 16:41:42 +0200
committerYorhel <git@yorhel.nl>2020-04-06 16:41:42 +0200
commit6b04feb79ced4571150a64c19fd70539aa4596fb (patch)
tree5951e69d30802bdad527483d9e7e220ef59b0b53 /lib/VNDB
parent2ef428500e5100504a7c7422d5d724e0c50618d6 (diff)
DB::VN: Fix 500 by randomly generating a "sf0" vndbid
Diffstat (limited to 'lib/VNDB')
-rw-r--r--lib/VNDB/DB/VN.pm2
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/VNDB/DB/VN.pm b/lib/VNDB/DB/VN.pm
index 64fab011..5b0fa932 100644
--- a/lib/VNDB/DB/VN.pm
+++ b/lib/VNDB/DB/VN.pm
@@ -335,7 +335,7 @@ sub dbScreenshotRandom {
JOIN vn v ON v.id = vs.id
WHERE NOT v.hidden AND NOT vs.nsfw
AND s.id IN(
- SELECT vndbid('sf', floor(random() * (select last_value from screenshots_seq))::int)
+ SELECT vndbid('sf', floor(1 + random() * (select last_value from screenshots_seq))::int)
FROM generate_series(1,20)
LIMIT 20
)