SQL
AخA
use arwiki_p;
SELECT concat('[[مستخدم:',r.rev_user_text,'|',r.rev_user_text,']]') AS "المستخدم", COUNT(*) AS "عدد المقالات"
FROM revision r
join page p on p.page_id=r.rev_page
WHERE p.page_namespace=0 and p.page_is_redirect=0
and r.rev_timestamp
between 20170201000000
and 20171210000000
and r.rev_parent_id=0
GROUP BY r.rev_user_text
ORDER BY COUNT(*) DESC
LIMIT 140;
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.