diff options
author | Yorhel <git@yorhel.nl> | 2021-06-26 12:28:31 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2021-06-26 12:28:31 +0200 |
commit | e9a20c4bde06f232d3a93c6cb5a4c69fe50aaa39 (patch) | |
tree | db8b32a8fad15a2eddfcab39c0059aca082c693c /lib/VNWeb/Misc | |
parent | 85e7716b610baca80b9e120cfbb62d6d9f971e54 (diff) |
Exclude MTL releases from the homepage
Diffstat (limited to 'lib/VNWeb/Misc')
-rw-r--r-- | lib/VNWeb/Misc/HomePage.pm | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/lib/VNWeb/Misc/HomePage.pm b/lib/VNWeb/Misc/HomePage.pm index 865ec213..12d4034f 100644 --- a/lib/VNWeb/Misc/HomePage.pm +++ b/lib/VNWeb/Misc/HomePage.pm @@ -177,6 +177,7 @@ sub releases_ { SELECT id, title, original, released FROM releases r WHERE NOT hidden AND ', $filt->sql_where(), ' + AND NOT EXISTS(SELECT 1 FROM releases_lang rl WHERE rl.id = r.id AND rl.mtl) ORDER BY released', $released ? 'DESC' : '', ', id LIMIT 10' ); enrich_flatten plat => id => id => 'SELECT id, platform FROM releases_platforms WHERE id IN', $lst; |