Total edits (bytes) and count for a user

SQL

/*
DESCRIBE arwiki_p.ep_articles
DESCRIBE arwiki_p.ep_courses
course_id
course_start
course_end
*/
#SET @course = 63;

#SELECT course_id, course_name, course_start, course_end
#FROM arwiki_p.ep_courses WHERE course_id = @course;

# DESCRIBE arwiki_p.revision;
# DESCRIBE arwiki_p.ep_courses;
# DESCRIBE arwiki_p.ep_articles;

SELECT user_name, user_id, rev.rev_id, rev.rev_parent_id, rev.rev_len AS rev_len, parent.rev_len AS parent_rev_len, parent.rev_len-rev.rev_len AS rev_diff
	FROM arwiki_p.user
    	JOIN arwiki_p.revision rev
        ON user_id = rev.rev_user
        JOIN arwiki_p.revision parent #self join for parent length
        ON rev.rev_parent_id = parent.rev_id
	WHERE user_name = "TFlanagan-WMF"
SQL

Checking query status...
