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 and articles in specified course
SELECT student_first_course, user_name, article_user_id, article_page_id, rev_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
    JOIN arwiki_p.ep_courses # join table for course_start and course_end timestamps
    ON student_first_course = course_id
    JOIN arwiki_p.revision
    ON article_page_id = rev_page
WHERE student_first_course = @course  OR article_course_id = @course
AND rev_user = student_id;
# GROUP BY user_name;
SQL

Checking query status...
