From 0cdd512c1763bee29e8eec526eea18008da76e33 Mon Sep 17 00:00:00 2001
From: toyomoyo <toyomoyo>
Date: Fri, 29 Jun 2007 08:31:01 +0000
Subject: [PATCH] taking out some redundant sql

---
 lib/datalib.php | 10 ----------
 1 file changed, 10 deletions(-)

diff --git a/lib/datalib.php b/lib/datalib.php
index dc960c1002..d75ff3c47e 100644
--- a/lib/datalib.php
+++ b/lib/datalib.php
@@ -755,16 +755,6 @@ FROM
 WHERE 
     ra.userid=$userid
 UNION
-SELECT 
-    $fields 
-FROM 
-    {$CFG->prefix}role_assignments ra
-    INNER JOIN {$CFG->prefix}context x ON x.id=ra.contextid
-    INNER JOIN {$CFG->prefix}course_categories a ON x.instanceid=a.id AND x.contextlevel=40
-    INNER JOIN {$CFG->prefix}course c ON c.category=a.id
-WHERE 
-    ra.userid=$userid
-UNION
 SELECT
     $fields
 FROM
-- 
2.39.5