From f4a5a668f72e80b06c0d47e248c39c25eca0293b Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Mon, 24 Apr 2023 11:35:34 +0200
Subject: [news] Don't show duplicates in list of locs with overrides

---
 modules-available/news/page.inc.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/modules-available/news/page.inc.php b/modules-available/news/page.inc.php
index 852aaae5..a122d37c 100644
--- a/modules-available/news/page.inc.php
+++ b/modules-available/news/page.inc.php
@@ -182,7 +182,7 @@ class Page_News extends Page
 			$data['location_name'] = Location::getName($this->locationId);
 		} else {
 			// Superadmin can see all overridden locations
-			$data['overridden'] = Database::queryAll("SELECT l.locationid, l.locationname FROM vmchooser_pages
+			$data['overridden'] = Database::queryAll("SELECT DISTINCT l.locationid, l.locationname FROM vmchooser_pages
 				INNER JOIN location l USING (locationid)
 				WHERE expires > UNIX_TIMESTAMP() ORDER BY locationname ASC");
 		}
-- 
cgit v1.2.3-55-g7522