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.