List students and articles by course

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

SQL

Checking query status...