Untitled query #36738

SQL

use arwiki_p;
SELECT actor_name AS "المستخدم", COUNT(*) AS "عدد المقالات"
    FROM user 
    INNER JOIN revision r
    ON r.rev_actor = user.user_id
    INNER JOIN page p on p.page_id=r.rev_page
    INNER JOIN actor ON actor.actor_id = r.rev_actor
WHERE p.page_namespace=0 and p.page_is_redirect=0 and r.rev_timestamp between "20190501000000" AND "20190701000000" and r.rev_parent_id=0
AND user_registration between "20190401000000" AND "20190701000000"
AND p.page_id not in (select log_page from logging where log_type like "delete" AND logging.log_timestamp between "20190601000000" AND "20190701000000")
GROUP BY actor_name
having COUNT(*) > 1
ORDER BY COUNT(*) DESC
LIMIT  50;
SQL

Checking query status...
