From 568349fee7b426fd80b58864f5bd87b90580037f Mon Sep 17 00:00:00 2001 From: Dan Poltawski Date: Tue, 18 Dec 2012 14:26:55 +0800 Subject: [PATCH] MDL-36259 - change case of table alias to match definition --- course/search.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/course/search.php b/course/search.php index 805512f2784..1dda021206c 100644 --- a/course/search.php +++ b/course/search.php @@ -176,7 +176,7 @@ if (!empty($blocklist) and confirm_sesskey()) { $blockname = $DB->get_field('block', 'name', array('id' => $blocklist)); $courses = array(); list($select, $join) = context_instance_preload_sql('c.id', CONTEXT_COURSE, 'ctx'); - $sql = "SELECT C.* $select FROM {course} c + $sql = "SELECT c.* $select FROM {course} c $join JOIN {block_instances} bi ON bi.parentcontextid = ctx.id WHERE bi.blockname = ?"; $courses = $DB->get_records_sql($sql, array($blockname)); -- 2.43.0