use arwiki_p;

SELECT concat('[[مستخدم:',actor_name,'|',actor_name,']]') AS "المستخدم", COUNT(*) AS "عدد المقالات"

FROM revision r

INNER JOIN actor ON r.rev_actor = actor.actor_id

INNER JOIN page p on r.rev_page = p.page_id

WHERE p.page_namespace =0 and p.page_is_redirect =0 and r.rev_timestamp between 20210101000000 and 20210711000000

and r.rev_parent_id =0

AND p.page_id not in (select log_page from logging where log_type like "delete" AND logging.log_timestamp between 20210710000000 and 20210711000000)

GROUP BY actor_name

ORDER BY COUNT(*) DESC;