SQL
x
USE arwiki_p; #set the language/project database
SELECT a.article_course_id, a.article_user_id, a.article_page_title, SUM(CAST(r.rev_len as signed) - CAST(COALESCE(p.rev_len,0) as signed)) AS bytes_added, COUNT(r.rev_id) AS edit_count
FROM ep_articles a
JOIN revision r
ON r.rev_page = a.article_page_id
LEFT OUTER JOIN revision p
ON p.rev_id = r.rev_parent_id
WHERE article_course_id IN (63)
GROUP BY article_page_title
ORDER BY bytes_added DESC;
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)
GROUP BY article_page_title
ORDER BY course_id, article_page_title;
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.