From 178ccd11c042d1c92419f286773538c90da256cc Mon Sep 17 00:00:00 2001
From: mjollnir_ <mjollnir_>
Date: Mon, 7 Feb 2005 09:22:07 +0000
Subject: [PATCH] Fixing bug 2479. Can't figure out a way to do it with a left
 join at this stage but the query doesn't look too bad.  Anyone who thinks
 they can figure out a more elegant way for it is welcome\!

---
 lib/datalib.php | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

diff --git a/lib/datalib.php b/lib/datalib.php
index 0094ee2f3c..36d7c228e0 100644
--- a/lib/datalib.php
+++ b/lib/datalib.php
@@ -1356,8 +1356,9 @@ function get_courses_notin_metacourse($metacourseid,$count=false) {
     else {
         $sql = "SELECT c.id,c.shortname,c.fullname";
     }
-    $sql .= " FROM {$CFG->prefix}course c LEFT  JOIN {$CFG->prefix}course_meta mc ON mc.child_course = c.id
-     WHERE (mc.parent_course IS NULL OR mc.parent_course != $metacourseid) AND c.id != $metacourseid AND c.id != $site->id AND c.metacourse != 1";
+
+    $sql .= " FROM {$CFG->prefix}course c WHERE c.id NOT IN (".implode(',',array_keys(get_courses_in_metacourse($metacourseid))).") AND c.id !=8 and c.id != 1 and c.metacourse != 1";
+
     return get_records_sql($sql);
 }
 
-- 
2.39.5