SQL Query in /var/www/wces/var/www/oracle/oracle_listpane.php, line 191

    SELECT DISTINCT u.user_id, u.firstname, u.lastname, d.department_id, d.code, d.name
    FROM (SELECT class_id FROM wces_topics AS tsct WHERE tsct.make_public AND EXISTS (SELECT * FROM question_periods AS tscq WHERE tscq.question_period_id = tsct.question_period_id AND tscq.oracledate < (SELECT NOW()))) AS l
    INNER JOIN enrollments_p AS e ON e.class_id = l.class_id
    INNER JOIN users AS u ON u.user_id = e.user_id
    LEFT JOIN departments AS d USING (department_id)
    ORDER BY d.code, d.department_id, u.lastname
  

SQL Query in /var/www/wces/var/include/wbes/general.inc, line 46

      INSERT INTO warnings (url, file, line, uni, dump)
      VALUES ('http://wces.russ.yanofsky.org/oracle/oracle_listpane.php?mode=professors',
              '/var/www/wces/var/www/oracle/oracle_listpane.php',
               191,
              '',
              'Query failed.
Error message: 
Query: 
    SELECT DISTINCT u.user_id, u.firstname, u.lastname, d.department_id, d.code, d.name
    FROM (SELECT class_id FROM wces_topics AS tsct WHERE tsct.make_public AND EXISTS (SELECT * FROM question_periods AS tscq WHERE tscq.question_period_id = tsct.question_period_id AND tscq.oracledate < (SELECT NOW()))) AS l
    INNER JOIN enrollments_p AS e ON e.class_id = l.class_id
    INNER JOIN users AS u ON u.user_id = e.user_id
    LEFT JOIN departments AS d USING (department_id)
    ORDER BY d.code, d.department_id, u.lastname
  ');
      SELECT currval('warning_ids');