Students in old EP interface

This query is marked as a draft This query has been published by Martin Urbanec.

SQL

use cswiki_p;select user_name from ep_users_per_course join user on upc_user_id=user_id where upc_course_id in (select course_id from ep_courses where course_org_id not in (17,19,3,13,16,11,12,10,9,18,20) and course_start>="20161001000000") and upc_role=0;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...