summaryrefslogtreecommitdiffstats
path: root/modules-available/news/page.inc.php
diff options
context:
space:
mode:
Diffstat (limited to 'modules-available/news/page.inc.php')
-rw-r--r--modules-available/news/page.inc.php2
1 files changed, 1 insertions, 1 deletions
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");
}