Arwiki student contribs tool

SQL

/*
Trying to calculate the total contributions for users listed on a course in the education extension.
Goal is to output a list of users, total edit size and total edit count, within the parameters of the course:
- limit to articles listed on course page
- limit to dates listed on course page
*/
SET @course = 63;

#List of users in specified course
SELECT course_id, student_user_id, user_id, user_name, article_page_id,
FROM arwiki_p.ep_students
	JOIN arwiki_p.user 
    ON student_user_id = user_id
    LEFT OUTER JOIN arwiki_p.ep_articles
    ON student_user_id = article_user_id
WHERE student_first_course = @course AND article_course_id = @course;

#List of articles in specified course
/* SELECT article_course_id AS cousre_id, article_user_id AS student_user_id, *//*article_page_title, article_page_id, user_name, user_id
FROM arwiki_p.ep_articles, arwiki_p.user WHERE article_course_id = @course
AND article_user_id = user_id;
*/
SQL

Checking query status...
