Changes between Version 6 and Version 7 of AdminTips

Timestamp:

2012-01-06T21:49:50Z (13 years ago)

Author:

Pan Luo

Comment:

--

AdminTips

@@ -25 +25 @@
     LEFT JOIN groups_members ON groups.id = groups_members.group_id 
     LEFT JOIN group_events ON group_events.group_id = groups.id 
-    WHERE course_id = @COURSEID AND user_id IN 
-          (SELECT distinct(evaluator) FROM evaluation_mixevals WHERE event_id = @EVENTID AND evaluator NOT IN 
-              (SELECT distinct(submitter_id) FROM evaluation_submissions WHERE event_id = @EVENTID)
-          );;
+    WHERE
+        course_id = @COURSEID
+        AND event_id = @EVENTID
+        AND user_id IN 
+            (SELECT distinct(evaluator) FROM evaluation_mixevals WHERE event_id = @EVENTID AND evaluator NOT IN 
+                (SELECT distinct(submitter_id) FROM evaluation_submissions WHERE event_id = @EVENTID)
+            );
 }}}