Untitled query #38555

SQL

use arwiki_p;
    SELECT actor_name,
    SUM(CASE WHEN rev_timestamp BETWEEN 20190301000000 AND 20191001000000 THEN 1 ELSE 0 END) AS recent_user_editcount
    FROM user 
    INNER JOIN revision ON user.user_id = revision.rev_actor
    INNER JOIN actor ON revision.rev_actor = actor.actor_id
    join page p on p.page_id= revision.rev_page
    WHERE actor_name like "إسلام%"#actor_name IN (SELECT user_name FROM user_groups INNER JOIN user ON user_id = ug_user WHERE ug_group = 'sysop')
    and p.page_namespace = 4
    GROUP BY actor_name
    ORDER BY recent_user_editcount DESC;
SQL

Checking query status...
