SQL
AخA
SELECT SUM(total_bytes_changed) AS sum_total_bytes_changed
FROM (
SELECT rc_new_len - rc_old_len AS total_bytes_changed
FROM recentchanges
JOIN page ON recentchanges.rc_cur_id = page.page_id
WHERE page.page_namespace = 0
AND recentchanges.rc_timestamp >= DATE_SUB(NOW(), INTERVAL 1 WEEK)
) AS subquery;
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.