diff options
| author | Yorhel <git@yorhel.nl> | 2022-05-10 10:06:52 +0200 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2022-05-10 10:06:54 +0200 |
| commit | 6a72cc77b2331dbab8dd66134987206197b19078 (patch) | |
| tree | 299894eacd6b4e192d3d8b0286ca95376e5b6bae | |
| parent | afd47ae5a1c2c7cf888acec4c64d41cf49a0a4e8 (diff) | |
Exclude unofficial releases when determining VN release date
Fixes https://vndb.org/t2520.650
| -rw-r--r-- | sql/func.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/func.sql b/sql/func.sql index 417c3d48..0336a6a9 100644 --- a/sql/func.sql +++ b/sql/func.sql @@ -51,6 +51,7 @@ CREATE OR REPLACE FUNCTION update_vncache(vndbid) RETURNS void AS $$ AND rv.rtype <> 'trial' AND r.hidden = FALSE AND r.released <> 0 + AND r.official GROUP BY rv.vid ), 0), c_languages = ARRAY( |