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

SQL

AخA
 
USE arwiki_p; #set the language/project database
        
SELECT c.course_id,c.course_start,c.course_end,u.user_id,u.user_name,a.article_page_title
    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
        LEFT JOIN ep_articles a
            ON a.article_user_id = u.user_id
            AND a.article_course_id IN (63)
WHERE c.course_id IN (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.
All SQL code is licensed under CC0 License.

Checking query status...