Get user list from ep_course table

This query is marked as a draft This query has been published by Tflanagan (WMF).

Same function as the List Students API, but could be combined with other queries/tables to auto-magically compute some interesting metrics.

Next up, computing total contribs for courses within specified time window for registered users in main namespace.
Alternatively, limit contribs to articles that are associated with the course and user under same constraints.

SQL

USE arwiki_p; #set the language/project database
        
SELECT c.course_id,c.course_start,c.course_end,u.user_id,u.user_name
	FROM ep_courses c
    	LEFT JOIN user u
        	ON u.user_id = if(instr(c.course_students,concat(":",u.user_id,";"))>0,u.user_id,c.course_students)
        	AND u.user_id > 1000 #to weed out the registration numbers
WHERE course_id IN (2,56,63)
ORDER BY course_id, user_name; #option to specify specific courses or single course

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...