From 33b8ead9040253f8a4c47abcc47aacd5311138e1 Mon Sep 17 00:00:00 2001
From: skodak <skodak>
Date: Sat, 19 Apr 2008 18:03:32 +0000
Subject: [PATCH] MDL-14018 fixed ugly query - thanks Eloy; merged from
 MOODLE_19_STABLE

---
 mod/data/field/multimenu/field.class.php | 6 ++----
 1 file changed, 2 insertions(+), 4 deletions(-)

diff --git a/mod/data/field/multimenu/field.class.php b/mod/data/field/multimenu/field.class.php
index 98ca922afa..a095d2c1db 100755
--- a/mod/data/field/multimenu/field.class.php
+++ b/mod/data/field/multimenu/field.class.php
@@ -79,11 +79,9 @@ class data_field_multimenu extends data_field_base {
 
         // display only used options
         $usedoptions = array();
-        $sql = "SELECT id, content
+        $sql = "SELECT DISTINCT content
                   FROM {$CFG->prefix}data_content
-                 WHERE fieldid={$this->field->id}
-              GROUP BY content
-              ORDER BY content";
+                 WHERE fieldid={$this->field->id}";
         if ($used = get_records_sql($sql)) {
             foreach ($used as $data) {
                 $valuestr = $data->content;
-- 
2.39.5