summaryrefslogtreecommitdiff
path: root/lib/VNWeb/Misc
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2021-06-26 12:28:31 +0200
committerYorhel <git@yorhel.nl>2021-06-26 12:28:31 +0200
commite9a20c4bde06f232d3a93c6cb5a4c69fe50aaa39 (patch)
treedb8b32a8fad15a2eddfcab39c0059aca082c693c /lib/VNWeb/Misc
parent85e7716b610baca80b9e120cfbb62d6d9f971e54 (diff)
Exclude MTL releases from the homepage
Diffstat (limited to 'lib/VNWeb/Misc')
-rw-r--r--lib/VNWeb/Misc/HomePage.pm1
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;