diff options
author | Yorhel <git@yorhel.nl> | 2020-04-06 16:41:42 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2020-04-06 16:41:42 +0200 |
commit | 6b04feb79ced4571150a64c19fd70539aa4596fb (patch) | |
tree | 5951e69d30802bdad527483d9e7e220ef59b0b53 /lib/VNDB | |
parent | 2ef428500e5100504a7c7422d5d724e0c50618d6 (diff) |
DB::VN: Fix 500 by randomly generating a "sf0" vndbid
Diffstat (limited to 'lib/VNDB')
-rw-r--r-- | lib/VNDB/DB/VN.pm | 2 |
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 ) |