From 64f689e0d04cef7b711815f461fb8f6a23630b24 Mon Sep 17 00:00:00 2001 From: moodler Date: Mon, 18 Oct 2004 05:58:12 +0000 Subject: [PATCH] No need for DISTINCT when getting courses any more (only one table) --- lib/datalib.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/lib/datalib.php b/lib/datalib.php index a32019e50c7..07b4ece53c8 100644 --- a/lib/datalib.php +++ b/lib/datalib.php @@ -1760,7 +1760,7 @@ function get_courses($categoryid="all", $sort="c.sortorder ASC", $fields="c.*") $selectsql = "{$CFG->prefix}course c "; } - $courses = get_records_sql("SELECT DISTINCT $fields FROM $selectsql ORDER BY $sort"); + $courses = get_records_sql("SELECT $fields FROM $selectsql ORDER BY $sort"); if ($courses and (!$hideallinvisible) and (!$showallinvisible)) { // For ordinary users we need to check visibility foreach ($courses as $key => $course) { @@ -1820,7 +1820,7 @@ function get_courses_page($categoryid="all", $sort="c.sortorder ASC", $fields="c $selectsql = "{$CFG->prefix}course c "; } - $courses = get_records_sql("SELECT DISTINCT $fields FROM $selectsql ORDER BY $sort"); + $courses = get_records_sql("SELECT $fields FROM $selectsql ORDER BY $sort"); if ($courses and (!$hideallinvisible) and (!$showallinvisible)) { // For ordinary users we need to check visibility foreach ($courses as $key => $course) { -- 2.11.4.GIT