SQL
x
use cswiki_p;
select
user.user_id,
user.user_name,
courses.course_id
from
ep_courses as courses
join ep_users_per_course as upc on upc.upc_course_id = courses.course_id
join user on user.user_id = upc.upc_user_id
where
course_title like "%senio%" or course_title like "%Senio%" and
upc.upc_role = 1
;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.