SQL
AخA
use arwiki_p;
SELECT concat(r.rev_user_text) AS "المستخدم", COUNT(*) AS "عدد المقالات"
FROM user INNER JOIN revision r
ON r.rev_user = user.user_id
INNER 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 20170619000000 AND 20170626000000 and r.rev_parent_id=0
AND user_registration BETWEEN 20170619000000 AND 20170626000000
AND p.page_id not in (select log_page from logging where log_page = p.page_id and log_type like "delete")
GROUP BY r.rev_user_text
ORDER BY COUNT(*) DESC
LIMIT 5;
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.