From d0508099c6e86a3b270dfc41e78871c43cbba25c Mon Sep 17 00:00:00 2001
From: jamiesensei <jamiesensei>
Date: Fri, 7 Sep 2007 08:01:08 +0000
Subject: [PATCH] oops. Stray 'as' used for table name alias in SQL.

---
 lib/questionlib.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/lib/questionlib.php b/lib/questionlib.php
index 9f76f8827d..dab9ffb43b 100644
--- a/lib/questionlib.php
+++ b/lib/questionlib.php
@@ -1673,7 +1673,7 @@ function get_categories_for_contexts($contexts, $sortorder = 'parent, sortorder,
     return get_records_sql("
             SELECT *, (SELECT count(1) FROM {$CFG->prefix}question q
                     WHERE c.id = q.category AND q.hidden='0' AND q.parent='0') as questioncount
-            FROM {$CFG->prefix}question_categories as c
+            FROM {$CFG->prefix}question_categories c
             WHERE c.contextid IN ($contexts)
             ORDER BY $sortorder");
 }
-- 
2.39.5