SQL
x
USE arwiki_p;
USE arwiki_p;
SELECT
rev_user_text AS المستخدم,
page_namespace AS النطاق,
COUNT(rev_timestamp) AS عدد_التعديلات
FROM revision
JOIN page ON rev_page = page_id
WHERE rev_timestamp BETWEEN 20160101000000 AND 20160731235959
AND rev_user_text = "Elph"
GROUP BY (page_namespace)
ORDER BY COUNT(rev_timestamp)
;
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.