Changes between Version 5 and Version 6 of AdminTips

Timestamp:

2012-01-06T21:36:32Z (12 years ago)

Author:

Pan Luo

Comment:

--

AdminTips

@@ -26 +26 @@
     LEFT JOIN group_events ON group_events.group_id = groups.id 
     WHERE course_id = @COURSEID AND user_id IN 
-          SELECT id FROM users 
-          WHERE 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)