Arwiki contribs by course for student user total edits (bytes, count)

This query is marked as a draft This query has been published by Tflanagan (WMF).

Map the revisions of education course articles to students and aggregate contribtuions.

Copy code and run for more up to date data. Last updated here on Friday, 04-Sep-15 03:16:44 UTC.

Table is based on users from the ep_students table which doesn't seem to be accurate, especially for previous courses (like when users have been in multiple courses, it may not list all the courses for that user).

SQL

SET @course = 63; #use any course id number
SET @articles = arwiki_p.ep_articles;

SELECT article_page_id, article_page_title
	FROM @articles
    WHERE article_course_id = @course

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...